The Tablespace Analysis drilldown displays key performance statistics for the tablespaces in 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 Tablespaces tab.
From the Tablespaces tab, you can drill down to detailed information on I/O activity, I/O times, ranges, quiescers, and more for a certain tablespace. This is shown in sub drilldown tabs, which are displayed in the lower half of the window when a tablespace is selected. The additional statistics can be used to diagnose any problems detected in the Tablespaces tab.
The steps below outline the basic workflow involved in using the Tablespace Analysis drilldown.
To use the Tablespace Analysis drilldown
View top level tabs to detect performance problems in tablespaces. Work from the Tablespaces tab to check statistics. Work from Criteria tab to filter the list in the Tablespaces tab based on criteria such as level of I/O activity or amount of unusable space.
View rows in the Tablespaces tab to focus on a certain tablespace. When a database is being monitored, rows show information for a tablespace across all partitions and on individual partitions. Check columns in the Tablespaces tab to see statistics for a tablespace.
View sub drilldown tabs to see additional statistics for a certain tablespace. Click the tablespace row to display the tabs. The information they contain can help you diagnose problems detected in the Tablespaces tab.
Open a Toad for DB2 session to alter a tablespace or view its properties, storage exceptions, or historical and hypothetical growth requirements. (You must have either product licensed and installed on the same computer where the Spotlight for DB2 client resides.)
If you have Toad for DB2 installed, you can alter a tablespace, view it properties, or determine which tables and indexes in the tablespace need to be reorganized.
Right-click the tablespace entry in the list of tablespaces, and proceed as follows:
To alter a tablespace
Select Toad 4 Alter to open the Alter window, enabling you to change the tablespace properties.
To view tablespace properties
Select Toad 4 Properties to open the Toad database explorer on the tablespace.
To determine which tables and indexes in the tablespace need to be reorganized
Select Toad 4 Storage 4 Identify Exceptions to open the Space Exceptions window, enabling you to identify those tables and indexes in the tablespace that need to be reorganized or for which statistics need to be collected.
On the resulting window for any of these functions, press F1 for instructions to proceed with the function.