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.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

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, see BMC AMI Ops Monitor for DBCTL 5.6.

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.)

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.

Related topic

Analyze-program-isolation-lock-contention

 

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