Concurrency and compatibility for CHECK LOB
The CHECK LOB utility has certain concurrency and compatibility characteristics associated with it.
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.
Claims and drains
The following table shows which claim classes CHECK LOB claims and drains and any restrictive state that the utility sets on the target object.
| Target objects | CHECK LOB SHRLEVEL REFERENCE | CHECK LOB SHRLEVEL CHANGE |
|---|---|---|
| LOB table space | DW/UTRO | CR/UTRW |
| Index on the auxiliary table | DW/UTRO | CR/UTRW |
Legend:
|
||
Compatibility
Any SQL operation or other online utility that attempts to update the same LOB table space is incompatible.