Viewing DB2 Object Performance Data in the Investigator › Subsystem Performance Monitoring › View Subsystem Performance Activity

View Subsystem Performance Activity

You can view current and historical DB2 subsystem performance data from the Investigator. This functionality helps DBAs identify performance problems as they occur, fix critical issues before they impact service levels, and track performance trends for proactive performance management.

The DB2 subsystem performance data is accumulated from DB2 startup (Accum) or the difference between the current and the previous time interval (Delta). This data lets you monitor and tune DB2 subsystem performance and activity.

Follow these steps:

1. Add the Investigation Launcher module to a dashboard, and click Start New Investigation.
2. Select DBA for DB2 from the discipline drop-down list.
3. Open the Subsystem Performance category. Use filters to specify DB2 subsystem information.

   Subsystem performance data appears.

4. Click the Filter icon, which resides above the table on the left.
5. Filter data using the available drop-down lists. Use the Select Time Range fields to indicate whether you want to view current or historical collection interval data. To view current interval data, specify the same Start Date and End Date or click Reset.

   The Investigator displays tabular data that meets your filter criteria.

6. (Optional) Select rows of data and specify the Action to perform.

   The applicable data appears.

7. (Optional) Change parameter values unique to the current dialog using the following View drop-down list values:

   Accum

   Displays data representing total statistical accumulation since DB2 was started.

   Delta

   Displays the difference between values that are found at this interval and the last interval (current interval value - previous interval value).

   The values increase if you change from Delta to an Accum view. The values decrease if you change from an Accum to a Delta view.