Direct link to fix
APAR status
Closed as unreproducible in next release.
Error description
3Q 2020 Enhancement PTF Dummy APAR Additional Keywords IFCID0365 IFCID 365 0365
Local fix
Apply PTF when available
Problem summary
**************************************************************** * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM * * users of components: * * - PE server subtask * * - Performance Expert Client * * - Classic Interface * * - Enhanced 3270 User Interface * * * * - Batch Reporting * * - PDB * * - CSV * **************************************************************** * PROBLEM DESCRIPTION: Support Db2 PH28078 - correct DSNDQXST * * macro error in ASM part * * * * New Function: * * Add 33 new location metrics to the * * Statistics Details page of the * * Performance Expert Client. * * * * Add 39 new IRLM statistics counters * * to the Statistics Details page of the * * Performance Expert Client. * * * * The Java Runtime Environment has * * not addressed the latest * * common vulnerabilities. Connection to * * the Data Server Manager is not working. * * * * New Function: * * Add improved location metrics to * * Batch reporting Record trace, PDB, CSV * * interfaces. * * * * Add HTAP support to classic thread * * accelerator display. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** Some fields defined in DSNDQXST macro have wrong offsets causing incorrect values displayed. New location metrics and IRLM statistics are missing from the PE Client. The Java Runtime Environment used by PE Client has some vulnerabilities and needs to be updated. Explain SQL statement enhancement is not working because connection to the Data Server Manager fails. New location metrics are not reported in Batch reporting, PDB, CSV. New thread level HTAP count fields are missing from ZTACEL.
Problem conclusion
Temporary fix
Comments
Use the correct offsets for QXRFMIAP, QXSTEHLST and QXSTHVLST. 72 new counters were added to the Statistics Details page of the PE Client. This includes a new pane called "IRLM statistics" which is located under the "Latch Counters" pane and has 31 new counters. Fixed some labels for already existing counters. The Java Runtime Environment was updated to address the latest common vulnerabilities. Fixed not being able to run Explain SQL statement issue. Improved location statistics provided by Db2 APAR PH16111 were added to Batch Record Trace reporting under IFCID365. Added thread HTAP fields to thread accelerator display. keywords: DSNDQXST QXRFMIAP QXSTEHLST QXSTHVLST ZSQLC ZHTACT ZHSQD KDPSQL4 KDPSQLE DSNDQLST Q8ACTWDP Q8ACNWDP ZTACEL IFCID001 IFCID365 RECTRACE
APAR Information
APAR number
PH28054
Reported component name
OM XE DB2PE/PM
Reported component ID
5655OPE00
Reported release
540
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-07-30
Closed date
2020-10-14
Last modified date
2021-01-13
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI72066
Modules/Macros
DGOAACUM DGOABORD DGOABORE DGOACALC DGOACMER DGOACOMP DGOACREC DGOAEX20 DGOAEXIT DGOAFGEN DGOAFORM DGOAIREC DGOAIREP DGOAMTRC DGOAPARC DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOATRAC DGOATREC DGOAZMER DGOAZREC DGOBGENL DGOFECAL DGOFEDAT DGOFPRIC DGOFSLST DGOFSXST DGOFUCA1 DGOFUFAC DGOFUFDI DGOK$INF DGOMSLST DGOMSXST DGOMTPOP DGONBFRL DGONCFRL DGONDFRL DGONF9ST DGONFILE DGONFLST DGONLFRL DGONUPDB DGORAEXT DGORIREP DGORPACC DGORUACC DGORZREP DGOSAPAW DGOSBLKX DGOSBORD DGOSBORE DGOSFMTQ DGOSFMTR DGOSGENC DGOSGENS DGOSPREP DGOSTRAC DGOVCRDB DGOVFTAB DGOVFTIN DGOVMSTR DGOVRA DGOVS100 DGOVS700 DGOVSCLO DGOVSCNI DGOVSCNT DGOVSCS2 DGOVSCT1 DGOVSCT2 DGOVSFLR DGOVSGFT DGOVSLOC DGOVSORT DGOVSQFM DGOVSTQL DGOVUDAT DGOVUFTL FPEFUCA1 FPEK$INF FPEPNFRL FPEUCBPR FPEUFTDS FPEUFTS2 FPEUIFC2 FPEUIFCI FPEUNIDT FPEVFTM FPEVSFLR FPEVZMAI KO2ACELH KO2APC32 KO2CCAFB KO2CSYS2 KO2CT2S2 KO2CTH62 KO2CTHR2 KO2CTHRK KO2CTHRS KO2DSIA2 KO2DSIF2 KO2DTHD2 KO2DXS12 KO2DXS1K KO2DXS1S KO2OQAL2 KO2OQALK KO2OQALS KO2OTHZB
Fix information
Fixed component name
OM XE DB2PE/PM
Fixed component ID
5655OPE00
Applicable component levels
R540 PSY UI72066
UP20/10/16 P F010
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAV2B","label":"IBM Db2 Buffer Pool Analyzer for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.4.0"}]
Document Information
Modified date:
14 January 2021