Progress
Database Administration
Guide and Reference
PROUTIL MVSCH Qualifier
Frees disk space by moving schema after converting a database from Version 8 to Version 9.
SYNTAX
db-name
Specifies the name of the converted database.
NOTES
- After a database is converted from Version 8 to Version 9, 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, Area 6 continues to hold disk space, even after the removal of data, because the schema remains. Once the area’s schema is removed by using PROUTIL MVSCH, Area 6 can be truncated.
- You must truncate the database’s BI file before using PROUTIL MVSCH.
CAUTION: PROUTIL with the mvsch qualifier is a non-recoverable utility. If the execution fails, you cannot connect to the database.- Always backup the database before using PROUTIL MVSCH.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |