Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, seeBMC AMI Ops Monitor for DBCTL 5.5.

IRLM Resource Lock Wait List view (ILKRSWT)


The IRLM Resource Lock Wait List view (ILKRSWT) provides a complete list of resources against which regions are waiting to get locks.

With the ILKRSWT view you can see:

  • Every resource lock waited for by any participant in an N-way data sharing group
  • How long any region has been waiting

Use the ILKRSWT view to list of all resources that have regions waiting for them. If you are interested in a specific resource, you can hyperlink from the Wait Time field to see only the waiters and holders for that resource.

You can hyperlink to the ILKRSWT view from the:

  • Wait Time field in the ILKRGSUM view or the Resource Contention option in the IMS System Menu (EZIMSS) to see the waiters and holders for a selected resource only
  • Resource Contention option in the IRLM Statistics Menu (ILKMS)
  • Database Name field in the IRLM Wait With Ultimate Holder view (ILKULTWT)
26MAR2009 16:28:46 ------ MAINVIEW WINDOW INTERFACE (V6.0.00) ----------------
COMMAND ===>                                                       SCROLL ===> PAGE
CURR WIN ===> 1        ALT WIN ===>
>M1 =ILKRSWT===========I10X=====*========26MAR2009==16:28:46====MVIMS====D====0
-                             IRLM Resource Lock Wait List
  Related Views
  . Regions in IRLM Wait     . Holding Regions
  . Database Contention      . IRLM Statistics

Database DCB/Area RBA/Type F G Cur Wait Rgn IMS  Rgn      Rgn Rgn      MVS
Name     -------- -------- - - Sta Time ID  ID   Jobname  Typ Status   Name
CUSTHDAM 1        00000D38 P G UPD  4.3   5 X19H IM81BMP1 BMP WT-IRLM  SYSD

The following hyperlinks are provided on the view:

Hyperlink from

To access

Database Name

Database I/O Activity for Physical Databases (IMS Systems) view (IDAPSUMR), where you can access database I/O activity information at the level of the physical database

Wait Time

IRLM Resource Lock List view (ILKRSLST), where you can see all waiters and holders for the selected resource

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.

Related topic

 

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