Install DB2 v8.2 on CentOS 4/5/6

Linux 安裝

OS 安裝選用的套件

• X Window System
• GNOME Desktop
• Editors
• Graphical Internet
• Text-based Internet
• Server Configuration Tools
• Legacy Network Server
  • rusers
  • rwho
• Development Tools
• Compatibility Arch Development
• Legacy Software Development
  • compat-boost-1331
• Administration Tools
• System Tools
• Compatibility Arch Support

必要得套件安裝

• pdksh
• nfs-utils

安裝前的系統參數調整

編輯 /etc/sysctl.conf

fs.file-max = 8192
kernel.shmmax = 1073741824
kernel.shmall = 471859
kernel.msgmni = 4096
kernel.sem = 250 64000 32 2048
vm.lower_zone_protection = 250

註：kernel.shmax :for x86, here is 268435456 byte(256MB); for 64bit, here is 1073741824 byte(1GB)
kernel.shmall: physical memory(KB) * 90% / 4, 2048 * 1024 * 90% /4= 471859.2 , 請注意不可小於 Table 所需的 buffer pool的總值.

套用設定

#sysctl -p

#ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 1048576
max total shared memory (kbytes) = 1887436
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 2048
max semaphores per array = 250
max semaphores system wide = 64000
max ops per semop call = 32
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 4096
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

oom-kill 值修改為 0

#echo 0 > /proc/sys/vm/oom-kill

開始安裝 DB2 Server 主程式
在 X Window 環境下安裝)
#tar xzf DB2_V82_ESE_LNX_AMD64_NLV.tar.gz
#cd ese
#db2setup