SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—640322-001
5-122
Considerations for UPGRADE
Log file messages correspond to the EMS event messages. Regardless of the LOG
TO option, the UPGRADE utility will generate EMS events to the $0 primary
collector that documents the progress of the command. For information about error
messages, see the SQL/MX Messages Manual.
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
Recovery of a Failed UPGRADE Utility
The RECOVER command is extended to allow recovery of a failed UPGRADE
command.
RESUME
enables you to continue 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.
optional output spec
correspond to the output options.
Error Conditions
The following are examples of 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 modified 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
RECOVER ALL METADATA
[ RESUME | CANCEL ]
[ optional output spec ]
optional output spec is:
[ { [ LOG TO ] OUTFILE oss-file
[ CLEAR ] | LOG TO HOMETERM } ] [ REPORTONLY ]