PH28054: 3Q 2020 ENHANCEMENT PTF DUMMY APAR

db2pe.client.v5.3.1.0.8606.win64.zip

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 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.