Lock Escalation Parameters (DSNTIPJ)

This topic shows detailed information about System Parameters - Lock Escalation Parameters (DSNTIPJ).

This panel shows the characteristics of IRLM time-sharing fields and other locking options.

The default values are adequate for most sites in normal conditions.

LOCK ESCALATION PARAMETERS (DSNTIPJ)
------------------------------------
MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)...........1,000
MAX PAGE OR ROW LOCKS PER USER (NUMLKUS).................10,000

MAX PAGE OR ROW LOCKS PER TABLE SPACE (NUMLKTS)

The default (SYSTEM) for the LOCKMAX clause of the SQL statements CREATE TABLESPACE and ALTER TABLESPACE.

Install parameter LOCKS PER TABLE(SPACE) on panel DSNTIPJ, or ZPARM NUMLKTS in DSN6SPRM.

Field Name: QWP4LKTS

MAX PAGE OR ROW LOCKS PER USER (NUMLKUS)

The maximum number of page or row locks that a single application can hold concurrently on all table spaces.

This includes locks on data pages, index pages, and rows that the program acquires when it accesses table spaces.

The limit applies to all table spaces defined with the LOCKSIZE PAGE, LOCKSIZE ROW, or LOCKSIZE ANY options. 0 means that there is no limit to the number of page and row locks a program can acquire.

Db2 assumes that 250 bytes of storage are required for each lock. If NO is specified for CROSS MEMORY, the value of this field has to take into account the available lock space. If referential constraints between tables is defined, the value of this field might need to be increased.

Install parameter LOCKS PER USER on panel DSNTIPJ, or ZPARM NUMLKUS in DSN6SPRM.

Field Name: QWP4LKUS