PM44584: DB2 RESOURCE WAIT TIME EVENTS MIS-FIRING

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• - Wait Time Resource incorrect in workspace "Detailed Thread
  Exception' resulting in situation tripped incorrectly
  - Wait Time Log Queue may be incorrect in workspace "Detailed
  Thread Exception"
  - Type Indicator incorrect in workspace
  "Detailed Thread Exception"
  - Commit Ratio incorrect in workspace "Detailed Thread
  Exception"
  - GetPage Ratio scale incorrect in workspace "Detailed Thread
  Exception"
  
  
  NOTE:
  The Wait Time Resource from TEP represents total local lock/
  latch wait time.  This wait time could become large for a long
  running thread.  For example KO2PLAN and DB2PM threads might
  have large wait time resource since these threads usually run
  for a long time.  If you have a situation on Wait Time Resource,
  filter out KO2PLAN and  DB2PM if you have no interest in these
  threads.
  
  Before PM44584/UK71147(F108), Wait Time Resource was not
  collected in TEP.
  After  PM44584/UK71147(F108) Wait Time Resource is collected in
  TEP
  
  WTRE  DB2_Thread_Exceptions.Wait_Time_Resource
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   The component that transfers DB2         *
  *                     monitoring data collected by the         *
  *                     OMEGAMON collector to the TEMA           *
  *                 -   Tivoli Enterprise Monitoring Agent       *
  ****************************************************************
  * PROBLEM DESCRIPTION: - Wait Time Resource incorrect in       *
  *                      workspace "Detailed Thread Exception'   *
  *                      resulting in situation tripped          *
  *                      incorrectly                             *
  *                      - Wait Time Log Queue may be incorrect  *
  *                      in workspace "Detailed Thread           *
  *                      Exception"                              *
  *                      - Type Indicator incorrect in workspace *
  *                      "Detailed Thread Exception"             *
  *                      - Commit Ratio incorrect in workspace   *
  *                      "Detailed Thread Exception"             *
  *                      - GetPage Ratio scale incorrect in      *
  *                      workspace "Detailed Thread Exception"   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Data was not collected for Wait Time Resource and Type
  Indicator, incorrect data was saved in Wait Time Log Queue,
  incorrect data was used to calculate the Commit Ratio, incorrect
  scale was set for GetPage Ratio.
  
  PROBLEM CONCLUSION:
  Collect data for Wait Time Resource and Type Indicator, save
  correct data in Wait Time Log Queue, use correct data to
  calculate the Commit Ratio, use correct scale for GetPage Ratio
  

Problem conclusion

• Collect data for Wait Time Resource and Type Indicator, save
  correct data in Wait Time Log Queue, use correct data to
  calculate the Commit Ratio, use correct scale for GetPage Ratio
  
  KEYWORDS : COMMIT RATIO GETPAGE WAIT TIME LOG  RESOURCE
             INDICATOR
  

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:

  UK71146 UK71147

Modules/Macros

• KO2APCBA KO2APCBS KO2APCB2 KO2APCOA KO2APCOK
  KO2APCO2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK71146

     UP11/08/26 P F108

• R510 PSY UK71147

     UP11/08/26 P F108

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.