Skip to main content



Database server

developerWorks

General DB2 Informix Oracle
   Recommendations  |   Performance papers  |   More
  DB2 recommendations for kernel parameters
  CPU scaling
  DB2 parameters
CPU scaling

High OLTP workloads may benefit from running on several processors, even if the processors are not entirely used. The I/O subsystem under Linux profits from having several CPUs available on the system.

OLTP Workload - CPU Scaling

Test environment
  • IBM eServer zSeries 900 (2064-216)
  • IBM TotalStorage Enterprise Storage Server 2105-800
  • LPAR with 1-12 CPUs, 16GB memory
  • Novell/SUSE SLES 8 + SP3 for IBM zSeries (64-bit), updated kernel 2.4.21-228
  • IBM DB2 Universal Database ESE v8.2 (64-bit)
  • Benchmark DB2 OLTP
  • Database data Logical Volume (LV): 8 CHPIDs, 8 host adapters, 25 x 10GB FCP/SCSI disks in 8 ranks, ext2 filesystem

Back to top



Team
Please address any comments to the performance team: linux390@de.ibm.com