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-12
Example of DOWNGRADE
CANCEL
enables you to revert the changes made by the original command, thereby
returning the database to its original state. The default value is CANCEL.
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;
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.