DSNZPARM IRLM Parameters

This panel shows information about the Internal Resource Lock Manager (IRLM) with which Db2 communicates. It shows the name of the DSNZPARM module that is specified for Db2 startup and the date on which the module is assembled. It also shows a list of the default values of the Db2 application.

If a field is not available for the current Db2 release, the string N/A is displayed. For other conditions, for example, if specific Db2 traces are not started or control block data is not available, the string N/P is displayed.


________________ ZPRLM    VTM     O2       V540./C DB1H S 07/31/13 15:17:15 2  
>       Help PF1      Back PF3      Left PF10      Right PF11                   
> R.H.F                                                                         
>       DSNZPARM INFORMATION:  Enter a selection letter on the top line.        
                                                                                
>  A-THREAD    B-TRACE     C-LOGGING   D-ARCHIVING     E-AUTH/RLF/DDF   *-IRLM  
>  G-STORAGE   H-DATASET   I-DDCS      J-DATA SHARING  K-STORED PROC    L-UTIL  
>  M-APPL      N-DATA      O-PERF      P-BUFFERPOOL    Q-OTHERS                 
=============================================================================== 
>                          DSNZPARM IRLM PARAMETERS                             
 ZRLM                                                                           
+ Collection Interval:  REALTIME                SNAPTIME: 07/31/13 13:17:15.64  
+                                                                               
+ DSNZPARM Module                         DB1HUNIN                              
+ Assembly Date                           07/30/13                              
+ Initial Module                          DSNZPARM                              
+ Assembly Date                           07/29/13                              
+ Previous Module                         DSNZPARM                              
+ Assembly Date                           07/29/13                              
+                                                                               
+ DSNTIPI-IRLM 1                                                                
+------------------------------------                                           
+ Subsystem Name (IRLMSID)                    IB1H                              
+ Resource Timeout (IRLMRWT)                    30                              
+ Auto Start (IRLMAUT)                         YES                              
+ Proc Name (IRLMPRC)                     DB1HIRLM                              
+ Time to Autostart (IRLMSWT)                  120                              
+ U Lock for RR or RS (RRULOCK)                YES                              
+ X Lock for Searched U/D (XLKUPDLT)            NO                              
+ IMS BMP Timeout (BMPTOUT)                      4                              
+ DL/I Batch Timeout (DLITOUT)                   6                              
+ Retain Lock Timeout (RETLWAIT)                 0                              
+                                                                               
+ DSNTIPJ-IRLM 2                                                                
+------------------------------------                                           
+ Locks per Table(space) (NUMLKTS)            2000                              
+ Locks Per User (NUMLKUS)                   10000                              
+ Deadlock Time                               5000                              
+ Deadlock Cycle                                 1                              
+                                                                               
+ Other IRLM Processing Parms                                                   
+------------------------------------                                           
+ PC Yes Specified                             YES                              
+ Current Timeout Interval                      30                              
+ IRLM Maximum CSA Allowed                       0                              
+ CF Lock Table Hash Entries                     0                              
+ CF Pending Hash Entries                        0                              
+ CF Lock Table List Entries                     0                              
+ Max 31-bit IRLM Private Storage                0                              
+ Max 64-bit IRLM Private Storage                0                              
===============================================================================

Navigation

For additional information about

related topics, select one of the options on the top of the panel.
other topics, use the PF keys.

Fields

The DSNZ command displays the following lines to reflect the usage of the DB2 SET SYSPARM command. To each of these lines, the corresponding date on which this particular module is assembled is displayed.

DSNZPARM Module: The name of the DSNZPARM module that is specified for Db2 startup.
Initial Module: The name of the initial DSNZPARM load module.
Previous Module: The name of the previous DSNZPARM load module.
Assembly Date: The date on which this module was assembled.

DSNTIPI-IRLM 1

Subsystem Name (IRLMSID) (QWP4ISID)

The name of the IRLM subsystem that is known to z/OS®.

Resource Timeout (IRLMRWT) (QWP4TOUT)

The maximum amount of time in seconds that DB2 is waiting for the release of a locked resource.

Auto Start (IRLMAUT) (QWP4IAUT)

The IRLM start mode. OMEGAMON® XE for DB2 PE displays YES if DB2 starts IRLM automatically or NO if it does not.

Proc Name (IRLMPRC) (QWP4IPRC)

The name of the IRLM procedure that is used by DB2 to start IRLM automatically.

Time to Autostart (IRLMSWT) (QWP4ISWT)

The time in seconds that Db2 waits for IRLM to start.

If this time expires and IRLM did not yet start, DB2 stops. This applies regardless whether IRLM is started automatically or not.

U Lock for RR or RS (RRULOCK) (QWP4RRU )

Determines whether the update (U) lock is used when using repeatable read (RR) or read stability (RS) isolation to access a table.

