Filter
Top Products
set msgsys:msginfo_msgmap=0x102
set msgsys:msginfo_msgmni=0xFF
set msgsys:msginfo_msgssz=0x10
set msgsys:msginfo_msgtql=0x400
set shmsys:shminfo_shmmax=0x20000000
set shmsys:shminfo_shmseg=0x32
set shmsys:shminfo_shmmni=0x12C
set semsys:seminfo_semmni=0x400
set semsys:seminfo_semmap=0x400
set semsys:seminfo_semmns=0x800
set semsys:seminfo_semmnu=0x800
set semsys:seminfo_semume=0x32
The settings can be verified with these commands:
# ipcs –a
# sysdef | egrep MSG\|SEM\|SHM
This information is also available in the DB2 knowledge base at:
http://www-3.ibm.com/cgi-
bin/db2www/data/db2/udb/winos2unix/support/document.d2w/report?fn=db2v7ixdb2ix31.htm#HDR
UPDATE_SOLARIS_KERNEL.
• LINUX USERS: Running DB2 on a Linux 2.4 server requires changes to the Linux kernel parameters.
Recompile the kernel source as explained below
before you install DB2 on the server.
• Change the msgmni parameter to 256 with the following command:
echo 256 > /proc/sys/kernel/msgmni
This resets the maximum number of SYSV IPC message queues from the default of 16 to 256.
• Increase SEMMNI from 128 to 2048.
This specifies the maximum number of semaphore IDs allowed in the kernel; the upper limit for this
value is 32768.
• Increase SEMMSL from 250 to 500.
This specifies the maximum number of semaphores per sem ID; the upper limit for this value is 8000.
• Increase SEMOPM from 32 to 256.
This specifies the maximum number of operations allowed per semop() call; the upper limit for this value
is 1000.
• Increase the number of open files using the command:
echo 32768 > /proc/sys/fs/file-max
Chapter 9: Installing and Configuring Database Servers and Schema 39