Configuring a Performance Database

You can use the sample statements in the sample library to create and to load a Performance Database. If you use an SMP/E sharing runtime environment, the sample library is TKO2SAMP. For all other types of runtime environments, the sample library is RKO2SAMP.

About this task

The Performance Database is a Db2 database that can hold aggregated and raw Db2 activity information spanning a long period of time. The type of data stored in the Performance Database depends on the reporter command (FILE or SAVE) used to create input data sets for the Db2 LOAD utility. This long-term history can help you with performance tuning activities, with trend analysis, and with capacity planning.
Important: If you are planning to use a Performance Warehouse and a Performance Database in the same Db2 subsystem, then you need to create the Performance Database tables with an owner ID that differs from the Performance Warehouse owner ID DB2PM.

For information about the structure of the Performance Database, including the types of data you can store in a Performance Database, and how it is formatted and loaded, see the IBM® OMEGAMON for Db2 Performance Expert on z/OS® Reporting User's Guide.

Procedure

  1. Create data for the Performance Database from already collected performance data.
    You can use the OMEGAMON® for Db2 PE batch reporter with either the FILE option or the SAVE option to create performance data. However, if you use the SAVE option, you must convert the data to the FILE format before you can load it into the tables.
  2. Create the Performance Database tables.
    You can use the sample CREATE statements in the RKO2SAMP library as a starting point and then modify the statements to meet your needs.
  3. Load data into the Performance Database.
    You can use the sample LOAD statements in the RKO2SAMP library and the Db2 LOAD utility. If you modified the CREATE statements from the RKO2SAMP library, you must also modify the LOAD statements.