Concurrency and compatibility for LOAD
Depending on the specified LOAD utility options and the target object, certain processes and utilities can run at the same time as LOAD.
Claims and drains
The following table shows the claim classes that LOAD drains and the restrictive states the utility sets.
Target | LOAD SHRLEVEL NONE | LOAD PART SHRLEVEL NONE | LOAD SHRLEVEL CHANGE | LOAD PART SHRLEVEL CHANGE |
---|---|---|---|---|
Table space, index, or physical partition of a table space or index space | DA/UTUT | DA/UTUT | CW/UTRW | CW/UTRW |
Nonpartitioned secondary index1 | DA/UTUT | DR | CW/UTRW | CW/UTRW |
Data-partitioned secondary index2 | DA/UTUT | DA/UTUT | CW/UTRW | CW/UTRW |
Index logical partition3 | None | DA/UTUT | None | CW/UTRW |
Primary index (with ENFORCE option only) | DW/UTRO | DW/UTRO | CR/UTRW | CR/UTRW |
RI dependents | CHKP (NO) | CHKP (NO) | CHKP (NO) | CHKP (NO) |
Legend:
Note:
|
Compatibility
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 shows whether other utilities are compatible with LOAD and can run concurrently 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.
Action | LOAD SHRLEVEL NONE | LOAD SHRLEVEL CHANGE |
---|---|---|
BACKUP SYSTEM | Yes | Yes |
CHECK DATA DELETE NO | No | No |
CHECK DATA DELETE YES | No | No |
CHECK INDEX | No | No |
CHECK LOB | No | No |
COPY INDEXSPACE SHRLEVEL CHANGE | No | Yes |
COPY INDEXSPACE SHRLEVEL REFERENCE | No | No |
COPY TABLESPACE SHRLEVEL CHANGE | No | Yes |
COPY TABLESPACE SHRLEVEL REFERENCE | No | No |
COPYTOCOPY | No | Yes |
DIAGNOSE | Yes | Yes |
LOAD SHRLEVEL CHANGE | No | Yes |
LOAD SHRLEVEL NONE | No | No |
MERGECOPY | No | Yes |
MODIFY RECOVERY | No | Yes |
MODIFY STATISTICS | No | Yes |
QUIESCE | No | No |
REBUILD INDEX | No | No |
RECOVER (no options) | No | No |
RECOVER ERROR RANGE | No | No |
RECOVER TOCOPY or TORBA | No | No |
REORG INDEX | No | No |
REORG TABLESPACE UNLOAD CONTINUE or PAUSE | No | No |
REORG TABLESPACE UNLOAD ONLY or EXTERNAL | No | No |
REPAIR DUMP or VERIFY | No | No |
REPAIR LOCATE KEY or RID DELETE or REPLACE | No | No |
REPAIR LOCATE TABLESPACE PAGE REPLACE | No | No |
REPORT | Yes | No |
RESTORE SYSTEM | No | No |
RUNSTATS INDEX SHRLEVEL CHANGE | No | Yes |
RUNSTATS INDEX SHRLEVEL REFERENCE | No | No |
RUNSTATS TABLESPACE SHRLEVEL CHANGE | No | Yes |
RUNSTATS TABLESPACE SHRLEVEL REFERENCE | No | No |
STOSPACE | Yes | Yes |
UNLOAD | No | Yes |
SQL operations and other online utilities on the same target partition are incompatible.