SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-15
Considerations for FASTCOPY
•
DDL_LOCKS for target objects
For target objects, the DDL_LOCKS row displays an operation value Fastcopy
Target (FT). The status indicates the actual progress of the FASTCOPY of that
particular target object. The status values are listed below:
For target objects, DDL_LOCKS rows for indexes might not initially have an
associated TEXT row, when INDEXES EXPLICIT is used. The TEXT row will be
created as part of FASTCOPY INDEX.
Value Description
1 A fastcopy operation is started. Audit is turned off and all
target partitions (table and indexes) are marked "corrupt". A
target object with this DDL lock state is ready for a
continuation FASTCOPY command.
2 The object is ready for copy. The actual row copying is
about to start for the target object. A target object with this
DDL lock state or any subsequent state is processed by a
FASTCOPY command, and therefore, is not processed by
another FASTCOPY command.
3 Copy is in progress. Actual row copying is ongoing. The
target object is not marked "corrupt" when the object is in
this state.
4 Copy is completed. The target object is marked "corrupt".
5 The operation is completed. This is an intermediate state,
which indicates that all involved objects (table, indexes) are
successfully copied and the entire fastcopy operation is
about to complete.
6 Cancel the operation after copy. The fastcopy operation is
canceled. However, the FASTCOPY command copies rows
for the affected object. This state signals the FASTCOPY
command that the operation is canceled.
7 Cancel is in progress. The fastcopy operation is canceled.
8 Cancel is completed. This is an intermediate state. It
indicates that the fastcopy operation is canceled for all
involved objects (table, indexes).