Viewing DB2 Object Performance Data in the Investigator › Application Performance Monitoring › Chart Data

Chart Data

When you are viewing plan, package, SQL, or dynamic SQL column data in a table list, use the chart (graph) icon to view a graphical representation of the following data:

• The percentage of total interval or package INDB2 time (TIMEPCT)
• The percentage of total interval or package INDB2 CPU time (CPUPCT)
• The total or average number of getpage requests (GETPAGE)
• All wait times (TOTAL_WTIME)

The ability to see activity graphically, at a glance, can help you identify and understand your system's health. Charts also help you to identify data anomalies.

CA Chorus for DB2 Database Management collects current data to build a chart.

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. Click the Chart icon from the table list.

   The column data for TIMEPCT appears in the form of a pie (circle) chart.

4. Select other column values from the drop-down list.

   New data appears in the graph based on your selection.