IBM Books

Installation and Configuration Supplement


Step 2. Update the Kernel Configuration Parameters

To run DB2 for Solaris, you may have to update some kernel configuration parameters. The following minimum values are recommended:

Table 31. Solaris Kernel Configuration Parameters (Recommended Values)
Kernel Parameter Physical 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
 

65 535(1)
65 535(1)
130
128
16
256
8 192
 
67 108 864
16
300
 
128
130
256
256

65535(1)
65 535(1)
258
256
16
512
16 384
 
134 217 728(2)
16
300
 
256
258
512
512

65 535(1)
65 535(1)
258
256
16
1024
32 768
 
268 435 456(2)
16
300
 
512
514
1024
1024

65 535(1)
65 535(1)
258
256
16
1024
32 768
 
536 870 912(2)
16
300
 
1024
1026
2048
2048

Notes:

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

  2. The shmsys:shminfo_shmmax parameters should be set to the suggested value in the above table, or 90% of the physical memory (in bytes), whichever is higher. For example, if you have 196 MB of physical memory in your system, set the shmsys:shminfo_shmmax parameter to 184968806 (196*0.9*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/V6.1/cfg directory. The names for these files are as follows:

kernel.param.64MB
for systems with 64MB-124MB of physical memory

kernel.param.128MB
for systems with 128MB-256MB of physical memory

kernel.param.256MB
for systems with 256MB-512MB of physical memory

kernel.param.512MB
for systems with 512MB-1GB of physical memory

Depending upon the amount of physical 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.

After updating the /etc/system file, reboot the system.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]