Start of change

MAX_LOCKS_PER_USER

Contains a big integer value that specifies the maximum number of page, row, or LOB locks that a single application can concurrently hold for all table spaces.

FL 507
MAX_LOCKS_PER_USER has the following characteristics:
  • It is updatable, with values maintained by the user.
  • The type is BIGINT.
  • The schema is SYSIBMADM.
  • The scope of this global variable is session.
  • The default value is determined from the NUMLKUS subsystem parameter at the start of the application. Any subsequent changes to the NUMLKUS subsystem parameter do not affect the value of MAX_LOCKS_PER_USER. You can use either of the following SET assignment statements to reinitialize MAX_LOCKS_PER_USER using the current value of the NUMLKUS subsystem parameter:
    SET SYSIBMADM.MAX_LOCKS_PER_USER = DEFAULT;
    SET SYSIBMADM.MAX_LOCKS_PER_USER = NULL;
  • The acceptable range of values is 0–104857600
End of change