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 Wait With Ultimate Holder view (ILKULTWT)

The IRLM Wait With Ultimate Holder view (ILKULTWT) provides a list of the number of ultimate regions that hold a resource, the ultimate region name, and the IMS subsystem name.

You can hyperlink to the ILKULTWT view from the:

  • Locks field in the IMS Dashboard Overview view (IMSDSHOR)
  • Locking field in the IMS Dashboard view (IMSDASSR)
11JUN2010  12:01:19 ------ MAINVIEW WINDOW INTERFACE (V6.0.00) ----------------
 COMMAND  ===>                                                 SCROLL ===> CSR  
 CURR WIN ===> 1        ALT WIN ===>                                            
  W1 =ILKULTWT=========(ALL======*=======)11JUN2010==12:01:11====MVIMS====D===10
 -                               IRLM Wait With Ultimate Holder                 
    Related Views                                                               
    . Resource Contention       . Holding Regions                               
    . Database Contention       . IRLM Statistics                               
                                                                               
  Rgn Region   Rgn PSB      Tran     Wait Cnt Ult Ultimate Database             
   ID Jobname  Typ Name     Name     Time Ult Rgn Jobname  Name     RBA      DCB
    4 I11QTLKQ BMP PTEST01  TTEST01  209    1   5 I11PTLK1 CUSTHIDM 000013CE 1  
    6 I11PTLK4 BMP PTEST01  TTEST01  209    1   5 I11PTLK1 CUSTHISM C12AB68D 1  
    3 I10PTLK4 BMP PTEST01  TTEST01  209    1   5 I11PTLK1 CUSTHDAM 000069A4 1  
    4 I10PTLK2 BMP PTEST01  TTEST01  209    1   5 I11PTLK1 CUSTHISM C12AB68D 1  
    2 I10PMP2  MPP PHDAMUPD THDAMUPD 190    1   5 I11PTLK1 CUSTHDAM 0000279C 1  
    3 I11PMP2  MPP PHDAMUPD THDAMUPD 188    1   5 I11PTLK1 CUSTHDAM 000027A4 1  
    2 I11PMP1  MPP PHDAMINQ THDAMINQ 183    1   5 I11PTLK1 CUSTHDAM 000027A4 1  
    1 I10PMP1  MPP PHDAMINQ THDAMINQ 179    1   5 I11PTLK1 CUSTHDAM 000027A4 1  
    3 I10QMP2  MPP PHDAMINQ THDAMINQ 176    1   5 I11PTLK1 CUSTHDAM 000027A4 1  
    1 I11QMP2  MPP PHDAMINQ THDAMINQ 157    1   5 I11PTLK1 CUSTHDAM 000027A4 1

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 done up until now.

PSB Name

DL/I Call Status view (IDLIST), which provides details about the last DL/I call issued by the region

Cnt Ult

IRLM Ultimate Holder List view (ILKULLST), which provides a list of ultimate holders

Database Name

IRLM Resource Wait List view (ILKRSWT), which shows the resources that regions are waiting to get locks for

Related topic

Analyze-contention

 

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