PI41760: SIMULATED BUFFER POOL SUPPORT IN STATISTICS REPORTING AND VARIOUS ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Simulated Buffer Pool Support in Statistics Reporting, PDB and
  CSV
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  *                 - PDB                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. New performance metrics of DB2 11    *
  *                         for simulated buffer pools are not   *
  *                         supported in statistics reports,     *
  *                         Performance Database and             *
  *                         Spreadsheet Input Data Generator.    *
  *                      2. System Parameters are not supported  *
  *                         in Spreadsheet Input Data Generator. *
  *                      3. Fields QW0225_RS, QW0225LFAREA are   *
  *                         not supported in Performance         *
  *                         Database and Spreadsheet Input Data  *
  *                         Generator.                           *
  *                      4. Statistics report labels for RID     *
  *                         list processing should be renamed    *
  *                         to better reflect the DB2            *
  *                         functionality.                       *
  *                      5. The TIMEZONE support for field       *
  *                         QW0199SC is missing (DSETSTAT).      *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF to get support for the        *
  *                 missing functionality.                       *
  ****************************************************************
  PROBLEM SUMMARY:
  1. New performance metrics of DB2 11 for simulated buffer pools
     are not supported in statistics reports, Performance
     Database and Spreadsheet Input Data Generator.
  2. System Parameters are not supported in Spreadsheet Input
     Data Generator.
  3. Fields QW0225_RS, QW0225LFAREA are not supported in
     Performance Database and Spreadsheet Input Data Generator.
  4. Statistics report labels for RID list processing should
     be renamed to better reflect the DB2 functionality.
  5. The TIMEZONE support for field QW0199SC is missing
     (DSETSTAT).
  
  PROBLEM CONCLUSION:
  1. Show performance metrics of DB2 11 for simulated buffer
     pools in statistics reports, Performance Database tables and
     spreadsheets.
  2. Support system parameters with the Spreadsheet Input Data
     Generator.
  3. Show values for fields QW0225_RS, QW0225LFAREA in
     Performance Database tables and spreadsheets.
  4. Rename statistics report labels for RID list processing to
     better reflect the DB2 functionality.
  5. Add TIMEZONE support for field QW0199SC (DSETSTAT).
  
  KEYWORDS:
  SIMULATED BUFFER POOLS PERFORMANCE DATABASE
  SPREADSHEET QW0225_RS QW0225LFAREA RID DSETSTAT
  

Problem conclusion

• 1. Show performance metrics of DB2 11 for simulated buffer
     pools in statistics reports, Performance Database tables and
     spreadsheets.
  2. Support system parameters with the Spreadsheet Input Data
     Generator.
  3. Show values for fields QW0225_RS, QW0225LFAREA in
     Performance Database tables and spreadsheets.
  4. Rename statistics report labels for RID list processing to
     better reflect the DB2 functionality.
  5. Add TIMEZONE support for field QW0199SC (DSETSTAT).
  

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:

  UI29348

Modules/Macros

•    DGOBGENL DGOBSRAL DGOBSRBN DGOBSRCM DGOBSRDD
  DGOBSRLG DGOBSRLK DGOBSRLO DGOBSROC DGOBSRPO DGOBSRQP DGOBSRRI
  DGOBSRSH DGOBSRSP DGOBSRSQ DGOBSRSS DGOBSRTM DGOBSTAL DGOBSTBN
  DGOBSTCM DGOBSTDD DGOBSTLG DGOBSTLK DGOBSTLO DGOBSTOC DGOBSTPO
  DGOBSTQP DGOBSTRI DGOBSTSH DGOBSTSP DGOBSTSQ DGOBSTSS DGOBSTTM
  DGOER000 DGOFPDAT DGOFUCAL DGOFUCA1 DGOFUFAC DGOFUFDI DGONFISE
  DGONF230 DGONF9ST DGOPSA10 DGOPSB10 DGOPSCNV DGOSACMG DGOSACUM
  DGOSACU2 DGOSAPAW DGOSAPTP DGOSAPTS DGOSBACC DGOSBBUF DGOSBDDF
  DGOSBGBP DGOSBGEN DGOSBLKX DGOSBORD DGOSBORE DGOSBSET DGOSBSIM
  DGOSBSTG DGOSBXCL DGOSCREC DGOSCREP DGOSCSIM DGOSCSTG DGOSDACC
  DGOSDBUF DGOSDDDF DGOSDGBP DGOSDGEN DGOSDSET DGOSDSIM DGOSDSTG
  DGOSDXCL DGOSFILE DGOSFMTQ DGOSFMTS DGOSFMTT DGOSGENS DGOSI199
  DGOSI225 DGOSLSIM DGOSLSTG DGOSQKEY DGOSREDC DGOSREPG DGOSREPM
  DGOSRMGS DGOSSAVE DGOSSTDA DGOSSWSR DGOSTRAC DGOSUPDB DGOS199R
  DGOS199T FPECMDAT FPEFUCAL FPEPCSV  FPEPCSVN FPEPCSVS FPEPCSVW
  FPEPSGEN FPEPSSIM FPEPSSTG FPEPWSFP FPEPW106 FPEPW201 FPEPW202
  FPEPW230 FPEPW256 FPEUCBPR HKDB530J KDB530J
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI29348

     UP15/07/15 P F507

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.