下載Db2 on-prem v11.5 安裝包
登錄IBM官網(wǎng)，注冊IBMid并登錄稽煤，選擇IBM Db2 Database富玷。
Screen Shot 2020-02-21 at 23.08.08.png
選擇IBM? Db2 11.5 for Linux? on AMD64 and Intel? EM64T systems (x64)下載后SCP上傳至服務(wù)器。
解壓并安裝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*
檢測環(huán)境是否符合Db2安裝要求
Db2提供了precheck腳本來檢查環(huán)境是否滿足安裝需求：
# 進入解壓后目錄
cd server_dec/
# 使用root用戶運行precheck命令
./db2prereqcheck
解決db2prereqcheck遇到的問題
由于Host環(huán)境不同，并非所有問題都會遇到屈呕。
缺少 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*
需要關(guān)閉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用戶執(zhí)行安裝命令
./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
配置并創(chuàng)建數(shù)據(jù)庫
創(chuàng)建組涤躲、用戶及密碼
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"
創(chuàng)建實例
cd /opt/ibm/db2/V11.5/instance
chmod -R 775 *
./db2icrt -p 50000 -u db2fenc1 db2inst1
創(chuàng)建數(shù)據(jù)庫
# 切換到實例用戶
su - db2inst1
# 創(chuàng)建樣本數(shù)據(jù)庫
db2sampl
db2start
db2 connect to sample
db2 "select * from staff"
db2licm -l
Trouble Shooting
DB21019E An error occurred while accessing the directory
在Linux上剛安裝完Db2棺耍，創(chuàng)建數(shù)據(jù)庫遇到此錯誤。原因在于應(yīng)使用su -种樱，而不是su蒙袍。前者相當于注銷然后重新登錄新用戶，所以不會維持之前用戶的ENV變量嫩挤，而后者相當于簡單地同時登錄新用戶害幅。
