SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-80
RECOVER Utility
RECOVER Utility
Considerations for RECOVER
Examples of RECOVER
RECOVER is a syntax-based utility that can be executed through MXCI. The
RECOVER utility determines the state of a failed utility operation and executes its
recovery procedure. RECOVER completes the failed utility operation by rolling back
the entire operation or by completing the operation. In most cases, RECOVER rolls
back the utility operation by making the state the same as it was before the operation
started.
Syntax Description of RECOVER
object
is the name of the table or index that needs to be recovered. It must be the same
object that you were attempting to update with the command that failed. You can
specify delimited or regular identifiers. If you do not specify the catalog or schema
parts of object-name, RECOVER uses the default catalog and schema values
for that session. RECOVER returns errors if the catalog name is invalid, if the
schema name is invalid, if the table name is invalid, or if object-name does not
need to be recovered.
ddl-lock
is the fully qualified name of the DDL_LOCKS object that was created by the utility
operation that failed. ddl-lock is optional because there is only one lock allowed
on a object at a time. RECOVER can determine the ddl-lock name from the
object.
opt
directs how RECOVER should proceed with the operation.
RECOVER [INCOMPLETE SQLDDL OPERATION ON] object [ddl-lock] [opt]
object is:
{ TABLE | INDEX } object-name
object-name is:
[[catalog.]schema.]name
ddl-lock is:
WITH DDL_LOCK ddl-lockname
ddl-lockname is:
catalog.schema.name
opt is:
{ CANCEL | RESUME }