Viewing DB2 Object Performance Data in the Investigator › Performance Warehouse

Performance Warehouse

The Performance Warehouse folder in the Investigator lets you view historical performance data from CA Detector, CA Subsystem Analyzer, and CA SYSVIEW for DB2 that is stored in DB2 tables. Using the Performance Warehouse data, you can:

• Access data that you have in DB2 and avoid duplication of data and save resources.
• Take advantage of existing backup and recovery procedures for DB2 data.
• Save on storage using the built in data compression that is available in DB2.
• Monitor data points graphically in the Time Series Facility.
• Sort application data for plans, SQL statements, dynamic SQL, and exception SQL by totals or averages.

You can also navigate to the Performance Warehouse from the Application Performance and Subsystem Performance folders.

You can analyze existing historical performance data from the following application and subsystem folders in the Investigator:

• Application
  • Plans
  • SQL statements
  • Dynamic SQL statements
  • SQL Error Activity
  • Exception SQL Activity
  • View by Keys
• Subsystem
  • Buffer Pool I/O Activity
  • Database I/O Activity
  • Storage Volume I/O Activity

You can also navigate to the Performance Warehouse from the Application Performance and Subsystem Performance folders. Use the provided actions to drill down further into historical performance activity.