IRLM latch contentions

Edit online

This topic shows detailed information about Statistics - IRLM latch contentions.

Statistics - IRLM latch contentions

The field labels shown in the following sample layout of Statistics - IRLM latch contentions are described in the following section.

Classic Batch Reporter layout:

IRLM LATCH CONTENTIONS       QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
MAIN CONT - MAIN LATCH HELD   1373.00     5.64     3.24     1.09
MAIN CONT - USE COUNT NOT 0     20.00     0.08     0.05     0.02
SEC CONT - MAIN LATCH HELD    1355.00     5.57     3.19     1.08
GENERIC LATCH CONTENTIONS     1355.00     5.57     3.19     1.08
RESOURCE LATCH CONTENTION        1.00     0.00     0.00     0.00
NOTIFY CB LTCH CONT-NOTIFY       0.00     0.00     0.00     0.00
ACTIVE IRLM CB LTCH CONTN

Java Batch Reporter layout:

 IRLM LATCH CONTENTIONS       QUANTITY  /SECOND  /THREAD  /COMMIT
 ---------------------------  --------  -------  -------  -------
 MAIN CONT - MAIN LATCH HELD      1.00     0.00     0.00     0.00
 MAIN CONT - USE COUNT NOT 0  55023.00     0.64     0.00     0.00
 SEC CONT - MAIN LATCH HELD     828353     9.60     0.02     0.01
 GENERIC LATCH CONTENTIONS     9414.00     0.11     0.00     0.00
 RESOURCE LATCH CONTENTION        0.00     0.00     0.00     0.00
 NOTIFY CB LTCH CONT-NOTIFY     121.00     0.00     0.00     0.00
 ACTIVE IRLM CB LTCH CONTN     6891.00     0.08     0.00     0.00
MAIN CONT - MAIN LATCH HELD

Main latch contention due to Main latch held.

Field Name: QTXALCMM

MAIN CONT - USE COUNT NOT 0

Main latch contention due to Use Count not being 0.

Field Name: QTXALCMU

SEC CONT - MAIN LATCH HELD

Secondary latch contention due to Main latch held.

Field Name: QTXALCSM

GENERIC LATCH CONTENTIONS

Generic latch contentions.

Field Name: QTXACGEN

RESOURCE LATCH CONTENTION

Resource latch contention counter.

Field Name: QTXASRCL

NOTIFY CB LATCH CONT - NOTIFY

Notify Control Block latch contention for NOTIFY.

Field Name: QTXACNNT

ACTIVE IRLM CB LTCH CONTN

Active IRLM Control Block latch contention counter.

Field Name: QTGSLCAI