Concurrency and compatibility for MODIFY STATISTICS

Other utilities and operations can access objects while MODIFY STATISTICS is running.

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 MODIFY STATISTICS operations.
Target MODIFY STATISTICS
Table space, index space, or index UTRW
Legend:

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