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

View Application Performance Activity

You can view current and historical DB2 application performance activity (workload characteristics and resource use) in the Investigator for data sharing groups and individual DB2 subsystems. This data lets you monitor resource activity and performance on your monitored DB2 subsystems and data sharing groups.

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. Drill down to an application performance activity.

   Application performance data appears. Use filters to specify DB2 subsystem information.

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.
   • Use the TOTAL/AVG fields to view totals or averages in the column data for plans, packages, SQL activity, dynamic SQL activity, and view by keys. This setting is saved from session to session unless you explicitly change it.

   The Investigator displays tabular data that meets your filter criteria.

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

   The applicable data appears, with header information that provides the context for the data.