Valid values:

NO
YES

X Lock for Searched U/D (XLKUPDLT) (QWP4XLUD)

Use X lock for searched update or delete. If subsystem parameter XLKUPDT is set to NO, this bit is off. If subsystem parameter XLKUPDT is set to YES or TARGET, see QWP4XLUS.

IMS BMP Timeout (BMPTOUT) (QWP4WBMP)

Timeout multiplier for BMP a connection.

DL/I Batch Timeout (DLITOUT) (QWP4WDLI)

Timeout multiplier for DL/I batch connection.

Retain Lock Timeout (RETLWAIT) (QWP4WAIT)

Multiplier for determining how long a transaction waits for incompatible retained locks. This value is multiplied by the normal timeout multiplier of the connection.

If agents do not wait for incompatible retained locks, the value of this parameter is 0. The default is 0.

Utility Timeout (UTIMOUT)

Number of IRLM resource timeout intervals that a utility waits for a lock or claims to be released.

DSNTIPJ-IRLM 2

Locks per Table(space) (NUMLKTS) (QWP4LKTS): The maximum number of page or row locks that can be held concurrently by a thread against a single table space for which LOCKSIZE ANY is specified before Db2 escalates the locking level to a table space lock.; The value 0 deactivates this feature.
Locks Per User (NUMLKUS) (QWP4LKUS): The maximum number of page or row locks that can be held concurrently by a thread against all table spaces in the system including locks against data and index pages. Each lock averages 540 bytes. If this limit is reached, Db2 issues a return code RESOURCE UNAVAILABLE.
Deadlock Time (QWP5DLOK): The time (in seconds or milliseconds) of the local deadlock detection cycle. Values between 1 and 5 are seconds. Values between 100 and 5000 are milliseconds. The initial value is retrieved from the IRLMPROC DEADLOK parameter. This value can be changed dynamically with the MODIFY irlmproc,SET,DEADLOCK=nnnn command.
Deadlock Cycle (QWP5DCYC): The number of local deadlock cycles that must expire before the IRLM performs global deadlock detection processing. This value is retrieved from the IRLMPROC DEADLOK parameter. In a data sharing environment, IRLM synchronizes all DEADLOK values in the group to the values specified on the most recent IRLM to join the group. The DEADLOK values can be changed by starting a member with the required values.

Other IRLM Processing parameters

PC Yes Specified (QWP5PCY): Indicates whether the IRLM is to use the cross-address-space program call. This value is retrieved from the IRLMPROC PC parameter.
Current Timeout Interval (QWP5TVAL): The initial value is retrieved from the Timeout Interval (IRLMRWT). The current value can be changed dynamically with the MODIFY irlmproc,SET,TIMEOUT=nnnn,subsystem-name command.
IRLM Maximum CSA Allowed (QWP5MCSA): The maximum amount of common service area (CSA) and extended CSA (ECSA) that the IRLM for this Db2 uses for its lock control block structure. This value is retrieved from the IRLMPROC MAXCSA parameter.
CF Lock Table Hash Entries (QWP5HASH): The number of lock table entries (LTE) that IRLM has allocated in the XCF LOCK structure. The initial value is calculated by the IRLM based on IRLMPROC parameters and the XCF LOCK structure size. This value can be changed dynamically with the MODIFY irlmproc,SET,LTE=nnnn command.
CF Pending Hash Entries (QWP5PHSH): The number of LOCK HASH entries (LTE) that this IRLM can use on the next connect to the XCF LOCK structure. This value is set by MODIFY irlmproc,SET,LTE=nnnn command and exists until the next time the IRLM connects to the XCF LOCK structure or a subsequent MODIFY irlmproc,SET,LTE=nnnn command is issued.
CF Lock Table List Entries (QWP5RLE): The number of entries (RLE) in the list of update locks that are currently held in the XCF LOCK structure. This list is sometimes called the modify lock list or record list table. The initial value is calculated by the IRLM based on IRLMPROC parameters and the XCF LOCK structure size. This value can be changed dynamically with the MODIFY irlmproc,SET,LTE=nnnn command or a XCF LOCK structure resizing.
Max 31-bit IRLM Private Storage (QWP5BPM): From a total of 2G virtual storage, a maximum amount of 31-bit IRLM private storage is available for normal operations in IRLM. IRLM reserves an additional 10% of the total 2G virtual storage for use by requests in IRLM. DB2 11 and later.
Max 64-bit IRLM Private Storage (QWP5APM): From the total storage that is set as the MEMLIMIT, a maximum amount of 64-bit IRLM private storage is available for normal operations in IRLM. IRLM reserves an additional 10% of the total MEMLIMIT storage for use by requests that must be completed in IRLM. DB2 11 and later.