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

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—544517-008
5-13
Considerations for FASTCOPY
Equivalence Requirements
•
The target table and the source table must be equivalent so that the following
command can be executed successfully:
insert into <target table> (*) select * from <source table>;
Two tables must have the same number of columns. The columns with the same
ordinal position must have compatible data types. Also, either both tables must a
SYSKEY column or none of the tables must have a SYSKEY column.
If the target table has indexes that are online, the clustering key for the target table
must be equivalent to the clustering key for the source table. The following details
must be identical between the clustering keys:
•
number of columns
•
ordinal position of each clustering key column within its table
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