Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

Step 2. Update the Kernel Configuration Parameters

To run DB2 Extended Enterprise Edition for Solaris, you may have to update some kernel configuration parameters; the following minimum values are recommended:

Table 7. Solaris Kernel Configuration Parameters (Recommended Values)

Kernel Parameter	Virtual Memory
	64MB - 128MB	128MB - 256MB	256MB - 512MB	512MB+
msgsys:msginfo_msgmax msgsys:msginfo_msgmnb msgsys:msginfo_msgmap msgsys:msginfo_msgmni msgsys:msginfo_msgssz msgsys:msginfo_msgtql msgsys:msginfo_msgseg shmsys:shminfo_shmmax shmsys:shminfo_shmseg shmsys:shminfo_shmmni semsys:seminfo_semmni semsys:seminfo_semmap semsys:seminfo_semmns semsys:seminfo_semmnu	65535 (1) 65535 (1) 130 128 16 128 8192 67108864 16 300 128 130 256 256	65535 (1) 65535 (1) 258 256 16 256 16384 134217728 (2) 16 300 256 258 512 512	65535 (1) 65535 (1) 258 256 16 256 32768 268435456 (2) 16 300 512 514 1024 1024	65535 (1) 65535 (1) 258 256 16 512 32768 268435456 (2) 16 300 1024 1026 2048 2048

Notes:

1. The msgsys:msginfo_msgmnb and msgsys:msginfo_msgmax parameters must be set to 65535.

2. The shmsys:shminfo_shmmax parameters should be set to the suggested value in the above table, or 90% of the virtual memory (in bytes), whichever is higher. For example, if you have 196 MB of virtual memory in your system, set the shmsys:shminfo_shmmax parameter to 184968806 (176*1024*1024).

To set a kernel parameter, add a line at the end of the /etc/system file as follows:

   set parameter-name = value

For example, to set the value of the msgsys:msginfo_msgmax parameter, add the following line to the end of the /etc/system file:

   set msgsys:msginfo_msgmax = 65535

Sample files for updating the kernel configuration parameters are provided in the /opt/IBMdb2/V5.0/cfg directory. The names for these files are as follows:

• kernel.param.64MB for systems with 64MB-124MB of virtual memory
• kernel.param.128MB for systems with 128MB-256MB of virtual memory
• kernel.param.256MB for systems with more than 256MB-512MB of virtual memory
• kernel.param.512MB for systems with more than 512MB of virtual memory

Depending upon the amount of virtual memory in your system, append the appropriate kernel configuration parameter file to the /etc/system file. If necessary, change the value of the shmsys:shminfo_shmmax parameter as described in Note 2 above, then reboot the system.

[ DB2 List of Books | Search the DB2 Books ]