This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

PI Region Lock Wait List view (IPIRGWT)

The PI Region Lock Wait List view (IPIRGWT) provides a list of all regions waiting for database resource locks and shows the ultimate holder of each resource in contention.

The IPIRGWT view is a good starting place for analyzing lock problems. The view highlights problems and shows their extent. (For more information about analyzing lock problems, see Analyze-lock-problems.)

Related topic

Analyze-program-isolation-lock-contention


Note

You can use the P and PA region stop line commands in the IPIRGWT view to stop all ultimate regions that hold a resource needed by a waiting region, if you decide that stopping regions is the best course of action to end a resource contention (see Line-commands-program-isolation-lock-views).

You can hyperlink to the IPIRGWT view from the:

  • Database Lock Waits option in the IMS Easy Menu (EZIMS) and the IMS SSI Easy Menu (EZISSI)
  • 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 field in the IMS Dashboard view (IMSDASHR)
  • Locking Contention option in the IMS Dashboard Menu (IMSMDASH)
  • Regions in PI Wait field in the IPISTAT view
  • Number Waiters field in the IPIRSSUM view
  • Regions in PI Wait in the PI Statistics menu (IPIMS)

IPIRGWT view

                              PI Region Lock Wait List                       
  Related Views                                                              
  . Resource Contention      . Holding Regions                               
  . Database Contention      . PI Statistics                                 
                                                                             
CMD Rgn Region   Rgn PSB      Tran      Wait Cnt Ult Ultimate Database         
---  ID Jobname  Typ Name     Name      Time Ult Rgn Jobname  Name     DCB     
      3 I9AMP2   MPP PHDAMINQ THDAMINQ 418.1   1   6 I9APIWT2 CUSTHDAM 01      
      5 I9APIWT3 BMP PTEST02  GBGTRNB1 184.2   1   6 I9APIWT2 CUSTHDAM 01      
      4 I9APIWT4 BMP PTEST02  GBGTRNB1 183.7   1   6 I9APIWT2 CUSTHDAM 01

No hyperlinks are available on the view.

 

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