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-126
RECOVER SCHEMA Operation
RECOVER SCHEMA Operation
Considerations for RECOVER SCHEMA
Examples of RECOVER SCHEMA
The RECOVER SCHEMA operation is used to revert the changes made by a failed
change ownership operation, or to force it to completion.
schema
specifies the name of the schema on which the failed change ownership operation will
be recovered.
[CANCEL]
The RECOVER SCHEMA operation attempts to undo the effects of the failed change
ownership operation. The default option is CANCEL.
[RESUME]
The RECOVER SCHEMA operation attempts to carry the failed change ownership
operation to completion.
Considerations for RECOVER SCHEMA
Authorization and Availability Requirements
The RECOVER SCHEMA operation can be performed by the original schema owner,
or security administrator or a Super ID (if Super ID is part of the Security
Administrator’s group or if no Security Administrator’s group exists). After successful
completion of this operation, all the existing opens on the underlying objects are
invalidated.
DDL Locks
The RECOVER SCHEMA operation checks for DDL locks acquired with the GIVE
SCHEMA operation on a particular schema. If no DDL lock is found, RECOVER
SCHEMA fails. If a DDL lock is found, the RECOVER SCHEMA undoes or completes
the failed GIVE SCHEMA operation and releases the lock.
Examples of RECOVER SCHEMA
•
This example identifies the schema affected by a failed change ownership
operation and instructs RECOVER SCHEMA to cancel the failed change
ownership operation:
RECOVER SCHEMA schema [CANCEL|RESUME]