IBM Support

PH46359: OMEGAMON FOR DB2 PERFORMANCE EXPERT 5.5.0 ENHANCEMENTS

Direct links to fixes

5.5.0-TIV-KD5-FP0007.zip
5.5.0-TIV-KD5-FP0007.tar.gz
5.5.0-TIV-KD5-LP0003.zip
5.5.0-TIV-KD5-LP0003.tar
5.5.0-TIV-KD5-FP0006.zip
5.5.0-TIV-KD5-FP0006.tar.gz
5.5.0-TIV-KD5-FP0006.README
5.5.0-TIV-KD5-LP0002.zip
5.5.0-TIV-KD5-LP0002.tar
5.5.0-TIV-KD5-FP0005.zip
5.5.0-TIV-KD5-FP0005.tar.gz
5.5.0-TIV-KD5-FP0005.README
LCD7-7810-00.zip
LCD7-7810-00.tar
5.5.0-TIV-KD5-FP0004.zip
5.5.0-TIV-KD5-FP0004.tar.gz
5.5.0-TIV-KD5-FP0004.README
5.5.0-TIV-KD5-FP0003.zip
5.5.0-TIV-KD5-FP0003.tar.gz
5.5.0-TIV-KD5-FP0003.README

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • OMEGAMON for Db2 Performance Expert 5.5.0 enhancements

Local fix

  • 



Problem summary


    

  • ****************************************************************
* USERS AFFECTED: - Enhanced 3270UI                            *
*                 - Batch RECTRACE report                      *
*                 - Batch SYSPARMS report                      *
*                 - Batch STATISTICS report                    *
*                 - Performance Database (PDB)                 *
*                 - Spreadsheet Input Data Generator (CSV)     *
*                 - All OMEGAMON Db2 users                     *
****************************************************************
* PROBLEM DESCRIPTION: 1.New latch classes added from DSNDQVLS *
*                      2.STATIME_MAIN is not reported in       *
*                      RECTRACE and SYSPARMS report sets.      *
*                      3.New latch classes from DSNDQVLS       *
*                      added to Statistics report.             *
*                      4.New counters are being added to DDF   *
*                      global and location statistics.         *
*                      5.Sample member FPEPCSVW is missing in  *
*                      the RKANSAM / TKANSAM library.          *
*                      6.SC03 abend on termination of          *
*                      FPECMAIN.                               *
*                      7.Page count values are not converted   *
*                      correctly to MB.                        *
*                      8.Enhancements in QLST reporting        *
*                      (location statistics) in Batch          *
*                      Statistics.                             *
*                      9.Missing contents in E3270UI new       *
*                      feature help.                           *
*                      10.Audit security trace is missing 3    *
*                      types of security identity and          *
*                      security mechanisms.                    *
*                      11.High CPU usage related to periodic   *
*                      exception task FPEMEXA0.                *
*                      12.Db2 Currency: Support Db2 PH16111    *
*                      Location statistics (IFCID 1) in        *
*                      STATISTICS REPORT/TRACE + PDB/CSV.      *
*                      13.Missing ZPARMS fields in TEP UI.     *
*                      14.Serviceability mechanisms added for  *
*                      better TCB management.                  *
****************************************************************
* RECOMMENDATION: Apply the provided PTF.                      *
****************************************************************
1.New latch classes added in Db2 V13 DSNDQVLS.
2.STATIME_MAIN (QWP1STIMM) added in Db2 V12 DSNDQWPZ and is not
 externalized in RECTRACE, SYSPARMS and SYSPARMS PDB/CSV.
3.IFCID 1 Section QWS00R70 DSNDQVLS has been expanded to include
 new latch classes from 33 to 64.
