Kernel parameters

DB2 v11

/etc/sysctl.d/01-db2.conf:

# For DB2 server with 30 GB RAM
# - Get the RAM size by following the command 'free -g'
# - Get the PAGESIZE by following the command 'getconf PAGESIZE'
#
# SHMMNI = <RAM in GB> * 256
# SHMMAX = <RAM in bytes>
# SHMALL = <RAM in pages> * 2
# kernel.sem=<SEMMSL> <SEMMNS> <SEMOPM> <SEMMNI>
# kernel.sem = 250 256000 32 256*<size of RAM in GB>
# MSGMNI = 1024*<size of RAM in GB>
#
kernel.shmmni = 7680
kernel.shmmax = 32212254720
kernel.shmall = 15728640
kernel.sem = 250 256000 32 7680
kernel.msgmni = 30720
kernel.msgmax = 65536
kernel.msgmnb = 65536
# IBM Recommended
vm.swappiness = 5
vm.overcommit_memory = 0