SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-198
Considerations for DUP
DDL lock information is persistent across transaction boundaries. If the utility
operation fails unexpectedly such as a process failure, you must run the
RECOVER utility to remove the lock and clean up the operation. When you run
the RECOVER utility, DDL lock information is retrieved and the correct clean
up operation is performed. If you run the RECOVER operation with the
incorrect option, RECOVER displays an error message so you can rerun it with
the correct option.
While the operation is proceeding, you can select state information from
metadata tables to determine the utility progress. If the operation terminates
unexpectedly, you can also select this information to determine where the
operation failed.
•
DUP records operation progress steps in the DDL_LOCKS metadata table. You
can query this table to determine the DUP operation’s progress:
•
An error is returned if a user transaction exists.
•
An error is returned if a DUP operation is attempted on an SQL/MX metadata table
(histogram, system defaults, or MXCS tables).
•
DUP does not support RI constraints duplication.
•
For a source table that contains an IDENTITY column, the DUP utility duplicates
the source table IDENTITY column attributes and the corresponding SG Attributes
onto the target table. DUP copies the data of the source table onto the target table.
DUP also copies the source SG Table CURRENT_VALUE onto the target SG Table
CURRENT_VALUE.
DUP
Operation
Step Step Progress Status
Step 1 DDL lock has been created.
Step 2 Target table has been created.
Step 3 Source table is open.
Step 4 All source objects are open.
Step 5 Target table is open.
Step 6 All target objects are open.
Step 7 All table partitions are copied.
Step 8 All index partitions are copied.
Step 9 All objects for catalog.schema.table have been copied.*
Step 10 Target object is now available (corrupt attribute is turned off, audit attribute
is turned on).
Step 11 DDL lock is removed.
*
Any process, CPU, or system failure that occurs before this point causes the operation to be rolled back.
Any failure after this point can be resumed.