PH41353: 4Q 2021 ENHANCEMENTS APAR OMEGAMON FOR DB2 ZOS PE V5.4

db2pe.client.v5.3.1.0.8610.win64.zip

APAR status

• Closed as unreproducible in next release.

Error description

• 4Q 2021 Enhancements APAR  Omegamon for DB2 zOS PE V5.4
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON for DB2 PE/DB2 PM                   *
  *                 users of components:                         *
  *                 - Batch SQL ACTIVITY report                  *
  *                 - Batch RECTRACE report                      *
  *                 - Batch STATISTICS report                    *
  *                 - Performance Database (PDB)                 *
  *                 - Spreadsheet Input Data Generator (CSV)     *
  ****************************************************************
  * PROBLEM DESCRIPTION: - SQL ACTIVITY report does not report   *
  *                        on fields QW0096DZ and QW0096KZ       *
  *                      - RECTRACE report does not show flags   *
  *                        for zIIP, Db2 Sort Optmode and        *
  *                        Implied decimal point for IFCID 25    *
  *                      - STATISTICS and RECTRACE reports       *
  *                        do not support Db2 APAR's PI78979,    *
  *                        PI82191 which provides information    *
  *                        from IFCID 225 on how many frames     *
  *                        may have been discarded and are       *
  *                        available for steal.                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  - In the OMPE BATCH SQLACTIVITY report data block
    "SORT ACTIVITY - QW0095/96", fields showing sort data area
    size with sortl (QW0096DZ) and sort key size with sortl
    QW0096KZ are not externalized.
  - Flags in OMPE Batch RECTRACE report for IFCID 25 (Utility End)
    are not externalized.
  - IFCID 225 storage statistics record contains field values
    for the number of discarded storage pages charged to Db2 for
    31 and 64-bit virtual which are available for steal.
    These values are the current high water marks (HWM) and are
    provided in fields QW0225ShrStkstg_dpage, QW0225PriStg_dpage,
    QW0225ShrStg_dpage, QW0225ComStg_dpage, QW0225DPGS.
    They are not yet available in STATISTICS or RECTRACE reports
    and neither have PDB or CSV support.
  

Problem conclusion

Temporary fix

Comments

• - New metrics "DATA SIZE W/ SORTL" (QW0096DZ) and
    "KEY SIZE W/ SORTL" (QW0096KZ) are externalized in Batch SQL
    ACTIVITY report data block "SORT ACTIVITY - QW0095/96".
  - New metrics "SORT OPTMODE", "IMP DEC POINT", "ZIIP ONLINE" are
    shown in RECTRACE report for IFCID 25.
  - Statistics report will now contain new metrics showing data
    from IFCID225 fields QW0225PriStg_dpage, QW0225ShrStg_dpage,
    QW0225ShrStkstg_dpage, QW0225ComStg_dpage. These metrics in
    the report will be shown under label "DISCARDED STORAGE
    ELIGIBLE FOR STEAL". Values in data block "REAL + AUX - DISC
    STORAGE IN USE - SUMMARY" will be calculated using formula:
    (QW0225xxxStg_Real + QW0225xxxStg_Aux - QW0225xxxStg_dpage) *
    4096 where xxx any of the four different new count fields.
  - RECTRACE report will now contain a new flag QW0225DPGS
    with label "DISCARD PAGES USED" indicating report contains
    non zero values for the following new fields:
    QW0225ShrStkstg_dpage, QW0225PriStg_dpage, QW0225ShrStg_dpage,
    QW0225ComStg_dpage
  - New fields from IFCID 225 are externalized in PDB table
    DB2PM_STAT_STORAGE and are also available for use with a
    spreadsheet utility
  
  Search Keywords:
  QW0096DZ, QW0096KZ, QW0025ZIIP, QW0025SCPU, QW0025SELA,
  QW0025IM, QW0225ShrStkstg_dpage, QW0225PriStg_dpage, QW0225DPGS
  QW0225ShrStg_dpage, QW0225ComStg_dpage, DB2PM_STAT_STORAGE,
  QW0225DPGS, A2GB_DBM1_DSC_ST, A2GB_DIST_DSC_ST, A2GB_SH_DSC_ST,
  A2GB_SH_STK_DSC_ST, A2GB_COMMON_DSC_ST
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI78884

Modules/Macros

• BPOQAPVA BPOQCREC BPOQINEX BPOQRIOA BPOQSRGB DGOAACUM DGOACREC
  DGOAIREC DGOARCAL 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
  DGOER000 DGOFECAL DGOFPDAT DGOFPE35 DGOFUCA1 DGOFUCAL DGOFUFAC
  DGOFUFDI DGOIPAIR DGOIPEDM DGOLADLK DGOLAREQ DGOLARES DGOLASUM
  DGOLASUS DGOLATIM DGOLCREC DGOLFILE DGOLIREC DGOLREDC DGOLTRAC
  DGOLXRES DGOMLEXD DGONCREC DGONF012 DGONF023 DGONF030 DGONF040
  DGONF050 DGONF060 DGONF210 DGONF220 DGONF230 DGONF240 DGONF250
  DGONF8ST DGONFILE DGONTRAC DGOPSB10 DGOPSB20 DGOPSC10 DGOPSCNV
  DGORASCN DGORCRE2 DGORCREC DGORCREP DGORDIST DGORINEX DGORIREC
  DGORIREP DGORPCAP DGORPEXI DGORPHIL DGORPHVA DGORPIOA DGORPMIN
  DGORPPAG DGORPPAR DGORPRID DGORPSCA DGORPSOR DGORPSUM DGORPSUS
  DGORPUDF DGORRCAP DGORRCOM DGORRDAT DGORRDDF DGORREXI DGORRHIL
  DGORRHVA DGORRIOA DGORRLOC DGORRMIS DGORRSOR DGORRSQL DGORRTHR
  DGORSRBY DGORUSUM DGORUWRK DGORZREP DGOSACMG DGOSACU2 DGOSACUM
  DGOSAPAW DGOSAPTS DGOSBLKX DGOSBORD DGOSBORE DGOSBSTG DGOSCREC
  DGOSCSTG DGOSDSTG DGOSFILE DGOSFMTQ DGOSFMTR DGOSFMTS DGOSFMTT
  DGOSGENC DGOSGENS DGOSI225 DGOSLSTG DGOSREDC DGOSREPG DGOSREPM
  DGOSRMGS DGOSSAVE DGOSSTDA DGOSSWSR DGOSTRAC DGOSUPDB DGOTAEXT
  DGOTAPVA DGOTAUTY DGOTBWKL DGOTCCHK DGOTCCOP DGOTCDIV DGOTCLOD
  DGOTCRCO DGOTCREB DGOTCREC DGOTCREO DGOTCREP DGOTCULD DGOTIREC
  DGOTIREP DGOVDMSG DGOVPIG1 DGOVS700 DGOVSUTL DGOVUELD DGOWF201
  DGOWFILE DGOXF000 DGOXF006 DGOXF007 DGOXR000 DGOXS006 DGOXS007
  DGOXT006 DGOXT007 FPECHASY FPECHATS FPECHE35 FPECHTRN FPECMDAT
  FPEFUCA1 FPEFUCAL FPEPSSTG FPEUCBPR FPEUCXPX FPEUCXSX FPEUFTDS
  FPEUFTS2 FPEUIFC2 FPEUIFCI FPEUNIDT FPEUVTMM FPEVSETM FPEVSPIM
  FPEVSPPM
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI78884

     UP22/01/20 P F201

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.