Adjusting operating system parameters for Linux

In order for DB2 Everyplace to operate with the highest degree of efficiency, system parameters in DB2 Universal Database need to be adjusted. Failure to do so, can result in the inability to create a new connection to the database on Linux. It is recommended that the kernel parameters are adjusted.

Note:: Only 32 bit DB2 Universal Database instances are supported.

Prerequisites

Modify the login profile to include the following:

export DISPLAY=<workstation>:0.0

Where <workstation> is the UNIX workstation where you want to use the Mobile Devices Administration Center.

Procedure

For Linux systems running kernel 2.4 or higher, issue the following commands on the command line as the root user:

sysctl -w kernel.msgmni=2048
sysctl -w kernel.shmmax=1073741824
sysctl -w fs.file-max=32768
sysctl -w kernel.sem="512 32000 32 1024"
sysctl -w kernel.threads-max=20480

To execute the commands automatically, edit the file /etc/rc.d/rc.local, and place the above commands at the end of the file. On every subsequent system boot, the values will be set automatically. Additional setting recommendations can be found in the Linux 7.2 Release Notes for the fix pack you are running.

Related tasks