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.
Target | MODIFY STATISTICS |
---|---|
Table space, index space, or index | UTRW |
Legend:
UTRW - Utility restrictive state - read-write access allowed. |