PM81958: NTH IN-DB2 ELAPSED TIME LESS THAN IN-DB2 WAIT TIME SCREEN ZHTACTMAJOR HPLN MINOR ACT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a thread has encountered certain types of waits the In DB2
  Wait Time ( In-DB2 Wait Tm ) value may exceed the In DB2 Elapsed
  Time ( In-DB2 Elap Tm ).
  
  The types of waits identified are
  Global Other L-Locks             IFCID fields QWACAWTM QWACARNM
  Global Pageset/Partition P-Locks IFCID fields QWACAWTN QWACARNN
  
  -User logs on to OMEGAMON DB2 (OMPE) and selects H to access
  Near Term History (NTH) then B for Thread History.
  -On screen ZHAFL user sets the filter criteria, presses enter
  and confirms the criteria by pressing enter on screen ZHAFC.
  -User is presented with screen ZHARP for command HARP.
  
  On screen ZHARP the user can display thread data grouped in
  several different ways.
  The following chart lists the group by, the command issued and
  the screen name that includes IN-DB2 Wait Tm
  Group By           Command Screen  CUA Screen
  A-BY PLAN          HAGP    ZHAGPL  KD2UPLND
  B-BY AUTHID        HAGP    ZHAGAU  KD2UAUTD
  C-BY PLAN,AUTHID   HAGP    ZHAGPA  KD2UPAUD
  D-BY AUTHID,PLAN   HAGP    ZHAGAP  KD2UAUPD
  E-THREAD SUMMARY   HATH       see below
  F-BY SUBINTERVAL   HARS    ZHARS   KD2USUBD
  G-BY CORRID        HAGP    ZHAGTX  none
  
  Option E-THREAD SUMMARY issues command HATH and displays screen
  ZHATACT. In_DB2 Wait Tm is not displayed on the screen. However
  the screen offers the following options to display thread data
  that includes In-DB2 Wait Tm
  
  Option           Command Screen  CUA screen
  C-DB2 Time       HATH    ZHATTIM KD2UTSD2
  D-Lock/Scan/Sort HATH    ZHATLOC KD2UTSLC
  
  From the screens listed above, a user may zoom ( PF11 ) a
  particular thread to see detail. User will see screen ZHTACT.
  On ZHTACT user will see incorrout for
  Global Other L-Locks              QWACAWTM QWACARNM
  Global Pageset/Partition P-Locks  QWACAWTN QWACARNN
  
  This fix effects the data collection side of NTH. Only data
  collected after this fix is applied will display correctly.
  
  Additional keywords
  wt tm llock llocks plock plocks accounting NTA
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   NTH-Near Term History                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: In-DB2 Wait Time is greater than        *
  *                      In-DB2 Elapsed Time on Thread           *
  *                      History Summary panels.                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Incorrect Wait Time summary calculation.
  
  PROBLEM CONCLUSION:
  Code is changed to correct Wait Time summary
  calculations.
  

Problem conclusion

• Code is changed to correct Wait Time summary
  calculations.
  
  KEYWORDS : ZHTACT MAJOR HPLN MINOR ACT
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK93279 UK93280

Modules/Macros

•    KO2DXS1A KO2DXS1K KO2DXS12
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK93279

     UP13/04/11 P F304

• R511 PSY UK93280

     UP13/04/11 P F304

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.