SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
5-129
Example of UPGRADE
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
Example of UPGRADE
This example transforms all the metadata to the /usr/dbadmin/upgradeLog file:
UPGRADE ALL METADATA LOG TO OUTFILE /usr/dbadmin/upgradeLog
CLEAR;
The following is an excerpt from the output file.
*************** Time: <time> Process: <process> Log opened
***************
The UPGRADE ALL METADATA has started
...
Schema XCAT.ASCH will be upgraded from version 1200 to version 3000
Schema YCAT.ASCH will be upgraded from version 1200 to version 3000
Schema YCAT.ZSCH will be upgraded from version 1200 to version 3000
Schema ZCAT.SCH1 will be upgraded from version 1200 to version 3000
Schema ZCAT.SCH2 will be upgraded from version 1200 to version 3000
...
Creating version 3000 definition schema for catalog XCAT
Upgrading version 1200 metadata to version 3000 for affected schemas in
catalog XCAT
Set schema version to 3000 for XCAT.ASCH
Remove XCAT.DEFINITION_SCHEMA_VERSION_1200
Schema XCAT.ASCH has been upgraded from version 1200 to version 3000.
Creating version 3000 definition schema for catalog YCAT
...
Set schema version to 3000 for ZCAT.SCH1
Set schema version to 3000 for ZCAT.SCH2
Schema ZCAT.SCH1 has been upgraded from version 1200 to version 3000.
Schema ZCAT.SCH2 has been upgraded from version 1200 to version 3000.
Remove ZCAT.DEFINITION_SCHEMA_VERSION_1200
The UPGRADE ALL METADATA has completed