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-25
Considerations for FASTCOPY
Matching Indexes

If the target table has indexes that are online, the FASTCOPY TABLE command
determines the source and target indexes that match, if any. A target index
matches a source index if their index specifications are equivalent. That is, if all of
the following conditions are satisfied:

the index key for the target index must be equivalent to the index key for the
source index—the following details must be identical between the index keys:

number of columns

ordinal position of each index key column within its table

the source index is not offline
Each target index that is not offline must have a matching source index. The
FASTCOPY utility does not consider target indexes that are offline.
If the INDEXES EXPLICIT option is set, you must specify the matching source and
target indexes on the related FASTCOPY INDEX Command.
If the INDEXES IMPLICIT option is set, the system will select a matching source
index for each involved target index.
Availability of Source and Target Tables

While executing the FASTCOPY TABLE command, the source table and its
definition are available in read-only mode. That is, you will not be able to perform
the following operations on the source table:

insert, update, and delete DML operations

DDL operations on the source table or its indexes

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