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 Region Lock Summary view (ILKRGSUM)


The IRLM Region Lock Summary view (ILKRGSUM) is a high-level view that displays a list of all regions that are waiting for or holding database locks.

Regions with the longest wait times are displayed first.

The view shows:

  • Every region that
    • Holds a resource lock
    • Is waiting for a resource lock
  • How long a region has been
    • Holding a lock
    • Waiting for a lock
  • How many resource locks the region holds
  • How long the longest currently held lock has been held

You can hyperlink to the ILKRGSUM view from the:

  • Database Lock Waits option in the IMS Easy Menu (EZIMS) and the IMS SSI Easy Menu (EZISSI)
  • DBCTL Operations Menu (EZDOPSR)
  • Long Lock Waits option in the DBCTL Menu (DBCMP)
26MAR2009  16:19:25 ------ MAINVIEW WINDOW INTERFACE (V6.0.00) ----------------
COMMAND  ===>                                                 SCROLL ===> PAGE
CURR WIN ===> 1        ALT WIN ===>                                            
>M1 =ILKRGSUM==========I10X=====*========26MAR2009==16:19:25====MVIMS====D====0
-                             IRLM Region Lock Summary                      
  Related Views                                                             
  . Regions in IRLM Wait     . Holding Regions          . IRLM Statistics   
  . Resource Contention      . Database Contention                           
                                                                             
Rgn IMS  Rgn      Rgn Rgn      MVS      PSB      Wait  Num   Longest XCF      
ID  ID   Jobname  Typ Status   Name     Name     Time  Held  Held    Name     
  5 X19H IM81BMP1 BMP WT-IRLM  SYSD     PTEST01   5.7     1      5.7 NONE     
  4 X19H IM81BMP2 BMP ACTV-USR SYSD     PTEST02           1     51.1 NONE     
SYS X19H DLI -TCB SYS          SYSD                       3    184.2 None

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 Wait List view (ILKRSWT), which shows the resources that regions are waiting to get locks for

Num Held

IRLM Resource Lock List view (ILKRSLST), which shows all waiters for and holders of a database resource

Related topic

 

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