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-137
UPGRADE Utility
>>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 command that can be executed from MXCI.
UPGRADE transforms metadata from the existing version to the current schema
version for the SQL/MX Software Version (MXV). The REPORTONLY option allows you
to test if the operation can be executed without actually performing the operation.
catalog
specifies the ANSI name of the catalog in which metadata is to be upgraded. There
is no default for catalog.
RESTRICT
restricts the upgrade to metadata in the named catalog only.
CASCADE
extends the upgrade to the transitive closure of catalogs that are related to the
specified catalog. If no option is specified, the default is CASCADE.
UPGRADE ALL METADATA
[ output-spec ]
UPGRADE ALL METADATA IN CATALOG catalog
[ RESTRICT | CASCADE ]
[ output-spec ]
output-spec is:
[ log-to-spec ] [ REPORTONLY ]
log-to-spec is:
{ [ LOG TO ] OUTFILE oss-file [ CLEAR ] | LOG TO HOMETERM }