Rate this page Print this page Email this page

BMC APPTUNE for DB2

Business Challenge

As DB2 applications become more complex and DB2 data experiences rapid growth, DB2 applications frequently fail to meet performance goals. Pinpointing the cause of degraded application performance can be both time-consuming and difficult.

Business Need

  • Identify DB2 objects accessed by a specific SQL statement
  • Identify SQL that executes different queries from a single plan, program or section number
  • Identify large resource-consuming or performance-constrained SQL statements
  • View Host Variable values for static and dynamic SQL statements
  • Enable identification of dynamic SQL statements that are affecting performance

Our Solution

BMC APPTUNE for DB2 alleviates problems caused by inefficient or run-away SQL statements. It provides the most accurate information on SQL statement performance and DB2 object performance characteristics while minimizing resources consumed in gathering information. This data can then be used to maximize SQL statement and DB2 object efficiency, thus improving application and overall system performance.

Key Features & Benefits

  • Provides a user-friendly design of the complete product that is easy to learn
  • Identifies the most heavily used DB2 objects quickly and easily
  • Identifies resource-consuming SQL statements without running a DB2 SQL trace
  • Collects DB2 consumption and performance data at the level of unique SQL text