Progress
Database Administration
Guide and Reference


Using the Schema Mover After Conversion

When you complete the conversion from a Version 8 to a Version 9 database, the database’s schema and data are located within the Schema Area (Area 6). After conversion, it is possible to move data into new areas by using PROUTIL dump and load or bulkload qualifiers, the Database Administration Tool, the Database Dictionary, or 4GL code. However, as long as schema remains in an area, the area continues to hold disk space, even after the removal of data. To free this disk space, use PROUTIL with the Schema Mover qualifier to remove the schema. Once the area’s schema is removed the area can be truncated.

Follow these steps to move schema to a new area:

  1. Truncate the database’s BI file. PROUTIL will send an error message if you do not.
  2. Back up the database.

CAUTION: PROUTIL with the MVSCH qualifier is a non-recoverable utility. If the execution fails, you cannot connect to the database.
  1. Enter the following syntax, where dbname is the name of the converted database, to begin the schema move:
    SYNTAX
    proutil dbname -C mvsch

As shown in Figure 4–1, after you convert your database from Version 8 to Version 9, Area 6 (NewDB.db) contains both the database’s schema and data. When you initiate the schema move by entering the syntax shown in Step 3, PROUTIL finds the next unused data area (starting at Area 7) and creates the target data area and the target data area’s extent. After creating the target data area, PROUTIL moves the schema from NewDB.db to NewDB_7.d1. All the schema records and indexes are deleted from NewDB.db. PROUTIL opens the .d1 files of the NewDB.db and NewDB_7.d1 and then updates and switches the master and area blocks. After the switch, the areas and their extents are renamed. Now that the schema is gone from the “Old Default Area,” you can truncate it and recover any unused space.

NOTE: Data in the “Old Default Area” not moved prior to area truncation will be lost.

Figure 4–1: How The Schema Mover Works


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095