4.New counters QLSTNTPLH, QLSTNTILS, QDSTNTPL, QDSTNTRU are
added to DDF global and location statistics.
5.Spreadsheet Utility sample job for creation of SYSTEM
PARAMETER FILE spreadsheets (FPEPCSVW) is missing in the
RKANSAM / TKANSAM library.
6.DCB storage was freed without closing the DCBs in an utility
module, causing a suppressed 0C4 on access from RTM and a
subsequent C03 abend if underlying storage ownership has
changed.
7.Master field selection lists of RKANSAMF / TKANSAMF members
FPEPSGEN and FPEPSSTG have wrong default FORMAT variable
specified for fields: HELD BY SKCT (MB), HELD BY SKPT (MB),
HELD BY DBD (MB), HELD BY STMT POOL (MB). This leads to
incorrect conversion of page count value to MB.
8.QLST counters delivered in Db2 PH16111 not displayed for
IFCID 1 in Batch STATISTICS.
9.KDPHLP21 workspace is empty.
10.Audit security trace is missing security identities types
CERTIFICATE, NON ENCRYPTED, PASS TICKET and security
mechanism is missing UID PW, UID PW NEWPW, UID ONLY.
11.High CPU usage in periodic exception when Db2 subsystem
has many DSCDBAT threads.
12.QLST counters delivered in Db2 PH16111 not displayed for
IFCID 1 in Batch STATISTICS (report/trace).
13.Customer cannot see same ZPARMS in TEP UI which is available
in E3270UI.
14.Serviceability mechanisms added for better TCB management.

    



Problem conclusion


    

  • 1. Show new latch classes in system latch counters workspace
KO2LOK2. Helps are added to system lock statistics workspaces.
2. STATIME_MAIN is added in RECTRACE with label
STATS MAIN INTRVL, and in SYSPARMS with label STATISTICS MAIN
TIME INTERVAL IN SECONDS (STATIME_MAIN). It is externalized
in PDB and CSV as STATIME_MAIN.
3. New latch classes from 33 to 64 are available in Statistics
data section LATCH CNT.
4. New DDF global counters added in data section GLOBAL DDF
ACTIVITY as DBATS TERM-POOLINAC (QDSTNTPL), DBATS TERM-REUSE
LIMIT (QDSTNTRU). Both counters are externalized in Statistics
PDB and CSV.
New location statistics counters added in data section DRDA
REMOTE LOCS as TERMINATED - POOLINAC TIME (QLSTNTPLH),
TERMINATED - REUSE LIMIT (QLSTNTILS). Both counters are
externalized in Statistics PDB and CSV.
5.Spreadsheet Utility sample job for creation of SYSTEM
PARAMETER FILE spreadsheets (FPEPCSVW) is added to the
RKANSAM / TKANSAM library.
6.Utility code amended to close DCBs prior to releasing them.
7.FORMAT (v) variable in master field selection lists of
RKANSAMF / TKANSAMF members FPEPSGEN and FPEPSSTG changed from
MB to P2MB for fields: HELD BY SKCT (MB), HELD BY SKPT (MB),
HELD BY DBD (MB), HELD BY STMT POOL (MB).
8.QLST counters delivered in Db2 PH16111 are now included
for IFCID1 in Batch STATISTICS as PDB/CSV.
9.Added year 2021 E3270UI new features to help workspace.
10.Batch AUDIT TRACE/FILE and RECTRACE security
identities complemented with types CERTIFICATE, NON ENCRYPTED,
PASS TICKET. Security mechanisms complemented with UID PW,
UID PW NEWPW, UID ONLY.
11.Added WQAL to periodic exception to exclude DSCDBAT threads.
Also removed ENQ and DEQ while processing threads in periodic
exception.
12.QLST counters delivered in Db2 PH16111 are now included
for IFCID1 in Batch STATISTICS TRACE/REPORT/SAVE/FILE, as
well as PDB/CSV.
13.Add missing ZPARMS in TEP workspaces.
14.Serviceability mechanisms added for better TCB management.

KEYWORDS:
QVLS KDPLOK1 KDPLOK2 KDPLOK3 KDPLOK4 QWP1STIMM QDSTNTPL QDSTNTRU
QLSTNTPLH QLSTNTILS FPEPCSVW QISESKCT, QISESKPT, QISEDBD,
QW0319CE, QW0319NE, QW0319PT, QW031901, QW031903,
QW031907 KDPHLP21 TEP ZPARMS DSNZPARMS
QISEDYNP, Batch Statistics spreadsheet, CSV, HELD BY SKCT,
HELD BY SKPT, HELD BY DBD, HELD BY STMT POOL, TCB

    



