SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-13
Example of DOWNGRADE
The following is an excerpt from the output file.
*************** Time: <time> Process: <process> Log opened
***************
The DOWNGRADE ALL METADATA TO VERSION 1200 has started
Schema CAT.SCH will be downgraded from version 3000 to version 1200
...
Creating version 1200 definition schema for catalog CAT
Downgrading version 3000 metadata to version 1200 for affected schemas in
catalog CAT
Set schema version to 1200 for CAT.SCH
Updating file labels for affected schemas in catalog CAT
Remove CAT.DEFINITION_SCHEMA_VERSION_3000
Schema CAT.SCH has been downgraded from version 3000 to version 1200
...
The DOWNGRADE ALL METADATA TO VERSION 1200 has completed
Note. The date-time-processid prefix of each line and the output for schemas in the system
catalog are not displayed in the output file.