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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-14
Considerations for FASTCOPY
•
utility operations that modify the data or definition of the source table or its
indexes
Data in the target table are not available while executing the FASTCOPY TABLE or
FASTCOPY INDEX command. Data in the target table can be accessed only after
the FASTCOPY operation completes successfully. The definition of the target
table(DDL) are available for read-only operations.
Recovery
•
The RECOVER INDEX command can be used only when explicit copying of index
rows is involved. That is, recovery of a failed FASTCOPY TABLE...INDEXES
IMPLICIT must use the RECOVER TABLE command.
•
When the CANCEL option is set, the entire fastcopy operation is canceled.
RECOVER...CANCEL applies to entire fastcopy operation. It restores the source
and target tables to the original state with an exception that the purge on the target
table cannot be rolled back. If you perform RECOVER…CANCEL on an actively
running FASTCOPY command, it will return an error 20212.
•
When the RESUME option is set, it affects only that target object which is
mentioned in the RECOVER command. The target object will be set to its initial
state and then the corresponding FASTCOPY command will be implicitly executed.
DDL Locks
To support the fastcopy operation, the following types of DDL_LOCKS metadata rows
are used:
•
DDL_LOCKS for source objects
For source objects, the DDL_LOCKS row displays an operation value Fastcopy
Source (FS). The status indicates how indexes are treated. The status values are
listed below:
For source objects, only DDL_LOCKS rows for tables have an associated TEXT
row that points to the target table. Also, for source tables there are additional TEXT
rows (with object_sub_id 19) that contain information about all source table
partitions.
Value Description
0 INDEXES IMPLICIT is specified to FASTCOPY TABLE.
1 INDEXES EXPLICIT is specified to FASTCOPY TABLE or
the originating command is FASTCOPY INDEX.