Enabling Performance Warehouse
The Performance Warehouse is a collection of Db2 tables which store Accounting and Statistics performance and internal control information.
Before you begin
- The started task user ID must be DB2PM or associated with a group ID with the name DB2PM.
- If you want to install the Performance Warehouse Client, you must first enable Performance Expert Client support.
- Verify that your system supports started jobs.
- Create any storage groups that you will use for this Performance Warehouse database.
- Create 4 KB and 32 KB buffer pools that you will use for this Performance Warehouse database.
- Grant user DB2PM or group DB2PM access to the buffer pools that you will use for this Performance Warehouse database.
- In a data-sharing environment, you can enable Performance Warehouse for only one member of a data sharing group.
About this task
You must configure Performance Warehouse on Db2 subsystem level. It cannot be configured on monitoring profile level, because several configuration parameters are unique for each Db2 subsystem.
During the configuration process, you can define some parameters for the database, but the database name is always DB2PM and you cannot change it.