Introduction to Apptune

The gathered data provides valuable information about performance and resource use of Db2 applications.

Unlike other Db2 performance aids that rely on expensive Db2 SQL traces to gather data, Apptune collects all relevant performance measures in real time for every SQL statement executed in one or more Db2 subsystems. The product then summarizes the collected data and stores it for analysis. This method of collecting data provides detailed information about the performance and resource usage of Db2 applications while avoiding the costly overhead and large volumes of data associated with other Db2 performance aids.

Apptune combines analysis of SQL statements with analysis of the objects that the statement accesses. You can identify the most heavily accessed Db2 tables and indexes, and you can analyze table and index GETPAGE activity, buffer pool efficiency, and I/O response time by subsystem, buffer pool, database, and data set (table space and index space).

Apptune can collect data from all of the Db2 subsystems on each z/OS image across the sysplex. This allows you to analyze collected data by individual Db2 subsystem, or to analyze data aggregated from multiple Db2 subsystems. Using Apptune's online or batch reporting functions, you can report on multiple Db2 subsystems across multiple z/OS images.

Apptune includes a user interface and analysis capabilities that have been engineered for completeness and ease of use. In most cases, you need only three keystrokes to access the data required to tune an SQL statement. Apptune provides a variety of reports that allow you to "zoom" or "expand" to multiple levels of performance data to get the answers you need to solve a performance problem. You can display the reports in a traditional numeric presentation or an easy-to-understand graphical presentation. Most reports are available in online and batch formats.

To facilitate the tuning of SQL statements, Apptune includes an integrated, robust Explain function that dynamically Explains SQL statements, then interprets and summarizes the results in an easy-to-read and understandable format.

Apptune is a component of the SQL Performance for DB2 solution, which integrates the features and functions of Apptune, BMC AMI SQL Explorer for Db2, and the Index Component (available only with the SQL Performance for DB2 solution) into a single product interface.