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.