Concurrency and compatibility for RUNSTATS

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

Db2 treats individual data and index partitions as distinct target objects. Utilities operating on different partitions of the same table space or index space are compatible.

Claims

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 RUNSTATS operations
Target RUNSTATS TABLESPACE SHRLEVEL REFERENCE RUNSTATS TABLESPACE SHRLEVEL CHANGE RUNSTATS INDEX SHRLEVEL REFERENCE RUNSTATS INDEX SHRLEVEL CHANGE
Table space or partition DW/UTRO CR/UTRW1 None None
Index or partition None None DW/UTRO CR/UTRW
Legend:
  • DW - Drain the write claim class - concurrent access for SQL readers.
  • CR - Claim the read claim class.
  • UTRO - Utility restrictive state - read-only access allowed.
  • UTRW - Utility restrictive state - read-write access allowed.
  • None - Object is not affected by this utility.
Note:
  1. If the target object is a segmented (non-UTS) table space, SHRLEVEL CHANGE does not allow you to concurrently execute an SQL searched DELETE without the WHERE clause.

Compatibility

The following table shows which utilities can run concurrently with RUNSTATS 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 shown in the table.

Table 2. Compatibility of RUNSTATS with other utilities
Utility RUNSTATS TABLESPACE SHRLEVEL REFERENCE RUNSTATS TABLESPACE SHRLEVEL CHANGE RUNSTATS INDEX SHRLEVEL REFERENCE RUNSTATS INDEX SHRLEVEL CHANGE
CHECK DATA DELETE NO Yes Yes Yes Yes
CHECK DATA DELETE YES No No No No
CHECK INDEX Yes Yes Yes Yes
CHECK LOB Yes Yes Yes Yes
COPY INDEXSPACE Yes Yes Yes Yes
COPY TABLESPACE Yes Yes Yes Yes
DIAGNOSE Yes Yes Yes Yes
LOAD No No No No
LOAD SHRLEVEL CHANGE No Yes No Yes
MERGECOPY Yes Yes Yes Yes
MODIFY RECOVERY Yes Yes Yes Yes
QUIESCE Yes Yes Yes Yes
REBUILD INDEX Yes Yes No No
RECOVER ERROR RANGE No No Yes Yes
RECOVER INDEX Yes Yes No No
RECOVER INDEX TOCOPY or TOLOGPOINT No No No No
RECOVER TABLESPACE (no options) No No Yes Yes
RECOVER TABLESPACE TOCOPY or TORBA No No No No
REORG INDEX Yes Yes No No
REORG TABLESPACE UNLOAD CONTINUE or PAUSE No No No No
REORG TABLESPACE UNLOAD ONLY or EXTERNAL Yes Yes Yes Yes
REPAIR DUMP or VERIFY Yes Yes Yes Yes
REPAIR LOCATE INDEX PAGE REPLACE Yes Yes No No
REPAIR LOCATE KEY or RID DELETE or REPLACE No No No Yes
REPAIR LOCATE TABLESPACE PAGE REPLACE No No Yes Yes
REPORT Yes Yes Yes Yes
RUNSTATS Yes Yes Yes Yes
STOSPACE Yes Yes Yes Yes
UNLOAD Yes Yes Yes Yes