Docker DB2安装

docker network create --subnet 192.168.10.0/24 db2

docker run -dit --name mydb2_master --privileged --network db2 --ip 192.168.10.131 centos:7.6.1810
docker run -dit --name mydb2_client --privileged --network db2 --ip 192.168.10.132 centos:7.6.1810
docker run -dit --name mydb2_backup --privileged --network db2 --ip 192.168.10.133 centos:7.6.1810

################## root ##################

docker cp v10.5fp1_linuxx64_server.tar.gz mydb2_master:/          
docker cp v10.5fp1_linuxx64_server.tar.gz mydb2_client:/
docker cp v10.5fp1_linuxx64_server.tar.gz mydb2_backup:/
docker exec -it mydb2_master bash                                              
docker exec -it mydb2_client bash
docker exec -it mydb2_backup bash
yum install -y libaio file numactl-libs net-tools
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

-------------------------- 客户端和服务端均安装 ------------------------------------

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

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

groupadd -g 2000 db2iadm1
groupadd -g 2001 db2fadm1

useradd -m -g db2iadm1 -d /home/db2inst1 db2inst1
# useradd -m -g db2iadm1 -d /home/db2inst2 db2inst2
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

# 普通数据库创建
/opt/ibm/db2/V10.5/instance/db2icrt -a server -p 5000 -u db2fenc1 db2inst1
# /opt/ibm/db2/V10.5/instance/db2icrt -a server -p 6000 -u db2fenc1 db2inst2

-------------------------- 客户端和服务端均安装 end ------------------------------------

echo "DB2_db2inst1     50000/tcp" >> /etc/services

################## db2inst1 ##################
su - db2inst1
db2 get dbm cfg|grep SVCENAME
db2 update dbm cfg using SVCENAME DB2_db2inst1
db2 get dbm cfg|grep SVCENAME

--------------------------------------------------------------------------------------------------
-- 支持远程访问协议。
-- db2set 可用参数查看
-- db2set -lr | grep COMM

db2set db2comm=TCPIP

-- 如果没有设置该参数，则无法启动具体的端口。

--------------------------------------------------------------------------------------------------

db2start ; db2stop

################## 
# 创建数据库
db2start

create database sakila

# ================================================================================================#
# 启用归档                                                         
# +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ #
db2 connect to sakila

# 1，查询数据库的是否归档
db2 get db cfg | grep LOGARCHMETH
# 2，启用归档。
mkdir ~/arch1   ~/arch2
cd ~/arch1   ;   cd ~/arch2
pwd

db2 update db cfg for sakila using LOGARCHMETH1 disk:/home/db2inst1/arch1
db2 update db cfg for sakila using LOGARCHMETH2 disk:/home/db2inst1/arch2

# 3，修改日志组
db2 get db cfg | grep -E 'LOGPRIMARY|LOGSECOND'

[db2inst1@7670626e8986 ~]$ db2 get db cfg | grep -E 'LOGPRIMARY|LOGSECOND'
 Number of primary log files                (LOGPRIMARY) = 13
 Number of secondary log files               (LOGSECOND) = 12

db2 update db cfg for sakila using LOGPRIMARY 40
db2 update db cfg for sakila using LOGSECOND -1

[db2inst1@7670626