PI95808: OMEGAMON DB2PE BATCH AND PDB SUPPORT FOR IDAA V7 AND HTAP

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Provide DB2PE batch Statistics, Record Trace and System
  Parameters support for IDAA V7 and HTAP (Hybrid Transaction /
  Analytical Processing). PDB support is provided for new fields.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2 PM users of       *
  *                 components batch reporting and PDB.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Provide batch Statistics, Record Trace, *
  *                      System Parameters Report for IDAA V7    *
  *                      and HTAP (Hybrid Transaction /          *
  *                      Analytical Processing) in DB2PE.  Also  *
  *                      provide PDB (Performance DataBase) and  *
  *                      CSV support for the new fields.         *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  Several new fields were introduced by Db2 to support IDAA V6 and
  V7 as well as HTAP for IDAA V5 PTF 6.  In addition, a new ZPARM
  was introduced so that an installation may set a default value
  for the CURRENT QUERY ACCELERATION WAITFORDATA special register.
  

Problem conclusion

Temporary fix

Comments

• Support is provided for statistics fields that were introduced
  with IDAA V5 PTF 6, IDAA V6 and IDAA V7.  The Statistics Report,
  Statistics Trace and Record Trace have been updated to process
  these new fields.
  
  Support is provided for QUERY_ACCEL_WAITFORDATA setting in the
  System Parameters Report.
  
  Corresponding PDB columns have been added for all new fields.
  
  CSV generation has been updated for the new fields as well.
  
  Search Keywords:
  IDAAV5 PTF6 IDAAV6 IDAAV7
  

APAR Information

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

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

  UI56463

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
  DGOFS8ST DGOMZF00 DGOMZF03 DGONFWPA DGONFWP1 DGONFWP9 DGONF8ST
  DGOPSB10 DGOPSB20 DGOPSCNV DGOSACUM DGOSAPAW DGOSAPTX DGOSBLKX
  DGOSBORD DGOSBORE DGOSBXCL DGOSCREC DGOSCXCL DGOSDXCL DGOSFILE
  DGOSFMTQ DGOSFMTS DGOSLXCL DGOSPREP DGOSREPM DGOSSAVE DGOSSWSR
  DGOSTRAC DGOSUPDB DGOVCRDB DGOVFTAB DGOVFTIN DGOVMIDI DGOVRA
  DGOVSCLO DGOVSCNI DGOVSCNT DGOVSCS2 DGOVSFLR DGOVSGFT DGOVSLOC
  DGOVSORT DGOVSQFM DGOVSSP1 DGOVSSP2 DGOVSTQL DGOVUDAT DGOVUFTL
  DGOWB106 DGOWC106 DGOWD106 DGOWF106 DGOWF107 DGOWL106 DGOWUPDB
  DGOW1FIL FPEPSXCL FPEPW106 FPEUCBPR FPEUFTDS FPEUFTS2 FPEUIFCI
  FPEUIFC2 FPEUNIDT FPEVCTM  FPEVFTM  FPEVSFLR FPEVZMAI KO2CCAFB
  KO2OQALK KO2OQALS KO2OQAL2
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R540 PSY UI56463

     UP18/06/13 P F806

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.