Page last modified 13:41, 3 Feb 2016 by alang

Install DB2 v9.7 on CentOS

內容表格

1. 說明
2. 安裝前步驟
3. 安裝開始
1. 3.1. 主程式安裝
2. 3.2. 更新檔 fixpack 安裝
4. 新增 DB Instance
5. 匯入 DB2 授權檔

版本為 06:39, 27 Nov 2024

返回到版本存檔.

查閱目前版本

說明

CentOS 6.7 x86_64
IBM DB2 v9.7 Server

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

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

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

安裝前步驟

準備安裝檔：

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

CentOS 安裝模式：Minimal Desktop

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

# yum install libstdc++.i686 pam-devel pam-devel.i686 ksh rsh-server

# 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 256000 32 1024
kernel.randomize_va_space = 0

套用後再確認一次

#> 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

-f NOTSAMP : 不要安裝 SAMP (System Automation for Multiplatforms)，因為 CentOS 不支援這功能。

Default directory for installation of products - /opt/ibm/db2/V9.7

***********************************************************
Do you want to choose a different directory to install [yes/no] ?
no

Specify one of the following keywords to install DB2 products.

AESE
CLIENT
RTCL

Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
AESE

更新檔 fixpack 安裝

檔案名稱: v9.7fp11_linuxx64_universal_fixpack.tar.gz

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

如果出現錯誤:
DBT3534W The db2prereqcheck utility determined that ASLR is set to ON and that this could cause issues with some tools.

解決: 編輯 /etc/sysctl.conf, 加上這一行
kernel.randomize_va_space = 0
執行 echo 0 > /proc/sys/kernel/randomize_va_space

WARNING:
The 32-bit library file libpam.so is not found on the system.

解決: 安裝這些套件
yum install pam-devel pam-devel.i686

./installFixPack

Enter full path name for the install directory -

------------------------------------------------
/opt/ibm/db2/V9.7 <== 輸入 DB2 主程式安裝目錄

新增 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

匯入 DB2 授權檔

注意: 匯入 license 必須使用 DB Instance 的帳號
解開檔案

su - db2inst
unzip  DB2_AESE_CPU_QS_Activation_97.zip
cd  aese_c/

匯入前的授權資訊

db2licm -l

Product name:                     "DB2 Advanced Enterprise Server Edition"
License type:                     "License not registered"
Expiry date:                      "License not registered"
Product identifier:               "db2aese"
Version information:              "9.7"

開始匯入

db2licm -a db2/license/db2aese_c.lic

LIC1402I License added successfully.

LIC1426I This product is now licensed for use as outlined in your License Agreement. USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V9.7/license/en_US.iso88591"

匯入後的授權資訊

db2licm -l

Product name:                     "DB2 Advanced Enterprise Server Edition"
License type:                     "CPU Option"
Expiry date:                      "Permanent"
Product identifier:               "db2aese"
Version information:              "9.7"
Enforcement policy:               "Soft Stop"