Spotlight on DB2 6.9.3 - Getting Started Guide

Client Application Analysis drilldown

The Client Application Analysis drilldown displays key performance statistics for all applications connected to monitored databases and partitions. At its top level, the drilldown provides an overview of performance during the current monitoring session. This is shown in the Client Applications tab.

From the Client Applications tab, you can drill down to detailed information on caching, sorting, locks, lock chains, units of work, and more for a certain application. This is shown in sub drilldown tabs, which are displayed in the lower half of the window when an application is selected. The additional statistics can be used to diagnose any problems detected in the Client Applications tab.

Using the Client Application Analysis drilldown

The steps below outline the basic workflow involved in using the Client Application Analysis drilldown.

To use the Client Application Analysis drilldown

1. View top level tabs to detect performance problems in client applications. Work from the Client Applications tab to check statistics. Work from Criteria tab to filter the list in the Client Applications tab based on criteria such as number of lock waits or timeouts.

   Tip: To reduce the overhead incurred by this drilldown, show only active applications on the Client Applications tab. Right-click within the list of applications on the tab, and select Show only 'active' applications. This feature is not available on IBM DB2 10.5 and later if Monitor Functions Method is used to retrieve data.

2. View rows in the Client Applications tab to focus on a application. Check columns in the Client Applications tab to see statistics for an application.
3. View sub drilldown tabs to see additional statistics for a certain application. Click the row for the application to display the tabs. The information they contain can help you diagnose problems detected in the Client Applications tab.
4. If the drilldown reveals problems with certain SQL statements, you can tune the statements using SQL Optimizer for DB2. (You must have either product licensed and installed on the on the same computer where the Spotlight for DB2 client resides.) SQL Tuning sessions can be opened from the Unit of Work - SQL sub drilldown.
5. If the drilldown reveals that certain applications are having a major impact on a database, you can force the applications to disconnect from the DB2 instance.

Related topics

Top level tabs

Sub drilldown tabs

Columns in the Client Applications tab