LOCKS PER TABLE(SPACE) field (NUMLKTS subsystem parameter)

The NUMLKTS subsystem parameter specifies the default maximum number of page, row, or LOB locks that an application can hold simultaneously in a table or table space. If a single application exceeds the maximum number of locks in a single table or table space, lock escalation occurs.

Acceptable values: 0–104857600
Default: 2000
Update: option 33 on panel DSNTIPB
DSNZPxxx: DSN6SPRM NUMLKTS

You can enter the number of locks as an integer or you can enter a value with a suffix of K or M. If you enter a value with a suffix of K, the number of locks is that value multiplied by 1024. If you enter a value with a suffix of M, the number of locks is that value multiplied by 1024 × 1024, or 1,048,576.

The value that you specify for this field must be less than the value that is specified for the LOCKS PER USER field (NUMLKUS subsystem parameter), except when the NUMLKUS setting is 0.

Start of changeFL 507 The NUMLKTS subsystem parameter values specifies the initial default value used when you specify LOCKMAX SYSTEM in CREATE TABLESPACE and ALTER TABLESPACE statements in an application process. After the SYSIBMADM.MAX_LOCKS_PER_TABLESPACE global variable is set, subsequent changes to NUMLKTS have no effect on the application.End of change

A 0 value for the NUMLKTS setting specifies that there is no limit to the number of data and row locks that a program can acquire.

Recommendation: Do not set the value to 0, because it can cause the IRLM to experience storage shortages.