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,  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.

 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).

 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 's online or batch reporting functions, you can report on multiple Db2 subsystems across multiple z/OS images.

 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.  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,  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.

 is a component of the  solution, which integrates the features and functions of , , and the Index Component (available only with the  solution) into a single product interface.