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-138
Considerations for UPGRADE
output-spec
corresponds to the output options.
Considerations for UPGRADE
Modes of Operation for UPGRADE
The following are two modes of operation for the UPGRADE utility:

ALL METADATA
This mode of operation upgrades all metadata that is visible on the system,
including the metadata in the system catalog.

ALL METADATA IN CATALOG catalog
This mode of operation upgrades all the metadata in the named catalog. If the
CASCADE option is specified, it affects the metadata in the catalogs that are related
to the named catalog. This mode of operation is available in SQL/MX Release
3.2 and later releases.
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.
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.
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 **************