Concurrency and compatibility for MERGECOPY

The MERGECOPY 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.

The following table shows the restrictive state that the utility sets on the target object.

Table 1. Claim classes of MERGECOPY operations.
Target MERGECOPY
Table space or partition UTRW
Legend:

UTRW - Utility restrictive state - read-write access allowed.

MERGECOPY can run concurrently on the same target object with any utility except the following utilities:

  • COPY TABLESPACE
  • LOAD
  • MERGECOPY
  • MODIFY
  • RECOVER
  • REORG TABLESPACE
  • UNLOAD (only when from the same image copy data set)

The target object can be a table space or partition.