Controlling lock size for LOB table spaces

You can use the LOCKSIZE option control the size of locks that are acquired when applications access data in LOB table spaces.

About this task

The LOCKSIZE TABLE, PAGE, ROW, and XML options are not valid for LOB table spaces. The other options act as follows:

LOCKSIZE TABLESPACE

A process acquires no LOB locks

LOCKSIZE ANY

Db2 chooses the size of the lock. For a LOB table space, this is usually LOCKSIZE LOB.

LOCKSIZE LOB

If LOBs are accessed, a process acquires the necessary LOB table space locks (IS or IX), and might acquire LOB locks.