Viewing DB2 Object Performance Data in the Investigator › View DB2 Object Performance Data in the Time Series Facility

View DB2 Object Performance Data in the Time Series Facility

The Time Series Facility (TSF) stores data that is collected and provided by CA products. TSF provides a single point for collection, storage, management, and organization of the product data. When you request a Time Series chart from the Investigator, TSF provides the data content for the chart.

TSF lets you quickly compare performance data, which can help you complete the following tasks:

• Troubleshoot an issue
• Identify an area that is approaching a questionable threshold
• Compare data from a different or similar time period

Each selected metric produces a chart and each selected entity produces a line on the chart. You can produce up to four charts with up to four entities on each chart. You can set time ranges and end dates. Data that is presented on the charts appears in local time. However, the data may have been collected from a different time zone and may reflect the performance issues of this different time zone.

You can add DB2 application performance entities to TSF with CA Chorus for DB2 Database Management. This feature lets you automate tracking and graphing of comparative historical data analysis for easier diagnosis and resolution of performance issues. TSF displays DB2 application performance data and supports graphing over time. When you add a DB2 application performance object (plan, package, SQL activity, and dynamic SQL) to TSF, it becomes an entity. You can then use it to create a graph to view performance data over time.

Note: For detailed common TSF concepts and procedures, see the CA Chorus Product Guide.

This example shows how to add and analyze a DB2 package using TSF.

Follow these steps:

1. Navigate the Investigator tree to the Application Performance folder, and select Packages.
2. Highlight the required package, and click Add Entity to Time Series.

   The package is added to the TSF, and the TSF panel appears.

3. Select the entity from the Chart Selection Tools section.

   The list of metrics for the selected entity appears.

4. Select the required metric.

   The metric is highlighted.

5. Click Perform Charting.

   TSF produces a chart for the selected metric. The selected entity becomes a line on the chart.

6. Select an entity from the Contributors drop-down list, and click Contributors.

   The Entities panel becomes the Base Entities panel and shows the original criteria that the Investigator passed for the selected entity.

7. Click the Contributors drop-down list.

   The drop-down list shows the valid contributors.

   Note: To exit the contributors function, click Back to Entities.

8. Select a contributor type.

   A list of all the contributors for the selected entity and metric combination appears.

9. Click Perform Charting.

   The new chart is generated from the selected entities.