PI48095: ANALYTICS ACCELERATOR EXTENSIONS IN PERFORMANCE EXPERT CLIENT

db2pe.client.v5.3.1.0.8445.win64
db2pe.client.v5.3.1.0.8445.win32

APAR status

• Closed as unreproducible in next release.

Error description

• Analytics Accelerator extensions in Performance Expert Client
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - PE/PWH/BPA Client                          *
  ****************************************************************
  * 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.                              *
  ****************************************************************
  PROBLEM SUMMARY:
  New performance metrics for Accelerator statement level
  monitoring (IFCID 316,401) and the in database
  transformation ("Accelerator only tables") feature
  are not supported in the PE Client.
  
  PROBLEM CONCLUSION:
  Show performance metrics for Accelerator statement level
  Monitoring and the in database transformation ("Accelerator
  only tables") feature in different panels of PE Client
  Statistics and Thread Details.
  
  KEYWORDS:
  IDAA IDT SLM PECLIENT STATISTICS DETAILS DYNAMIC
  STATIC STATEMENT CACHE THREAD
  

Problem conclusion

Temporary fix

Comments

• PROBLEM SUMMARY:
  New performance metrics for Accelerator statement level
  monitoring (IFCID 316,401) and the in database
  transformation ("Accelerator only tables") feature
  are not supported in the PE Client.
  
  PROBLEM CONCLUSION:
  Show performance metrics for Accelerator statement level
  Monitoring and the in database transformation ("Accelerator
  only tables") feature in different panels of PE Client
  Statistics and Thread Details.
  
  KEYWORDS:
  IDAA IDT SLM PECLIENT STATISTICS DETAILS DYNAMIC
  STATIC STATEMENT CACHE THREAD
  

APAR Information

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

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

  UI31230

Modules/Macros

• FPEK$INF
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R530 PSY UI31230

     UP15/10/08 P F510

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.