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-127

UPGRADE Utility

>>recover schema userschema2 cancel;

--- SQL operation complete.

>>recover schema userschema2;

--- SQL operation complete.

•

This example identifies the schema affected by a failed change ownership

operation and instructs RECOVER SCHEMA to resume the failed change

ownership operation:

>>recover schema userschema2 resume;

--- SQL operation complete.

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

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.