PM82259: INCORRECT STATISTICS VALUES FOR GROUP BUFFER POOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Sometimes DB2 V10 SYSTEM STATISTICS data collected for
  Group Buffer Pool contains very high values in GBP_CKPTS_TRIGGER
  (QBGLCK) and GBP_DEP_GETPAGES (QBGLGG) fields. For example
  OMPE STATISTICS REPORT - LONG generated with customer's data
  shows the following GBP values:
  
  
  . . .
  GBP CHECKPOINTS TRIGGERED       3620.00
  . . .
  GBP CHECKPOINTS TRIGGERED       4822.00
  . . .
  GBP CHECKPOINTS TRIGGERED       5540.00
  . . .
  GBP-DEPENDENT GETPAGES         14691.8M
  . . .
  GBP-DEPENDENT GETPAGES         17915.6M
  . . .
  GBP-DEPENDENT GETPAGES         17931.2M
  . . .
  
  DB2 on z/OS Support Experts have determined this happens when
  the Global Buffer Pool gets disconnected and later is
  re-connected. At disconnect time DB2 stops to include the
  stats for that Buffer Pool in the IFCID 0002 record. But it
  does not reset the accumulative counters to zero at that time.
  This causes OMPE to report very high values next time this
  Global Buffer Pool connects again
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component:                          *
  *                 -   Batch Reporting                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: OMPE Batch Statistics may report unex-  *
  *                      pectedly big numbers for low activity   *
  *                      Group Buffer Pools (GBPs).              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  *                                                              *
  ****************************************************************
  PROBLEM SUMMARY:
  QBGL delta calculation may cause accumulated values to be
  reported as an interval delta values for low activity GBPs.
  That occurs in case when there is begin interval QBGL but there
  is NO end interval QBGL in two consequent IFCID 2. That caused
  unexpectedly high numbers for QBGL fields mistakenly reported.
  
  PROBLEM CONCLUSION:
  Code changed to fix this problem.
  

Problem conclusion

• Code changed to fix this problem.
  
  KEYWORDS : INCORROUT BATCH STATISTICS REPORT GLOBAL BUFFER POOL
  

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:

  UK93341 UK93342

Modules/Macros

•    DGOEC000 DGOFPNMP DGOFPRF0 DGOFPRPC DGOFSBGL
  DGOFSBST DGOFSDLT DGOSAPAW DGOSCREC DGOSDLTD DGOSFILE DGOSGENS
  DGOSI199 DGOSI225 DGOSI369 DGOSPREP DGOSPREQ DGOSQDQB DGOSREDC
  DGOSTRAC DGOS199T
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R510 PSY UK93341

     UP13/04/13 P F304

• R511 PSY UK93342

     UP13/04/13 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.