CPU

Edit online

CPU utilization should be about 70 to 80% of the total CPU time. Lower utilization means that the CPU can cope better with peak workloads. Workloads between 85% to 90% result in queuing delays for CPU resources, which affect response times. CPU utilization above 90% usually causes unacceptable response times.

While running batch jobs, backups, or loading large amounts of data, the CPU might be driven to high percentages such as to 80 to 100% to maximize throughput.

DB2® supports the following processor configurations:
Uni-Processor
A single system that contains only one single CPU
SMP (symmetric multiprocessor)
A single system that can contain multiple CPUs. Scalability is limited to the CPU sockets on the motherboard.
MPP (massively parallel processors)
A system with multiple nodes connected over a high speed link. Each node has its own CPUs. Adding new nodes achieves scalability.
Note:
  1. Inefficient data access methods cause high CPU utilization and are major problems for database system. Regular database maintenance is an important factor.
  2. Paging and swapping require CPU time. Consider this factor while planning your memory requirements.