SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-7
Example of DOWNGRADE
Error Conditions
The following are the error conditions that might occur while executing the RECOVER
command:
•
An involved node has an incompatible version (because the version of the node
was changed between the time of the original operation and the time of recover)
•
No corresponding UPGRADE or DOWNGRADE operation is recorded
•
The original command is still active
Example of DOWNGRADE
This example transforms all the metadata to the 1200 SQL/MX version:
DOWNGRADE ALL METADATA TO VERSION 1200;
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.