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-10
Considerations for DOWNGRADE
oss-file
an OSS file name.
Considerations for DOWNGRADE
Modes of Operation for DOWNGRADE
There are two modes of operation for the DOWNGRADE utility:

ALL METADATA
This mode of operation downgrades all metadata that is visible on the system,
including the metadata in the system catalog.

ALL METADATA IN CATALOG catalog
This mode of operation downgrades all metadata in the named catalog. If the
CASCADE option is specified, it also downgrades metadata in all catalogs that are
related to the named catalog. This mode of operation is available from SQL/MX
Release 3.2.
Command Output for DOWNGRADE
The DOWNGRADE utility supports the following command output options:

REPORTONLY
If the REPORTONLY option is specified, only the initial error checking is performed;
the DOWNGRADE operation is not performed. If the LOG TO option is also
specified, the list of affected schemas 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 DOWNGRADE utility will generate EMS events to the $0 primary
collector that documents the progress of the command. For information about EMS
event messages, see the SQL/MX Messages Manual.
Note. The DOWNGRADE 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 **************