Installing Db2 on-prem on CentOS 7

下載下傳Db2 on-prem v11.5 安裝包

登入IBM官網，注冊IBMid并登入，選擇IBM Db2 Database。

選擇**IBM® Db2 11.5 for Linux® on AMD64 and Intel® EM64T systems (x64)**下載下傳後SCP上傳至伺服器。

解壓并安裝Db2 precheck依賴

解壓Db2安裝包

tar -zxvf v11.5_linuxx64_dec.tar.gz
           

安裝缺失的32位包

從RHEL 6開始，預設不安裝32位包，是以安裝之前需要修改配置，直接連32位包也一并安裝上。

echo 'multilib_policy=all' >> /etc/yum.conf 
yum install -y glibc* libstdc*
           

檢測環境是否符合Db2安裝要求

Db2提供了precheck腳本來檢查環境是否滿足安裝需求：

# 進入解壓後目錄
cd server_dec/

# 使用root使用者運作precheck指令
./db2prereqcheck
           

解決db2prereqcheck遇到的問題

由于Host環境不同，并非所有問題都會遇到。

缺少 libstdc++.so.5

Prereqcheck msg:

Validating "C++ Library version " ...
   Required minimum C++ library: "libstdc++.so.5"
DBT3510E  The db2prereqcheck utility was unable to find the following required library file: "libstdc++.so.5".
   ERROR : Requirement not matched.
           

Solution:

yum whatprovides libstdc++.so.5
yum install compat-libstdc++-33
           

缺少 libstdc++.so.6

Solution類似：

yum install libstdc++.so.6
           

缺少 libpam.so

Prereqcheck msg:

Validating "/lib/libpam.so*" ...
   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: "/lib/libpam.so*".
   WARNING : Requirement not matched.
           

Solution:

find / -name libpam.so*
/var/lib/docker/overlay2/7836bf92c4c811abdb81e08154b68f639d2819c030544a159c0455980ff5ba07/diff/usr/lib64/libpam.so.0
/var/lib/docker/overlay2/7836bf92c4c811abdb81e08154b68f639d2819c030544a159c0455980ff5ba07/diff/usr/lib64/libpam.so.0.83.1
/var/lib/docker/overlay2/af7cbccd17e9bff8c66117c4f22c8ab4dd38e7bb0cdf6b20a3a6ee4f71772e93/diff/usr/lib64/libpam.so.0
/var/lib/docker/overlay2/af7cbccd17e9bff8c66117c4f22c8ab4dd38e7bb0cdf6b20a3a6ee4f71772e93/diff/usr/lib64/libpam.so.0.83.1
/usr/lib64/libpam.so.0.83.1
/usr/lib64/libpam.so.0
           

很明顯，缺失32位包，手動安裝。

rpm -qf /usr/lib64/libpam.so.0
rpm -qf /usr/lib64/libpam.so.0.83.1
yum install -y pam*
           

需要關閉SELinux

修改配置檔案vi /etc/selinux/config，将SELinux置為disabled，并重新開機機器。

pureScale feature 問題（TBD）

Prereqcheck msg:

Requirement not matched for DB2 database "Server" with pureScale feature . Version: "9.8.0.2".
           

Solution:

不是所有問題yum都能解決的，選擇安裝pureScale feature的時候輸入“no”.

使用指令行安裝Db2

使用root使用者執行安裝指令

./db2_install
           

在install過程中，不安裝 pureScale feature

Specify one of the following keywords to install DB2 products.

  SERVER
  CONSV
  CLIENT
  RTCL

Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
SERVER
***********************************************************
Do you want to install the DB2 pureScale Feature? [yes/no]
no
           

配置并建立資料庫

建立組、使用者及密碼

groupadd -g 2000 db2iadm1
groupadd -g 2001 db2fadm1

useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1
useradd -m -g db2fadm1 -d /home/db2fenc1 db2fenc1

passwd db2inst1 # Wenyu0216
           

安裝License

cd /opt/ibm/db2/V11.5/adm/
chmod -R 775 *

./db2licm -a /home/server_dec/db2/license/db2ese_t.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/V11.5/license/en_US.iso88591"
           

建立執行個體

cd /opt/ibm/db2/V11.5/instance
chmod -R 775 *
 ./db2icrt -p 50000 -u db2fenc1 db2inst1
           

建立資料庫

# 切換到執行個體使用者
su - db2inst1

# 建立樣本資料庫
db2sampl

db2start
db2 connect to sample
db2 "select * from staff"
db2licm -l
           

Reference

• https://www.jianshu.com/p/44d0cb2e1818
• https://blog.csdn.net/fz_tym/article/details/76260576
• https://blog.51cto.com/feature09/2046506