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-11
Considerations for DOWNGRADE
Error Conditions
The following are examples of the error conditions that might occur while executing the
DOWNGRADE utility:

An affected schema has a schema version that is lower than the target version

No schemas are affected by the operation

An object in an affected schema has an object feature version (OFV) that is higher
than the target version

The target version is not a valid schema version

The RESTRICT option is specified or no option is specified, and one or more
related catalogs exist

All the following conditions are met :

One or more user schemas are participating in a downgrade to version 1200

The system schema version is higher than 1200

The system schema is not involved in the downgrade

Concurrent DOWNGRADE operations are not supported
Recovery of a Failed DOWNGRADE Utility
The RECOVER command allows for recovery of a failed DOWNGRADE command.
catalog
specifies the ANSI name of the catalog that is specified in the original
DOWNGRADE command.
RESUME
enables you to continue the processing of the original command, starting at the
point of interruption.
RECOVER ALL METADATA
[ RESUME | CANCEL ]
[ output-spec ]
RECOVER ALL METADATA IN CATALOG catalog
[ RESUME | CANCEL ]
[ output-spec ]