Performance Database

The Performance Database is a Db2 database that holds aggregated, long-term Db2 activity information that you can leverage for performance tuning, trend analysis, and capacity planning.

Performance data that is to be loaded into the Performance Database is first prepared using the Batch Reporter, which formats the data in timestamp sequence (FILE format) or as reduced data (aggregated data or summary data, called SAVE format). After data is loaded into the Performance Database, you can then use SQL to retrieve, aggregate, or filter information to suit your objectives.

The Performance Database stores the following performance data:

• Accounting
• Audit
• Locking
• Record traces
• Statistics
• System parameters

You must manually build, load and maintain the Db2 tables for the Performance Database. A sample library rHilev.rte_name.RKO2SAMP (where rHilev.rte_name is the runtime high-level qualifier) is included which contains:

• The definitions of the Data Definition Language (DDL)
• The definitions of the Data Manipulation Language (DML)
• The Db2 LOAD Statements