Install DB2 v9.7 on CentOS

說明

• CentOS 6.7 x86_64
• IBM DB2 v9.7 Server
   

可支援的 Linux 版本與 Hypervisors (需要虛擬化時)

官網連結：http://www-969.ibm.com/software/repo...Platform=Linux

更多系統需求可以閱讀附檔區的文件。

安裝前步驟

準備安裝檔：

1. DB2_AESE_97_Linux_x86-64.tar.gz，DB2 主程式
2. v9.7fp11_linuxx64_universal_fixpack.tar.gz，DB2 fixpack
    

CentOS 安裝模式：Minimal Desktop

需要的其它套件：
NOTE: libstdc++ 需要 32bit 與 64bit 都安裝。

# rpm -qa | grep "ksh\|openssh\|rsh-server\|nfs-utils\|libaio\|libstdc++\|libstdc++.i686\|pam-devel\|pam-devel.i686"
libstdc++-4.4.7-16.el6.x86_64
nfs-utils-lib-1.1.5-11.el6.x86_64
openssh-clients-5.3p1-111.el6.x86_64
pam-devel-1.1.1-20.el6.i686
libaio-0.3.107-10.el6.x86_64
ksh-20120801-28.el6.x86_64
libstdc++-4.4.7-16.el6.i686
openssh-server-5.3p1-111.el6.x86_64
pam-devel-1.1.1-20.el6.x86_64
nfs-utils-1.2.3-64.el6.x86_64
openssh-5.3p1-111.el6.x86_64
rsh-server-0.17-64.el6.x86_64

CentOS 系統調校：

關閉 SELinux
#> setenforce 0
#> sed -i 's/SELINUX=.*$/SELINUX=disabled/' /etc/selinux/config  

停用 NetworkManager
#> service NetworkManager stop
#> chkconfig NetworkManager off

調整系統核心參數

#> ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096                                                     // SHMMNI
max seg size (kbytes) = 67108864                                                    // SHMMAX
max total shared memory (kbytes) = 17179869184             // SHMALL
min seg size (bytes) = 1   

------ Semaphore Limits --------
max number of arrays = 128                                                               // SEMMNI
max semaphores per array = 250                                                     // SEMMSL
max semaphores system wide = 32000                                        // SEMMNS
max ops per semop call = 32                                                                // SEMOPM
semaphore max value = 32767

------ Messages: Limits --------
max queues system wide = 7916                                                      // MSGMNI
max size of message (bytes) = 65536                                             // MSGMAX
default max size of queue (bytes) = 65536                                  // MSGMNB

編輯 /etc/sysctl.conf
從最下方加上這幾行

# for DB2
# shmmax: 4GB
# shmall: 3.5GB
fs.file-max = 8192
kernel.shmmax = 4294967296
kernel.shmall = 917504
kernel.msgmni = 4096
kernel.sem = 250 64000 32 2048

套用後再確認一次

#> sysctl -p
#> ipcs -l

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 4194304
max total shared memory (kbytes) = 3670016
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) = 65536
default max size of queue (bytes) = 65536

安裝開始

tar xzf DB2_AESE_97_Linux_x86-64.tar.gz
cd aese/
./db2prereqcheck
./db2_install -f NOTSAMP

tar xzf v9.7fp11_linuxx64_universal_fixpack.tar.gz
cd universal/
./db2prereqcheck

./installFixPack

新增 DB Instance

新增帳號與群組

#> groupadd db2adm
#> useradd -g db2adm -c "DB2 Instance User" devinst

#> cd /opt/ibm/db2/V9.7/instance/
#> ./db2icrt -s ese -u devinst devinst