A fix is available
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 number
PM82259
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
510
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-02-07
Closed date
2013-04-11
Last modified date
2017-06-21
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCT4H5","label":"IBM Tivoli OMEGAMON XE for Db2 PE \/ PM \/ BPA"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
21 June 2017