Product descriptions

Most of the products share the same dialog architecture, enabling data sharing and exceptional ease of use across products. The following products can share the same started task and can be accessed through a common dialog box:

• BMC AMI Apptune for Db2—A tool for tuning SQL statements and troubleshooting Db2 application performance
• BMC AMI Pool Advisor for Db2—A tool for monitoring Db2 pools, identifying inefficient use, and suggesting and implementing modifications to gain maximum benefit from storage resources
• BMC AMI SQL Explorer for Db2—A tool for analyzing SQL statements and database structures to optimize application performance

• BMC AMI Ops Monitor for Db2 - Data Collector—A selectable component of the BMC AMI Ops Monitor for Db2 product that allows BMC AMI Opsusers to share some functions of the Performance Activity products Data Collector

  This component provides access to Db2 performance data that supplements the data already available via BMC AMI Ops Monitor for Db2.

• BMC System Performance for Db2—A solution that combines the features and functions of BMC AMI Ops Monitor for Db2, OPERTUNE for DB2, and BMC AMI Pool Advisor for Db2 with a supplemental set of comprehensive reports on all aspects of Db2
• SQL Performance for DB2—A solution that combines the features and functions of the BMC AMI Apptune for Db2 and BMC AMI SQL Explorer for Db2 components with a comprehensive index reporting function that is available only with the solution
• Performance Advisor Database—The SQL Performance for DB2 solution includes a set of features that are collectively called the Performance Advisor Database. These advisors improve the efficiency of the SQL statements. They include:
  • Workload Access Path Compare—compares static and dynamic statement access paths over time, across subsystems, application versions, and Db2 releases and identifies the impact.
  • Workload Index Advisor—improves SQL performance of a workload by recommending which indexes need to be created, kept, or dropped.
  • Reorg Advisor—provides reorg recommendations based on physical characteristics plus performance characteristics of objects. Ideally you only want to REORG objects that are disorganized and show degraded performance since last REORG. You do not want to reorg objects that cannot benefit from it.
  • Exception Advisor—examines the data accompanying the triggered exception and compares that data to past execution statistics for the same statement in baseline or aggregated tables.