Concurrency and compatibility for COPYTOCOPY

The COPYTOCOPY utility has certain concurrency and compatibility characteristics associated with it.

DB2® treats individual data and index partitions as distinct target objects. Utilities that operate on different partitions of the same table space or index space are compatible.

Claims

The following table shows which claim classes COPYTOCOPY claims on the target object.

Table 1. Claim classes of COPYTOCOPY operations.
Target COPYTOCOPY
Table space or partition, or index space or partition UTRW
Legend:
  • UTRW - Utility restrictive state - read-write access allowed

Compatibility

The following table documents which utilities can run concurrently with COPYTOCOPY on the same target object. The target object can be a table space, an index space, or a partition of a table space or index space. If compatibility depends on particular options of a utility, that information is also documented in the table.

Table 2. Compatibility of COPYTOCOPY with other utilities
Action Compatible with COPYTOCOPY?
CHECK DATA Yes
CHECK INDEX Yes
CHECK LOB Yes
COPY No
DIAGNOSE Yes
LOAD No
MERGECOPY No
MODIFY No
QUIESCE Yes
REBUILD INDEX Yes
RECOVER No
REORG INDEX No
REORG TABLESPACE No
REPAIR Yes
REPORT Yes
RUNSTATS INDEX Yes
RUNSTATS TABLESPACE Yes
STOSPACE Yes
UNLOAD Yes