IRLM Region Lock Wait List view (ILKRGWT)


The IRLM Region Lock Wait List view (ILKRGWT) provides a list of all regions that are waiting for database resource locks. Regions with the longest waits are shown at the top.

The view shows:

  • Every resource lock waited for by any region
  • How long has any region been waiting for any lock

Related topic

The ILKRGWT view is a good starting place for analyzing lock problems. The view highlights problems and shows their extent. You can hyperlink from the view to determine the cause of a problem.

You can hyperlink to the ILKRGWT view from the:

  • Regions Waiting option in the IMS System Menu (EZIMSS)
  • Regions in Lock Wait option in the IMS Operations Menu (EZIOPSR) and the IMS DBA Easy Menu (EZIDBA)
  • Locking Contention option in the IMS Dashboard Menu (IMSMDASH)
  • Locking field in the IMS Dashboard Menu (IMSMDASH)
  • Regions in IRLM Wait option in the IRLM Statistics Menu (ILKMS)
  • Number Waiters field in the ILKRSSUM view

ILKRGWT view

                              IRLM Region Lock Wait List                     
  Related Views                                                              
  . Holding Regions          . Database Contention                           
  . Resource Contention      . IRLM Statistics                               
                                                                             
Rgn IMS  Rgn      Rgn Rgn      Database DCB/Area RBA/Type F G Cur Wait   IRLM
ID  ID   Jobname  Typ Status   Name     -------- -------- - - Sta Time   ID  
  4 I12Y I12YBMP2 BMP WT-IRLM  CUSTHDAM 1        00001A6C P G UPD   23.9 IR2G
  2 I12Y IMSM12X  MPP WT-IRLM  CUSTHDAM 1        00001A6C P G UPD   21.1 IR2G

The following hyperlinks are provided on the view:

Hyperlink from

To access

Rgn ID

Region/Thread Activity Detail view (DRGNDTLR) for DBT or ODB region types or Region Activity Detail view (IRGNDTLR) for all other region types

DRGNDTLR and IRGNDTLR show what processing the region or thread has completed up until now.

Rgn Jobname

Region/Thread Activity Detail view (DRGNDTLR) for DBT or ODB region types or Region Activity Detail view (IRGNDTLR) for all other region types

DRGNDTLR and IRGNDTLR show what processing the region or thread has completed up until now.

Wait Time

IRLM Resource Lock List view (ILKRSLST), where you can see all waiters and holders of a given resource


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*