IBM Support

PH28054: 3Q 2020 ENHANCEMENT PTF DUMMY APAR

Subscribe

You can track all active APARs for this component.

 

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