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-136
Considerations for RECOVER SCHEMA
The RECOVER SCHEMA operation is used to revert the changes made by a failed
change ownership operation or to carry it through 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 through to completion.
Considerations for RECOVER SCHEMA
Authorization and Availability Requirements
The RECOVER SCHEMA operation can be performed by the original schema owner,
by a security administrator, or by the 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, 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 userschema2 cancel;
--- SQL operation complete.
OR
RECOVER SCHEMA schema [CANCEL|RESUME]