Concurrency and compatibility for REORG INDEX

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

Db2 treats individual index partitions as distinct target objects. Utilities that operate on different partitions of the same 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. The target is an index or partition.

Table 1. Claim classes of REORG INDEX operations
Phase REORG INDEX SHRLEVEL NONE REORG INDEX SHRLEVEL REFERENCE REORG INDEX SHRLEVEL CHANGE
UNLOAD DW/UTRO DW/UTRO CR/UTRW
BUILD DA/UTUT none none
Last iteration of LOG n/a DA/UTUT1 DW/UTRO
SWITCH n/a DA/UTUT DA/UTUT
Legend:
  • CR: Claim the read claim class.
  • DA: Drain all claim classes, no concurrent SQL access.
  • DR: Drain the repeatable read class, no concurrent access for SQL repeatable readers.
  • DW: Drain the write claim class, concurrent access for SQL readers.
  • UTRO: Utility restrictive state, read only access allowed.
  • UTUT: Utility restrictive state, exclusive control.
  • none: Any claim, drain, or restrictive state for this object does not change in this phase.
Note:
  1. Applicable if you specified DRAIN ALL.

Compatibility

The following table shows which utilities can run concurrently with REORG INDEX on the same target object. The target object can be an index space or a partition. If compatibility depends on particular options of a utility, that is also shown. REORG INDEX does not set a utility restrictive state if the target object is an index on DSNDB01.SYSUTILX.

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

To run on SYSIBM.DSNLUX01 or SYSIBM.DSNLUX02, REORG INDEX must be the only utility in the job step and the only utility that is running in the Db2 subsystem.