SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-177
Example of DOWNGRADE
output-spec
corresponds to the output-spec for DOWNGRADE.
The RECOVER command must use the same mode of operation as the original
DOWNGRADE command:
•
If the original DOWNGRADE uses the ALL METADATA mode of operation, then
the RECOVER must also use the ALL METADATA mode of operation.
•
If the original DOWNGRADE uses the ALL METADATA IN CATALOG catalog
mode of operation then the RECOVER must also use the ALL METADATA IN
CATALOG catalog mode of operation, and must specify the same catalog name.
In a distributed environment, the RECOVER command must be issued from the same
system where the original DOWNGRADE command was run.
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 metadata to version 1200:
DOWNGRADE ALL METADATA TO VERSION 1200;
The following is an excerpt from the output file.
Note. The RECOVER command does not need CASCADE option as it automatically recovers
the metadata for those catalogs that are affected by the original DOWNGRADE command.
*************** 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