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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—640322-001
5-121
UPGRADE Utility
UPGRADE Utility
Considerations for UPGRADE
Example of UPGRADE
UPGRADE is a syntax-based utility that can be executed through MXCI. The
UPGRADE utility transforms all metadata that is visible on the local node from its
existing version to the current schema version for the SQL/MX software version (MXV).
This includes the schemas in the system catalog. The REPORTONLY option allows you
to test if the operation can be executed without actually performing the operation.
[optional output spec]
corresponds to the output options.
Considerations for UPGRADE
Command Output for UPGRADE
The UPGRADE utility supports the following command output options:
•
REPORTONLY
If the REPORTONLY option is specified, only the initial error checking is performed
and no upgrading takes place. If the LOG TO option is also specified, the list of
affected schemas to be upgraded is written to the output file.
•
LOG TO
If the LOG TO option is specified, the command writes a log of its progress to either
the specified oss-file or to the home terminal. If the CLEAR option is used and if
oss-file is an existing disk file, oss-file is cleared before logging begins.
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.
UPGRADE ALL METADATA
[optional output spec]
optional output spec is:
[ { [ LOG TO ] OUTFILE oss-file
[ CLEAR ] | LOG TO HOMETERM } ] [ REPORTONLY ]
Note. The UPGRADE utility is available only on systems running J06.11 and later J-series
RVUs and H06.22 and later H-series RVUs.
************** Time: <time> Process: <process> Log opened **************