A fix is available
APAR status
Closed as program error.
Error description
KEYWORDS: EDM POOL STATISICS TRACE RECTRACE QISEDPGE QISECPGE QISEKPGE N/A . Batch statistics report and trace show N/A for EDM DBD, STMT ( STATEMENT ) and SKEL ( SKELETON ) pool sizes with Db2 V12 See Db2 APAR PI82539 for Free Page values reporting as N/A QISEDFRE , QISEKFRE , QISECFRE
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: USERS AFFECTED: OMEGAMON XE for * * DB2 PE/DB2 PM users of component * * -Batch Reporter * **************************************************************** * PROBLEM DESCRIPTION: EDM 'PAGES IN xxx POOL (ABOVE)' fields * * do not display Db2 V12 provided values. * * * * EDM '% PAGES IN USE' values differ * * from the manually calculated values. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** Db2 V12 as shipped at GA always reported zero for the EDM pool size statistics QISEDPGE, QISECPGE and QISEKPGE. The batch statistics report and trace were modified in response to print N/A for the corresponding report fields for Db2 V12. After Db2 APAR PI69228 / UI45032, the statistics are no longer zero and OMEGAMON DB2PE needs to be updated to report the actual values.
Problem conclusion
Code changed to: 1. Show Db2 V12 provided values for QISEDPGE, QISECPGE and QISEKPGE in 'PAGES IN xxx POOL (ABOVE)' fields. 2. Show SISEDPIU and SISEKPIU '% PAGES IN USE' calculated values for Db2 V12 as a ratio of 'HELD BY' pages to the EDM pool's storage reclaim thresholds QISEDPGE and QISEKPGE respectively. Search Keywords: INCORROUT BATCH STATISTICS REPORT TRACE EDM POOL PAGES
Temporary fix
Comments
APAR Information
APAR number
PH07891
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
540
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-01-29
Closed date
2019-04-29
Last modified date
2019-07-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI62745
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 DGOFECAL DGOFEDAT DGOFSISE DGOFUCAL DGOFUFAC DGOFUFDI DGOMSISE DGONFISE DGOSAPAW DGOSBLKX DGOSBORD DGOSBORE DGOSFMTQ DGOSFMTR DGOSGENC DGOSGENS DGOSI225 DGOSTRAC DGOVS140 DGOVS150 DGOVSCS2 FPEFUCAL FPEUCBPR FPEUFTDS FPEUFTS2 FPEUIFC2 FPEUIFCI FPEUNIDT
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R540 PSY UI62745
UP19/04/30 P F904
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.4.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.4.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
22 July 2019