DB2 DPF安装

DB2 软件下载
https://repo.schoolsoft.com.tw/repo/db2/

yum install -y wget telnet libaio file numactl-libs net-tools ksh lsof
yum whatprovides libpam.so*
yum install -y pam-1.1.8-23.el7.i686

yum install -y procps*

#### CENTOS 不支持 DB2 pureScale Feature 
#### yum install -y libib*

### 设置DPF所需的系统资源
/sbin/sysctl -w kernel.sem="250        32000   32      1024"      
/sbin/sysctl -w kernel.msgmnb=16384                               
/sbin/sysctl -w kernel.msgmni=1024                                
/sbin/sysctl -w kernel.msgmax=8192                                
/sbin/sysctl -w kernel.shmmni=4096
/sbin/sysctl -w kernel.shmall=2097152
/sbin/sysctl -w kernel.shmmax=1073741824

cat >> /etc/services <<EOF
DB2c_db2inst1   60000/tcp
DB2_db2inst1    60001/tcp
DB2_db2inst1_END        60008/tcp
EOF

echo "127.0.0.1   `hostname`" >> /etc/hosts

# 如果当前的主机名没有添加到 /etc/hosts的话，建库的时候会出现 DBI1264E 错误。
# http://t.zoukankan.com/liujiacai-p-8467961.html

### 上传数据库文件并解压
mkdir /db2 
mv /v10.5fp1_linuxx64_server.tar.gz /db2
cd /db2
tar -zxf v10.5fp1_linuxx64_server.tar.gz

### 安装数据库
cd /db2/server
./db2_install

### 创建用户

groupadd -g 2000 db2iadm1   #用户都具有DBA权限
groupadd -g 2001 db2fadm1

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

echo "db2inst1:sakila#1234" | chpasswd
echo "db2fenc1:sakila#1234" | chpasswd

### 创建数据库实例

#### find / -name '*.lic'
/opt/ibm/db2/V10.5/adm/db2licm -a /db2/server/db2/linuxamd64/tsamp/license/sam32.lic

### db2icrt命令详解
# https://www.ibm.com/docs/en/db2/10.5?topic=commands-db2icrt-create-instance
/opt/ibm/db2/V10.5/instance/db2icrt -s ese -u db2fenc1 db2inst1

### 配置DPF数据库

su - db2inst1
ssh-keygen -t rsa
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/sqllib/db2profile  > ~/.profile

### DB2 配置
db2set DB2RSHCMD=ssh
db2set DB2COMM=TCPIP

### 如果ssh非22端口的话，需要配置如下文件
cat >> ~/.ssh/config <<EOF
Port 2025
EOF

https://blog.youkuaiyun.com/liujinwei2005/article/details/106770699
https://www.yisu.com/zixun/421082.html
http://www.javashuo.com/article/p-xzmwierl-ca.html

### 修改参数文件
# https://www.ibm.com/docs/en/db2/11.1?topic=file-format-db2-node-configuration
vi sqllib/db2nodes.cfg 
0 master 0
1 master 1
2 master 2
3 master 3

### 验证是否能正常连接

[db2inst1@master ~]$ db2_all date
 
Sun Jun 26 10:13:13 CST 2022
master: date completed ok
 
Sun Jun 26 10:13:14 CST 2022
master: date completed ok
 
Sun Jun 26 10:13:14 CST 2022
master: date completed ok
 
Sun Jun 26 10:13:15 CST 2022
master: date completed ok
[db2inst1@master ~]$ 

### 修改管理服务
db2 update dbm cfg using SVCENAME DB2c_db2inst1

### 启动数据库

[db2inst1@master ~]$ db2start
06/26/2022 10:10:16     1   0   SQL1063N  DB2START processing was successful.
06/26/2022 10:10:16     2   0   SQL1063N  DB2START processing was successful.
06/26/2022 10:10:17     0   0   SQL1063N  DB2START processing was successful.
06/26/2022 10:10:17     3   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

多服务器配置 

###https://blog.youkuaiyun.com/thirdbrother/article/details/17630813/

### 配置互信，其他 server 创建 db2inst1 用户

su - db2inst1

server1:
ssh-keygen -t rsa
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/sqllib/db2profile  > ~/.profile
ssh-copy-id -i ~/.ssh/id_rsa.pub db2node2

server2:
ssh-keygen -t rsa
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/sqllib/db2profile  > ~/.profile
ssh-copy-id -i ~/.ssh/id_rsa.pub db2node1

### 互信测