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 lists any claims or drains that the utility acquires and any restrictive states that are set 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.

Start of changeMERGECOPY can run concurrently with any utility on the same target object.End of change

The target object can be a table space or partition.