CXX Upgrade › New Version 12 Database Format › Change One or More Databases from FORMAT 2 to FORMAT 1

Change One or More Databases from FORMAT 2 to FORMAT 1

To change a database from FORMAT 2 to FORMAT 1, perform the following steps.

Note: This procedure is intended for special case test systems only.

1. Execute the function DBUTLTY CXXMAINT OPTION=FORMAT0201 (optional keyword, DBID=value).
2. If the index is set to dynamic extend in cylinders, converts to tracks.
3. If there are multiple index data sets, removes them with warning message (DB13278W) but RC 0.
4. If any data area is set to dynamic extend in cylinders, converts to tracks.
5. Sets the tables index loaded or not based on every key definition being loaded.
6. Keeps every key definition in CXX as a normal key losing any other status, such as being created or dropped (not visible to users).
7. Sets selected database as FORMAT 1.