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-139
Considerations for UPGRADE
Error Conditions
The following are examples of the error conditions that might occur while executing the
UPGRADE utility:

An affected schema has a schema version that is higher than the target version.

No schemas are affected by the operation.

The RESTRICT option is specified or no option is specified, and one or more
related catalogs exist.

All of the following conditions are met:

The system catalog participates in the operation

Version 1200 schemas which do not participate in the operation exist on the
system

Concurrent UPGRADE operations are not supported.
Recovery of a Failed UPGRADE Utility
The RECOVER command is extended to allow recovery of a failed UPGRADE
command. Starting with SQL/MX 3.2, the UPGRADE utility also allows recovery of an
UPGRADE of metadata in an individual catalog.
catalog
specifies the ANSI name of the catalog that was specified in the original
UPGRADE command.
RESUME
enables you to continue with the processing of the original command, starting at
the point of interruption.
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
is the same as for the UPGRADE operation.
RECOVER ALL METADATA
[ RESUME | CANCEL ]
[ output-spec ]
RECOVER ALL METADATA IN CATALOG catalog
[ RESUME | CANCEL ]
[ output-spec ]