Overview of the Performance Warehouse database
To analyze your performance data, you can run SQL queries against the tables in the Performance Warehouse database. The sample queries delivered with Performance Warehouse help you understand the contents of, and relationships between, the tables and how data can be joined to evaluate performance data and identify performance problems.
However, to use your queries efficiently, you must understand the data model designed for the performance-relevant tables. In addition, you must be familiar with the LOADLOG table, which you need to access and manage the data in the Performance Warehouse database, for example, if you want to delete or archive it.
The Performance Warehouse database consists
of:
- Performance Warehouse data tables that store the DB2® performance data collected from DB2.
- Control tables that establish the infrastructure of Performance Warehouse.