PK65753: ADD SEVERAL KEY DB2 RESOURCE MANAGEMENT INDICATORS

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add the following:
  High water mark of active threads
    High water mark of Batch threads
    High water mark of TSO threads
    MAXDBAT APPROACHING MAX
    DSMAX APPROACHING MAX
    RIDPOOL STORAGE FAILURE
    LOCK ESCALATIONS EXCL
    LOCK ESCALATIONS SHARED
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Common Collector                         *
  *                 -   Tivoli Enterprise Monitoring Agent       *
  *                 -   Classic Interface                        *
  *                 -   CUA Interface                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: New attributes are added to             *
  *                      statistics and thread related displays  *
  *                      in TEP and classic                      *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  Attributes added are: DBAT approaching max, DSMAX
  approaching max, CTHREAD high water mark, IDFORE high water
  mark, IDBACK high water mark, MAXDBAT high water mark, RIDPOOL
  Fallback due to storage, RIDPOOL Fallback rate due to storage,
  Lock escalations exclusive, Lock escalations shared, Lock
  escalations rate, thread wait time and thread logical unit of
  work identifier.
  
  PROBLEM CONCLUSION:
  Add these attributes: DBAT approaching max, DSMAX
  approaching max, CTHREAD high water mark, IDFORE high water
  mark, IDBACK high water mark, MAXDBAT high water mark, RIDPOOL
  fallback due to storage, RIDPOOL Fallback rate due to storage,
  Lock escalations exclusive, Lock escalations shared, Lock
  escalations rate, thread wait time and thread logical unit of
  work identifier.
  

Problem conclusion

Temporary fix

Comments

• Add these attributes: DBAT approaching max, DSMAX
  approaching max, CTHREAD high water mark, IDFORE high water
  mark, IDBACK high water mark, MAXDBAT high water mark, RIDPOOL
  fallback due to storage, RIDPOOL Fallback rate due to storage,
  Lock escalations exclusive, Lock escalations shared, Lock
  escalations rate, thread wait time and thread logical unit of
  work identifier.
  
  KEYWORDS:  DBAT DSMAX IDBACK MAXDBAT RIDPOOL CTHREAD
  

APAR Information

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

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

  UK38034

Modules/Macros

•    KD2RHSDD KD2RSSSD KD2UTDTD KD2VTHD6 KD29HSDD
  KD5AGENT KD5ATR   KD5CAT   KD5DOC   KD5PDICT KD5VOM   KD5410PP
  KO2ACONB KO2APCAA KO2APCAS KO2APCA2 KO2APCBA KO2APCBS KO2APCB2
  KO2APC1A KO2APC1S KO2APC12 KO2APC2A KO2APC2S KO2APC22 KO2APC3A
  KO2APC3S KO2APC32 KO2APC4A KO2APC4S KO2APC42 KO2APINA KO2APINS
  KO2APIN2 KO2CCAFB KO2CCINB KO2CDFCA KO2CDFCS KO2CDFC2 KO2CDFSA
  KO2CDFSS KO2CDFS2 KO2CDINA KO2CDINS KO2CDIN2 KO2CDSCB KO2CDSYA
  KO2CDSYS KO2CDSY2 KO2CIFAB KO2CIFBB KO2CIFCB KO2CIFDB KO2CIFIA
  KO2CIFIS KO2CIFI2 KO2CNADB KO2CNAGB KO2CNAPB KO2CNASB KO2CNSRB
  KO2CNTPA KO2CNTPS KO2CNTP2 KO2CSTSB KO2CST1A KO2CST1S KO2CST12
  KO2CST2A KO2CST2S KO2CST22 KO2CST3A KO2CST3S KO2CST32 KO2CST4A
  KO2CST4S KO2CST42 KO2CSYSA KO2CSYSS KO2CSYS2 KO2CTHDA KO2CTHDS
  KO2CTHD2 KO2CTHGA KO2CTHGS KO2CTHG2 KO2CTHHA KO2CTHHS KO2CTHH2
  KO2CTHJA KO2CTHJS KO2CTHJ2 KO2CTHKA KO2CTHKS KO2CTHK2 KO2CTHLA
  KO2CTHLS KO2CTHL2 KO2CTHMA KO2CTHMS KO2CTHM2 KO2CTHSA KO2CTHSS
  KO2CTHS2 KO2CTH3A KO2CTH3S KO2CTH32 KO2CTH5A KO2CTH5S KO2CTH52
  KO2CT2IA KO2CT2IS KO2CT2I2 KO2CT2SA KO2CT2SS KO2CT2S2 KO2DAUDA
  KO2DAUDS KO2DAUD2 KO2DBCIB KO2DCS2B KO2DDSBA KO2DDSBS KO2DDSB2
  KO2DMSCA KO2DMSCS KO2DMSC2 KO2DNTHA KO2DNTHS KO2DNTH2 KO2DTHDA
  KO2DTHDS KO2DTHD2 KO2DXSTB KO2DXS1A KO2DXS1S KO2DXS12 KO2HARCB
  KO2HDTIB KO2HDTPB KO2HPRCB KO2HSMDH KO2HSQIB KO2HSQPB KO2LCAPB
  KO2MI00B KO2NCSTB KO2OCMCB KO2ODINB KO2ODSTB KO2OINTB KO2ONAFB
  KO2ONAGB KO2OROUB KO2OSTDB KO2OSTSB KO2OTCCB KO2OTCIA KO2OTCIS
  KO2OTCI2 KO2OTHAB KO2OTHDB KO2OTHFB KO2OTHGB KO2OTHHB KO2OTHJB
  KO2OTHKB KO2OTHLB KO2OTHMB KO2OTHNB KO2OTHOB KO2OTHPB KO2OTHQB
  KO2OTHSB KO2OTHTB KO2OTHUB KO2OTHVB KO2OTHXB KO2OTHYB KO2OTH3B
  KO2OTH4B KO2OTH8B KO2OXSYB KO2OXTHB KO2OXTRB KO2OZM2B KO2OZOMB
  KO2SABP  KO2SABS  KO2SACS  KO2SADD  KO2SADS  KO2SAGB  KO2SAGS
  KO2SAPK  KO2SAPS  KO2SAU1  KO2SAU2  KO2SAU3  KO2SAU4  KO2SAU6
  KO2SAU7  KO2SAU8  KO2SSSMH KO2SSUB  KO2TACTH KO2TDTLH KO2TSB1B
  KO2TSB2B KO2TSB3B KO2TSB4B KO2WGETB KO2WNCYB KO2XDFSA KO2XDFSS
  KO2XDFS2 KO2XSY2A KO2XSY2S KO2XSY22
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK38034

     UP08/07/16 P F807

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.