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

Begin program-specific programming interface information.
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.
End program-specific programming interface information.
Parent topic: Specifying the maximum number of locks that a process can hold on a table space