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 lists any claims or drains that the utility acquires and any restrictive states that are set on the target object.

Table 1. Claim classes for CHECK LOB operations on a LOB table space and index on the auxiliary table
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:
  • CR: Claim the read claim class
  • DW: Drain the write claim class, concurrent access for SQL readers
  • UTRO: Utility restrictive state, read-only access allowed
  • UTRW: Utility restrictive state, read and write access allowed

Compatibility

Any SQL operation or other online utility that attempts to update the same LOB table space is incompatible.