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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—640322-001
5-5
Considerations for DOWNGRADE
Otherwise, the output is appended to the existing contents of oss-file. The
following is the format of the first line of log output:
The format enables you to recognize a log file easily. A command is rejected if it
specifies an existing non-empty oss-file that is not a log file.
Log file messages correspond to the EMS event messages. Regardless of the LOG
TO option, the DOWNGRADE 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
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
Recovery of a Failed DOWNGRADE Utility
The RECOVER command is extended to allow recovery of a failed DOWNGRADE
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.
************** Time: <time> Process: <process> Log opened **************
RECOVER ALL METADATA
[ RESUME | CANCEL ]
[ optional output spec ]
optional output spec is:
[ { [ LOG TO ] OUTFILE oss-file
[ CLEAR ] | LOG TO HOMETERM } ] [ REPORTONLY ]