Controlling the number of LOB locks

You can control the number of LOB locks that are taken.

About this task

Introductory concepts

Begin program-specific programming interface information. LOB locks are counted toward the total number of locks allowed per user.

Procedure

To control the number of LOB locks, use any of the following approaches:

  • Set the value of the NUMLKUS subsystem parameter.
    The number of LOB locks that are acquired during a unit of work is reported in IFCID 20.
  • Set the value of the SYSIBMADM.MAX_LOCKS_PER_USER built-in global variable.
  • Use the LOCKMAX clause of the CREATE TABLESPACE or ALTER TABLESPACE statement to control the number of LOB locks that are acquired within a particular LOB table space.End program-specific programming interface information.