The Database Analysis drilldown displays key performance statistics for all active databases and database partitions in an instance. At its top level, the drilldown provides an overview of performance during the current monitoring session. This is shown in the Databases tab.
From the Databases tab, you can drill down to detailed information on caching, sorting, locking, I/O activity, and more for a certain database or partition. This is shown in sub drilldown tabs, which are displayed in the lower half of the window when a database or partition is selected. The additional statistics can be used to diagnose any problems detected in the Databases tab.
The steps below outline the basic workflow involved in using the Database Analysis drilldown.
To use the Database Analysis drilldown
View top level tabs to detect problems in a database. Work from the Databases tab to check statistics. Work from Criteria tab to filter the list in the Database tab based on criteria such as level of physical I/O or number of locks held.
View sub drilldown tabs to see additional statistics for a certain database. Click the database row to display the tabs. The information they contain can help you diagnose problems detected in the Databases tab.
Open a Toad for DB2 or session to view properties, update configuration parameters, or identify storage problems for a specific database or database partition. (You must have either product licensed and installed on the same computer where the Spotlight for DB2 client resides.)