Temporary fix


    

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    PH46359
    • 

  • Reported component name
    OM XE DB2PE/PM
    • 

  • Reported component ID
    5655OPE00
    • 

  • Reported release
    550
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt / Xsystem
    • 

  • Submitted date
    2022-05-11
    • 

  • Closed date
    2022-07-19
    • 

  • Last modified date
    2022-08-02
    • 





    

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

    • 

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

    
UI81538
    

    • 



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 DGOER000 DGOFEDAT
DGOFEDPM DGOFPDAT DGOFPDPM DGOFPNMP DGOFPRPC DGOFSLST DGOFSVLS
DGOFUCA1 DGOFUCAL DGOFUFAC DGOFUFDI DGOMEXA2 DGONF320 DGONFWP1
DGOPSB10 DGOPSB20 DGOPSC10 DGOPSC20 DGOPSCNV DGOSACMG DGOSACU2
DGOSACUM DGOSALST DGOSAPAW DGOSAPTD DGOSAPTS DGOSAVLS DGOSBDDF
DGOSBGEN DGOSBLKX DGOSBORD DGOSBORE DGOSCDDF DGOSCGEN DGOSCREC
DGOSDDDF DGOSDGEN DGOSFILE DGOSFMTQ DGOSFMTS DGOSFMTT DGOSGENS
DGOSLDDF DGOSLGEN DGOSPREP DGOSREDC DGOSREPG DGOSREPM DGOSRMGS
DGOSSAVE DGOSSTDA DGOSSWSR DGOSTRAC DGOSUPDB DGOVBMG  DGOVCINI
DGOVCRDB DGOVDB2E DGOVDB2F DGOVDMSG DGOVDS   DGOVDSRC DGOVHM00
DGOVHMCD DGOVHMM1 DGOVHMM2 DGOVHMM3 DGOVISI  DGOVISIT DGOVM001
DGOVM002 DGOVMRAP DGOVMRAS DGOVMSTR DGOVPIG0 DGOVPIG1 DGOVRG00
DGOVRG01 DGOVRG02 DGOVRG03 DGOVRG04 DGOVRG10 DGOVRG11 DGOVRG12
DGOVRG13 DGOVRG20 DGOVRG21 DGOVRG22 DGOVRG23 DGOVRG24 DGOVRG25
DGOVRG26 DGOVRG27 DGOVRG28 DGOVRG4B DGOVRG4C DGOVRG4X DGOVRGM1
DGOVSADJ DGOVSADK DGOVSCLO DGOVSCLR DGOVSCNT DGOVSCON DGOVSCPI
DGOVSDTS DGOVSDTT DGOVSGFT DGOVSGSA DGOVSLOC DGOVSORT DGOVSQRY
DGOVSQSM DGOVSQTR DGOVSSEN DGOVSTAG DGOVTCPD DGOVTCPL DGOVTCPS
DGOVTCPT DGOVTDI0 DGOVTSEX DGOVTWR  DGOVUAS0 DGOVUELD DGOVUFTL
DGOVUINI DGOVUM01 DGOVUSS0 DGOW1FIL DGOWB106 DGOWC106 DGOWD106
DGOWF106 DGOWL106 DGOWUPDB DGOXBASS DGOXCREC DGOXCREP DGOXD000
DGOXF000 DGOXF001 DGOXF002 DGOXF003 DGOXF004 DGOXF005 DGOXF006
DGOXF007 DGOXF008 DGOXF009 DGOXFSQL DGOXPCON DGOXR000 DGOXS001
DGOXS002 DGOXS003 DGOXS004 DGOXS005 DGOXS006 DGOXS007 DGOXSPRT
DGOXT000 DGOXT001 DGOXT002 DGOXT003 DGOXT004 DGOXT005 DGOXT006
DGOXT007 FPECMDAT FPEMEXA0 FPEPCSVW FPEPSDDF FPEPSGEN FPEPSSTG
FPEPW106 FPEUCBPR FPEUFIO2 FPEUMSGS FPEVDB24 FPEVDB2I FPEVDB2S
FPEVM000 FPEVMMM  FPEVNT00 FPEVRAC  FPEVRDS1 FPEVRDS2 FPEVREQ0
FPEVRG8X FPEVSDCM FPEVSERV FPEVSPMM FPEVZMAI KD5AGENT KD5ATC00
KD5AUTO1 KD5CCB00 KD5CMD00 KD5COL00 KD5DB200 KD5DCE00 KD5DET00
KD5GBPLP KD5GBPLQ KD5GBPMP KD5GBPMQ KD5GBPNP KD5GBPNQ KD5GOA00

    



Fix information


    

  • Fixed component name
    OM XE DB2PE/PM
    • 

  • Fixed component ID
    5655OPE00
    • 



Applicable component levels


    

  • R550  PSY  UI81538
       UP22/07/22  P  F207
    • 



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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"550"}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            29 June 2023
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback