PI41417: ANALYTICS ACCELERATOR MONITORING ENHANCEMENTS

Obtain the fix for this APAR.

APAR status

• Closed as unreproducible in next release.

Error description

• Analytics Accelerator Monitoring Enhancements
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Batch Reporting                            *
  *                 - PDB                                        *
  *                 - PE Server subtask                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 introduced new dynamic and static   *
  *                      statement cache counters (IFCID         *
  *                      316,401) and new data sections to       *
  *                      permit better statement level           *
  *                      granularity monitoring for the IBM DB2  *
  *                      Analytics Accelerator.                  *
  *                      DB2 introduced new counters that        *
  *                      Report the number of SQL statements     *
  *                      DB2 received and passed on to the       *
  *                      Accelerator as part of the in database  *
  *                      transformation ("Accelerator only       *
  *                      tables") feature.                       *
  *                      These counters are not supported in     *
  *                      the batch and online monitoring         *
  *                      components of OMEGAMON DB2.             *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF to get support for the        *
  *                 missing functionality.                       *
  ****************************************************************
  PROBLEM SUMMARY:
  1. New performance metrics for Accelerator statement level
     monitoring (IFCID 316,401) are not supported in batch
     reports and Performance Database.
  
  2. New performance metrics for Accelerator in database
     transformation ("Accelerator only Tables") are not
     supported in batch reports, Performance Database and
     Spreadsheet Input Data Generator.
  
  PROBLEM CONCLUSION:
  1. Show performance metrics for Accelerator statement level
     Monitoring in Batch Record Trace Reports and Performance
     Database.
  
  2. Show performance metrics for Accelerator in database
     transformation ("Accelerator only Tables") in Batch
     Accounting, Statistic and Record Trace Reports as well as
     the Performance Database and Spreadsheet Input Data
     Generator.
  
  Furthermore this PTF includes new functionality in the OMEGAMON
  DB2 Collector to leverage the metrics from #1 and #2 also in
  the OMEGAMON DB2 Online Monitoring interfaces (separate APARs).
  
  KEYWORDS:
  IDAA IDT SLM Q8ST Q8AC PERFORMANCE
  DATABASE PDB SPREADSHEET BATCH ACCOUNTING STATISTIC
  RECTRACE
  

Problem conclusion

Temporary fix

Comments

• PROBLEM SUMMARY:
  1. New performance metrics for Accelerator statement level
     monitoring (IFCID 316,401) are not supported in batch
     reports and Performance Database.
  
  2. New performance metrics for Accelerator in database
     transformation ("Accelerator only Tables") are not
     supported in batch reports, Performance Database and
     Spreadsheet Input Data Generator.
  
  PROBLEM CONCLUSION:
  1. Show performance metrics for Accelerator statement level
     Monitoring in Batch Record Trace Reports and Performance
     Database.
  
  2. Show performance metrics for Accelerator in database
     transformation ("Accelerator only Tables") in Batch
     Accounting, Statistic and Record Trace Reports as well as
     the Performance Database and Spreadsheet Input Data
     Generator.
  
  Furthermore this PTF includes new functionality in the OMEGAMON
  DB2 Collector to leverage the metrics from #1 and #2 also in
  the OMEGAMON DB2 Online Monitoring interfaces (separate APARs).
  
  KEYWORDS:
  IDAA IDT SLM Q8ST Q8AC PERFORMANCE
  DATABASE PDB SPREADSHEET BATCH ACCOUNTING STATISTIC
  RECTRACE
  

APAR Information

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

  PI22940

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

  UI31106

Modules/Macros

• BPOQSRGB DGOAACUM DGOABFXC DGOABLOG DGOABORD DGOABORE DGOABSXC
  DGOACALC DGOACFXC DGOACMER DGOACOMP DGOACREC DGOACSXC DGOADFXC
  DGOADIST DGOADNOR DGOADSXC DGOAEXIT DGOAEX20 DGOAFISA DGOAFLAT
  DGOAFORM DGOAIREC DGOAIREP DGOALFXC DGOALSXC DGOALUMP DGOAMTRC
  DGOAPARC DGOAQKEY DGOARCAL DGOAREDB DGOAREDC DGOAREDD DGOAREDG
  DGOAREDI DGOAREDM DGOAREDP DGOAREDR DGOAREDX DGOARXIT DGOASAVE
  DGOATOPR DGOATPRC DGOATRAC DGOATREC DGOAUPDB DGOAZMER DGOAZREC
  DGOBARAL DGOBARDD DGOBARLK DGOBARLO DGOBARPK DGOBARPO DGOBARPT
  DGOBARRI DGOBARRL DGOBARSH DGOBARSP DGOBARSQ DGOBARTE DGOBARTM
  DGOBATAL DGOBATDD DGOBATLK DGOBATLO DGOBATPK DGOBATPO DGOBATPT
  DGOBATRI DGOBATRL DGOBATSH DGOBATSP DGOBATSQ DGOBATTM 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 DGOFEDAT
  DGOFEPKG DGOFPDAT DGOFPRIC DGOFS254 DGOFS8ST DGOIPAIR DGOLREDC
  DGOLTRAC DGOLXRES DGOMLEXD DGOMSBCF DGONBFDS DGONBFD2 DGONBFSS
  DGONBFS2 DGONCFDS DGONCFD2 DGONCFSS DGONCFS2 DGONDFDS DGONDFD2
  DGONDFSS DGONDFS2 DGONFILE DGONF250 DGONF260 DGONF270 DGONF280
  DGONF310 DGONF320 DGONF330 DGONF340 DGONF350 DGONF360 DGONF370
  DGONF380 DGONF410 DGONF500 DGONF8ST DGONIREC DGONLFDS DGONLFD2
  DGONLFSS DGONLFS2 DGONTRAC DGONUPDB DGOPAA10 DGOPAB10 DGOPACNV
  DGOPSA10 DGOPSB10 DGOPSCNV DGORAEXT DGORASCN DGORCREC DGORCREP
  DGORCRE2 DGORDIST DGORINEX DGORIREC DGORIREP DGORPACC DGORPCAP
  DGORPEXI DGORPHIL DGORPHVA DGORPIOA DGORPMIN DGORPPAG DGORPPAR
  DGORPRID DGORPSCA DGORPSOR DGORPSUS DGORPUDF DGORRCAP DGORRCOM
  DGORRDAT DGORRDDF DGORREXI DGORRHIL DGORRHVA DGORRIOA DGORRLOC
  DGORRMIS DGORRSOR DGORRSQL DGORRTHR DGORSRBY DGORUACC DGORUSUM
  DGORUWRK DGORZREP DGOSACUM DGOSAPAW DGOSAPTX DGOSBLKX DGOSBORD
  DGOSBORE DGOSBXCL DGOSCXCL DGOSDXCL DGOSFILE DGOSFMTQ DGOSFMTS
  DGOSI369 DGOSLXCL DGOSPREP DGOSPREQ DGOSREPM DGOSSAVE DGOSSWSR
  DGOSTRAC DGOSUPDB DGOTAEXT DGOTBWKL DGOTCREP DGOTIREC DGOTIREP
  DGOVCRDB DGOVDB2C DGOVEE00 DGOVFTAB DGOVFTIN DGOVHMM1 DGOVMSTR
  DGOVRA   DGOVSCLO DGOVSCNI DGOVSCNT DGOVSCS2 DGOVSCT1 DGOVSDSC
  DGOVSFLR DGOVSGFT DGOVSLOC DGOVSORT DGOVSQFM DGOVSTQL DGOVS700
  DGOVUDAT DGOVUELD DGOVUFTL DGOWFILE DGOWF256 DGOXF000 DGOXF002
  DGOXF003 DGOXF006 DGOXR000 DGOXS003 DGOXT002 DGOXT003 DGOXT006
  FPECHASY FPECHATS FPECMDAT FPEPAFXC FPEPASXC FPEPSXCL FPEUCBPR
  FPEUCXSX FPEUFTDS FPEUFTS2 FPEUIFCI FPEUIFC2 FPEUNIDT FPEUVTMM
  FPEVDB2C FPEVFTM  FPEVRDS1 FPEVRDS2 FPEVSETM FPEVSFLR FPEVZMAI
  KO2APC7A KO2CCAFB KO2CSY3A KO2OQALA KO2OQALK KO2OQALS TDK$LNCK
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI31106

     UP15/09/17 P F509

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.