Skip to main content



Database server

developerWorks

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

DB2 recommendations for kernel parameters

When a Linux system should be used as a database server, some of the Linux kernel parameters have to be changed. DB2 recommends to set the kernel parameters to the following values for the versions v8.1 and v8.2:

Kernel parameter

Default value

Recommended value

Usage

----------------

----------------

------------------

-----------------------------

kernel.sem

250 32000 32 128

250 256000 32 1024

semaphore settings

kernel.msgmni

16

1024

max. queues system wide

kernel.msgmax

8192

65536

max. size of messages (bytes)

kernel.msgmnb

16384

65536

default size of queue (bytes)


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