PM36655: ENHANCEMENTS IN STATISTICS STORAGE MONITORING

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• CR51-349 / CR51-371
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  *                 -   Performance Database users               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Real storage monitoring is critical     *
  *                      for system stability. DB2 private,      *
  *                      shared, and common above the bar real   *
  *                      storage consumption was previously      *
  *                      unreported.                             *
  *                                                              *
  *                      Monitoring the average footprint and    *
  *                      maximum number of threads is critical   *
  *                      for system stability. The formulas      *
  *                      must be accurate.                       *
  *                                                              *
  *                      Short-on-storage metrics are useful     *
  *                      for analyzing the system stability and  *
  *                      was previously unreported.              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  Add new IFCID 225 instrumentation fields for real storage
  monitoring to Record Trace and Statistics reports.
  
  Adapt the formulas for the calculation of average footprint
  and maximum number of threads in Statistics reports.
  Adapt the sample Performance Database query in DGOSQGEN
  accordingly.
  
  Add IFCID 1 instrumentation fields (QSSTCONT, QSSTCRIT,
  QSSTABND) for short-on-storage monitoring to Statistics reports.
  
  PROBLEM CONCLUSION:
  Ensure REAL STORAGE monitoring in batch RECORD TRACE and
  STATISTICS reports.
  
  Ensure accurate calculation of AVERAGE FOOTPRINT and maximum
  number of threads in STATISTICS reports and PERFORMANCE
  DATABASE.
  
  Ensure SHORT-ON-STORAGE monitoring in batch STATISTICS reports.
  

Problem conclusion

Temporary fix

Comments

• Ensure REAL STORAGE monitoring in batch RECORD TRACE and
  STATISTICS reports.
  
  Ensure accurate calculation of AVERAGE FOOTPRINT and maximum
  number of threads in STATISTICS reports and PERFORMANCE
  DATABASE.
  
  Ensure SHORT-ON-STORAGE monitoring in batch STATISTICS reports.
  

APAR Information

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

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

  UK69519

Modules/Macros

•    BPOQSRGB DGOBGENL DGOBSRBN DGOBSRCM DGOBSRDD
  DGOBSRLG DGOBSRLK DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI
  DGOBSRSH DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTBN DGOBSTCM
  DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO DGOBSTQP
  DGOBSTRI DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM DGOER000
  DGOFECAL DGOFPDAT DGOFSSST DGOFUCAL DGOFUCA1 DGOFUFAC DGOFUFDI
  DGOLAREQ DGOLARES DGOLASUM DGOLASUS DGOLFILE DGOLIREC DGOLREDC
  DGOLTRAC DGOLXRES DGONF210 DGONF220 DGONF230 DGONF240 DGONF250
  DGONF410 DGONIREC DGONTRAC DGOPSCNV DGOPS830 DGOPS920 DGORCREC
  DGORIREC DGORPHVA DGORPSUM DGORRDAT DGORRHVA DGORRLOC DGORRSQL
  DGOSACMG DGOSACUM DGOSACU2 DGOSAPAW DGOSAPTS DGOSBGEN DGOSBLKX
  DGOSBORD DGOSBORE DGOSDGEN DGOSFILE DGOSFMTQ DGOSFMTR DGOSFMTS
  DGOSGENC DGOSGENS DGOSI225 DGOSQGEN DGOSREDC DGOSREPG DGOSREPM
  DGOSRMGS DGOSSAVE DGOSSPSH DGOSSTDA DGOSSWSR DGOSTRAC DGOVPIG1
  DGOVS700 DGOWFILE DGOWF201 FPECHATS FPECMDAT FPEUCBPR FPEUCXPX
  FPEUCXSX FPEUFTDS FPEUFTS2 FPEUIFCI FPEUIFC2 FPEUNIDT TDK$LNCK
  TDK$UTR
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK69519

     UP11/07/08 P F107

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.