DB2 V9.5 configuration

Edit online

Settings for DB2® Version 9.5 used in the 64-bit and 31-bit WebSphere® study with J2EE workloads include settings for the kernel, log files, and buffer pools.

These settings are illustrated in the script contained in Initial database setup.

Kernel settings

The recommended kernel semaphore settings are used, as described in Linux kernel settings for the DB2 Universal Database system.

Log files

Before creating a new database, scripts are run to define the DB2 log files and an appropriate buffer pool. The first three commands in Initial database setup specify these options:

DB2 logs will each have 65 MB of space
A value of 40 logs, for a total of 2.6 GB of log file space
The /db2log directory contains these 40 log files

Restarting DB2 causes the logs to be put to use, so the available space in the newlogpath directory then decreases, which reflects the allocation and use of the DB2 logs.

Buffer pools

The size of the default buffer pool is dependent on available memory, and is later readjusted by the DB2 autoconfigure commands. The size of the default buffer pool is set initially to 975 MB. This size then changes dynamically during execution, increasing or decreasing depending on the workload.