Previous Topic: Reserve Free Space in Tablespaces and Indexes

Next Topic: DB2 Maintenance Levels


DB2 Subsystem Activity

The DB2 CPU usage and response time is affected by the presence and operational characteristics of other databases in the same DB2 subsystem, and other system activities. It is not accurate to compare, for example, the resource usage of the same application running in dissimilar uncontrolled environments with different subsystem and system workloads.

Beware of comparing percentage of CPU usage and CPU time between systems with different processing power.

DB2 can make use of specialist WLM facilities such as SRB enclaves. Ensure that your WLM setup reflects your business processing priorities.

ReportCenter does much of its database work in the background, and does not require the high priority and response times of a traditional OLTP application, where end user response time depends on database response.