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-26
Considerations for FASTCOPY
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.