DB2 pureScale之部署

发布时间 2023-08-03 10:39:30作者: 雪竹子

环境介绍

VMware Workstation 15.5

Redhat Linux 6.5

DB2 10.5.0.10

功能 IP 主机名
存储 12.168.1.90 openfiler
cf 12.168.1.91 cf1
cf 12.168.1.92 cf2
member 12.168.1.93 member1
member 12.168.1.94 member2

 

准备环境

基础配置

提示:4个节点均操作。

 

关闭selinux

[root]# vi /etc/selinux/config
SELINUX=disabled

关闭iptables

[root]# service iptables stop
[root]# chkconfig iptables off

配置/etc/hosts

[root]# vi /etc/hosts
192.168.1.91 cf1
192.168.1.92 cf2
192.168.1.93 member1
192.168.1.94 member2

创建用户和组

[root]# groupadd -g 500 db2igrp
[root]# useradd -g db2igrp -u 500 db2inst1
[root]# echo "Gaoyu@029" | passwd --stdin db2inst1
[root]# groupadd -g 1001 db2fadm1
[root]# useradd -g db2fadm1 -u 1001 -m db2fenc1
[root]# echo "Gaoyu@029" | passwd --stdin db2fenc1

配置SSH互信

生成ssh公钥认证并将私钥拷贝到目标端主机

[root]# ssh-keygen
[root]# ssh-copy-id <hostname>
[db2inst1]# ssh-keygen
[db2inst1]# ssh-copy-id <hostname>

验证ssh互信

[root]# ssh cf1 hostname
[root]# ssh cf2 hostname
[root]# ssh member1 hostname
[root]# ssh member2 hostname
[db2inst1]# ssh cf1 hostname
[db2inst1]# ssh cf2 hostname
[db2inst1]# ssh member1 hostname
[db2inst1]# ssh member2 hostname

配置NTP

安装NTP

[root]# yum install -y ntp ntpdate

cf1节点作为NTP SERVER 端

[root]# service ntpd start

 其余节点(cf2,member1,member2)作为NTP CLIENT端

[root]# crontab -e
添加如下内容:
*/5 * * * * /usr/sbin/ntpdate 192.168.1.91

配置iscsi

提示:4个节点均操作。

 

openfiler共享一块/dev/sdb的盘为共享盘,请参考我另一篇博客:openfiler使用

 

安装iscsi

[root]# yum install iscsi-initiator-utils -y
[root]# chkconfig iscsid on

 识别存储映射

[root]# iscsiadm -m discovery -t sendtargets -p 192.168.1.90:3260

登录节点

[root]# iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.c8bba38a4419 -p 192.168.1.90:3260 -l

配置开机自动登录

[root]# iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.c8bba38a4419 -p 192.168.1.90:3260 --op update -n node.startup -v automatic

配置完后,本地可以看到/dev/sdb

[root]# ls /dev/sdb

 部署DB2 purescale

安装DB2 pureScale

提示:4个节点均操作。

 

安装DB2依赖包

[root]# yum install -y libstdc++.so.5 gcc-c++ kernel-devel sg3_utils sg_persist libstdc++.i686 pam.i686 ksh libstdc++ compat-libstdc++-33 pam

安装GPFS依赖包

[root]# yum groupinstall 'Development tools' -y

修改内核参数

[root]# echo "options mlx4_core log_mtts_per_seg=7" >> /etc/modprobe.d/modprobe.conf

将Intel TCO WatchDog Timer Driver模块列入黑名单

[root]# vi /etc/modprobe.d/blacklist.conf
新增如下内容:
blacklist iTCO_wdt
blacklist iTCO_vendor_support

配置环境变量

[root]# vi /etc/profile
export PATH=/root/bin:/usr/sbin/rsct/bin:/opt/ibm/db2/v10.5/bin:$PATH
export PATH=/usr/lpp/mmfs/bin:$PATH
export DB2USENONIB=TRUE
export DB2_CFS_GPFS_NO_REFRESH_DATA=true
export IBM_RDAC=NO
export CT_MANAGEMENT_SCOPE=2
[root]# source /etc/profile

安装DB2 pureScale

[root]# tar -zxvf v10.5fp10_linuxx64_server_t.tar.gz
[root]# cd server_t
[root@cf2 server_t]# ./db2_install 
DBI1324W  Support of the db2_install command is deprecated.


 
Default directory for installation of products - /opt/ibm/db2/V10.5

***********************************************************
Install into default directory (/opt/ibm/db2/V10.5) ? [yes/no] 
yes
 
 
Specify one of the following keywords to install DB2 products.

  SERVER 
  CONSV 
  EXP 
  CLIENT 
  RTCL 
 
Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
SERVER
***********************************************************
Do you want to install the DB2 pureScale Feature? [yes/no] 
yes
DB2 installation is being initialized.

 Total number of tasks to be performed: 53 
Total estimated time for all tasks to be performed: 2201 second(s) 

Task #1 start
Description: Checking license agreement acceptance 
Estimated time 1 second(s) 
Task #1 end 

Task #2 start
Description: Base Client Support for installation with root privileges 
Estimated time 3 second(s) 
Task #2 end 

Task #3 start
Description: Product Messages - English 
Estimated time 14 second(s) 
Task #3 end 

Task #4 start
Description: Base client support 
Estimated time 319 second(s) 
Task #4 end 

Task #5 start
Description: Java Runtime Support 
Estimated time 169 second(s) 
Task #5 end 

Task #6 start
Description: Java Help (HTML) - English 
Estimated time 7 second(s) 
Task #6 end 

Task #7 start
Description: Base server support for installation with root privileges 
Estimated time 7 second(s) 
Task #7 end 

Task #8 start
Description: Global Secure ToolKit 
Estimated time 53 second(s) 
Task #8 end 

Task #9 start
Description: Java support 
Estimated time 13 second(s) 
Task #9 end 

Task #10 start
Description: SQL procedures 
Estimated time 3 second(s) 
Task #10 end 

Task #11 start
Description: ICU Utilities 
Estimated time 35 second(s) 
Task #11 end 

Task #12 start
Description: Java Common files 
Estimated time 18 second(s) 
Task #12 end 

Task #13 start
Description: Base server support 
Estimated time 500 second(s) 
Task #13 end 

Task #14 start
Description: Control Center Help (HTML) - English 
Estimated time 13 second(s) 
Task #14 end 

Task #15 start
Description: Connect support 
Estimated time 3 second(s) 
Task #15 end 

Task #16 start
Description: Relational wrappers common 
Estimated time 3 second(s) 
Task #16 end 

Task #17 start
Description: DB2 data source support 
Estimated time 6 second(s) 
Task #17 end 

Task #18 start
Description: Spatial Extender server support 
Estimated time 18 second(s) 
Task #18 end 

Task #19 start
Description: IBM Software Development Kit (SDK) for Java(TM) 
Estimated time 50 second(s) 
Task #19 end 

Task #20 start
Description: DB2 LDAP support 
Estimated time 4 second(s) 
Task #20 end 

Task #21 start
Description: DB2 Instance Setup wizard 
Estimated time 20 second(s) 
Task #21 end 

Task #22 start
Description: Integrated Flash Copy Support 
Estimated time 3 second(s) 
Task #22 end 

Task #23 start
Description: General Parallel File System (GPFS) 
Estimated time 100 second(s) 
Task #23 end 

Task #24 start
Description: Spatial Extender client 
Estimated time 3 second(s) 
Task #24 end 

Task #25 start
Description: Communication support - TCP/IP 
Estimated time 3 second(s) 
Task #25 end 

Task #26 start
Description: Tivoli SA MP 
Estimated time 300 second(s) 
Task #26 end 

Task #27 start
Description: Base application development tools 
Estimated time 34 second(s) 
Task #27 end 

Task #28 start
Description: DB2 Update Service 
Estimated time 4 second(s) 
Task #28 end 

Task #29 start
Description: Parallel Extension 
Estimated time 3 second(s) 
Task #29 end 

Task #30 start
Description: EnterpriseDB code 
Estimated time 4 second(s) 
Task #30 end 

Task #31 start
Description: Replication tools 
Estimated time 61 second(s) 
Task #31 end 

Task #32 start
Description: Cluster Caching Facility 
Estimated time 66 second(s) 
Task #32 end 

Task #33 start
Description: Sample database source 
Estimated time 4 second(s) 
Task #33 end 

Task #34 start
Description: itlm 
Estimated time 3 second(s) 
Task #34 end 

Task #35 start
Description: DB2 Text Search 
Estimated time 123 second(s) 
Task #35 end 

Task #36 start
Description: Command Line Processor Plus 
Estimated time 6 second(s) 
Task #36 end 

Task #37 start
Description: Informix data source support 
Estimated time 4 second(s) 
Task #37 end 

Task #38 start
Description: Oracle data source support 
Estimated time 4 second(s) 
Task #38 end 

Task #39 start
Description: IBM DB2 pureScale Feature 
Estimated time 3 second(s) 
Task #39 end 

Task #40 start
Description: First Steps 
Estimated time 3 second(s) 
Task #40 end 

Task #41 start
Description: Product Signature for DB2 Server Edition 
Estimated time 7 second(s) 
Task #41 end 

Task #42 start
Description: Guardium Installation Manager Client 
Estimated time 36 second(s) 
Task #42 end 

Task #43 start
Description: Setting DB2 library path 
Estimated time 180 second(s) 
Task #43 end 

Task #44 start
Description: Copying DB2 image 
Estimated time 600 second(s) 
Task #44 end 

Task #45 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) 
Estimated time 40 second(s) 
Task #45 end 

Task #46 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS) 
Estimated time 40 second(s) 
Task #46 end 

Task #47 start
Description: Installing or updating DB2 SSH Utilities 
Estimated time 5 second(s) 
Task #47 end 

Task #48 start
Description: Compiling GPL 
Estimated time 30 second(s) 
Task #48 end 

Task #49 start
Description: Executing control tasks 
Estimated time 20 second(s) 
Task #49 end 

Task #50 start
Description: Updating global registry 
Estimated time 20 second(s) 
Task #50 end 

Task #51 start
Description: Updating the db2ls and db2greg link 
Estimated time 1 second(s) 
Task #51 end 

Task #52 start
Description: Registering DB2 licenses 
Estimated time 5 second(s) 
Task #52 end 

Task #53 start
Description: Setting default global profile registry variables 
Estimated time 1 second(s) 
Task #53 end 

Task #54 start
Description: Initializing instance list 
Estimated time 5 second(s) 
Task #54 end 

Task #55 start
Description: Registering DB2 Update Service 
Estimated time 30 second(s) 
Task #55 end 

Task #56 start
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #56 end 

The execution completed successfully.

配置GPFS

方法1:db2cluster_prepare

任一节点执行,我选择在cf1节点操作。

 

配置GPFS文件系统

[root@cf1 ~]# db2cluster_prepare -instance_shared_dev /dev/sdb
DBI1446I  The db2cluster_prepare command is running.


DB2 installation is being initialized.

 Total number of tasks to be performed: 1 
Total estimated time for all tasks to be performed: 60 second(s) 

Task #1 start
Description: Creating IBM General Parallel File System (GPFS) Cluster and Filesystem 
Estimated time 60 second(s) 
Task #1 end 

The execution completed successfully.

For more information see the DB2 installation log at
"/tmp/db2cluster_prepare.log".
DBI1070I  Program db2cluster_prepare completed successfully.

查看文件系统挂载情况,我这边新挂载/db2sd_20220916045841目录

[root@cf1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_redhat-lv_root
                       50G   11G   37G  23% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sda1             485M   42M  418M  10% /boot
/dev/mapper/vg_redhat-lv_home
                       45G  180M   43G   1% /home
/dev/sr0              3.6G  3.6G     0 100% /mnt
/dev/db2fs1            95G  1.2G   94G   2% /db2sd_20220916045841

查看集群域信息,生成一个名为:db2cluster_20220916045803.cf1的域

[root@cf1 ~]# db2cluster -cfs -list -domain
Domain Name: db2cluster_20220916045803.cf1

方法2:手动配置GPFS

创建集群域

[root@cf1 ~]# db2cluster -cfs -create -domain mydomain -host cf1
The shared file system cluster has been successfully created.

分别添加cf2,member1,member2到集群域中

[root@cf1 ~]# db2cluster -cfs -add -host cf2
Host 'cf2' has been successfully added to the shared file system cluster.

[root@cf1 ~]# db2cluster -cfs -add -host member1
Host 'member1' has been successfully added to the shared file system cluster.

[root@cf1 ~]# db2cluster -cfs -add -host member2
Host 'member2' has been successfully added to the shared file system cluster.

添加cf2,member1,member2到集群许可协议中

#方式1:
[root@cf1 ~]# mmchlicense server --accept -N cf1,cf2,member1,member2

The following nodes will be designated as possessing server licenses:
	cf1
	cf2
	member1
	member2
mmchlicense: Command successfully completed
mmchlicense: Propagating the cluster configuration data to all
  affected nodes.  This is an asynchronous process.

#方式2:
[root@cf1 ~]# db2cluster -cfs -add -license
The license for the shared file system cluster has been successfully added.

配置创建NSD的文件

[root@cf1 ~]# vi /tmp/newNSD 
%nsd:
  device=/dev/sdb
  nsd=nsd2
  usage=dataAndMetadata

执行newNSD创建NSD

[root@cf1 ~]# mmcrnsd -F /tmp/newNSD -v no
mmcrnsd: Processing disk sdb
mmcrnsd: Propagating the cluster configuration data to all
  affected nodes.  This is an asynchronous process.

[root@cf1 ~]# mmlsnsd

 File system   Disk name    NSD servers                                    
---------------------------------------------------------------------------
 (free disk)   nsd2         (directly attached)

启动GPFS

[root@cf1]# mmstartup -a
Thu Sep 15 22:30:42 EDT 2022: mmstartup: Starting GPFS ...

查看GPFS状态

[root@cf1 ~]# mmgetstate -a

 Node number  Node name        GPFS state 
------------------------------------------
       1      cf1              arbitrating
       2      cf2              arbitrating
       3      member1          arbitrating
       4      member2          arbitrating

[root@cf1 ~]# mmgetstate -a

 Node number  Node name        GPFS state 
------------------------------------------
       1      cf1              active
       2      cf2              active
       3      member1          active
       4      member2          active

创建CFS文件系统,nsd2是上面创建的NSD,/db2nsd是要创建的磁盘

[root@cf1 ~]# mmcrfs -T /db2nsd db2nsd nsd2

The following disks of db2nsd will be formatted on node cf1:
    nsd2: size 118048 MB
Formatting file system ...
Disks up to size 1.0 TB can be added to storage pool system.
Creating Inode File
Creating Allocation Maps
Creating Log Files
Clearing Inode Allocation Map
Clearing Block Allocation Map
Formatting Allocation Map for storage pool system
Completed creation of file system /dev/db2nsd.
mmcrfs: Propagating the cluster configuration data to all
  affected nodes.  This is an asynchronous process.

 挂载NSD

[root@cf1 ~]# mmmount all -a
Thu Sep 15 22:43:51 EDT 2022: mmmount: Mounting file systems ...

[root@cf1 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_redhat-lv_root
                       50G   11G   37G  22% /
tmpfs                 1.9G     0  1.9G   0% /dev/shm
/dev/sda1             485M   42M  418M  10% /boot
/dev/mapper/vg_redhat-lv_home
                       45G  180M   43G   1% /home
/dev/sr0              3.6G  3.6G     0 100% /mnt
/dev/db2nsd           116G  687M  115G   1% /db2nsd

 创建实例并启动集群

cf1节点创建实例

[root@cf1 ~]# /opt/ibm/db2/V10.5/instance/db2icrt -cf cf1 -cfnet cf1 -m member1 -mnet member1 -instance_shared_dir /db2sd_20220916045841 -tbdev 192.168.1.1 -u db2fenc1 db2inst1
DBI1446I  The db2icrt command is running.


DB2 installation is being initialized.

 Total number of tasks to be performed: 10 
Total estimated time for all tasks to be performed: 1074 second(s) 

Task #1 start
Description: Installing DB2 files on remote hosts 
Estimated time 600 second(s) 
Task #1 end 

Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) 
Estimated time 40 second(s) 
Task #2 end 

Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS) 
Estimated time 40 second(s) 
Task #3 end 

Task #4 start
Description: Registering licenses on remote hosts 
Estimated time 40 second(s) 
Task #4 end 

Task #5 start
Description: Setting default global profile registry variables 
Estimated time 1 second(s) 
Task #5 end 

Task #6 start
Description: Register NTP 
Estimated time 40 second(s) 
Task #6 end 

Task #7 start
Description: Initializing instance list 
Estimated time 5 second(s) 
Task #7 end 

Task #8 start
Description: Initiating the remote host list 
Estimated time 5 second(s) 
Task #8 end 

Task #9 start
Description: Configuring DB2 instances 
Estimated time 300 second(s) 
Task #9 end 

Task #10 start
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #10 end 

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2icrt.log.100122".
DBI1070I  Program db2icrt completed successfully.

查看GPFS集群信息

[root@cf1 ~]# mmlscluster 

GPFS cluster information
========================
  GPFS cluster name:         db2cluster_20220916045803.cf1
  GPFS cluster id:           17390685069817166492
  GPFS UID domain:           db2cluster_20220916045803.cf1
  Remote shell command:      /var/db2/db2ssh/db2locssh
  Remote file copy command:  /var/db2/db2ssh/db2scp
  Repository type:           server-based

GPFS cluster configuration servers:
-----------------------------------
  Primary server:    cf1
  Secondary server:  member1

 Node  Daemon node name  IP address    Admin node name  Designation
--------------------------------------------------------------------
   1   cf1               192.168.1.91  cf1              quorum-manager
   2   member1           192.168.1.93  member1          quorum-manager

配置允许普通网络启动实例(cf1,member1节点均执行)

[db2inst1]# db2set DB2_SD_ALLOW_SLOW_NETWORK=on
[db2inst1]# db2set DB2_CA_TRANSPORT_METHOD=SOCKETS

启动实例

[db2inst1@cf1 ~]$ db2start
SQL8007W  There are "90" day(s) left in the evaluation period for the product 
"DB2 Advanced Enterprise Server Edition". For evaluation license terms and 
conditions, refer to the License Agreement document located in the license 
directory in the installation path of this product. If you have licensed this 
product, ensure the license key is properly registered. You can register the 
license by using the db2licm command line utility. The license key can be 
obtained from your licensed product CD.
09/16/2022 06:08:05     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

查看CF和MEMBER信息

[root@cf1 ~]# db2instance -instance db2inst1 -list
ID	  TYPE	           STATE		HOME_HOST		CURRENT_HOST		ALERT	PARTITION_NUMBER	LOGICAL_PORT	NETNAME
--	  ----	           -----		---------		------------		-----	----------------	------------	-------
0	MEMBER	         STARTED		  member1		     member1		   NO	               0	           0	member1
128	CF	         	 PRIMARY		      cf1		         cf1		   NO	               -	           0	    cf1

HOSTNAME		   STATE		INSTANCE_STOPPED	ALERT
--------		   -----		----------------	-----
     cf1		  ACTIVE		              NO	   NO
 member1		  ACTIVE		              NO	   NO

新增MEMBER节点

添加MEMBER2到集群

[root@cf1 ~]# db2iupdt -d -add -m member2 -mnet member2 db2inst1
DBI1446I  The db2iupdt command is running.


DB2 installation is being initialized.

 Total number of tasks to be performed: 10 
Total estimated time for all tasks to be performed: 1074 second(s) 

Task #1 start
Description: Installing DB2 files on remote hosts 
Estimated time 600 second(s) 
Task #1 end 

Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) 
Estimated time 40 second(s) 
Task #2 end 

Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS) 
Estimated time 40 second(s) 
Task #3 end 

Task #4 start
Description: Registering licenses on remote hosts 
Estimated time 40 second(s) 
Task #4 end 

Task #5 start
Description: Setting default global profile registry variables 
Estimated time 1 second(s) 
Task #5 end 

Task #6 start
Description: Register NTP 
Estimated time 40 second(s) 
Task #6 end 

Task #7 start
Description: Initializing instance list 
Estimated time 5 second(s) 
Task #7 end 

Task #8 start
Description: Initiating the remote host list 
Estimated time 5 second(s) 
Task #8 end 

Task #9 start
Description: Configuring DB2 instances 
Estimated time 300 second(s) 
Task #9 end 

Task #10 start
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #10 end 

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2iupdt.log.84451".
DBI1070I  Program db2iupdt completed successfully.

查看CF和MEMBER信息,查看member2的ID

[root@cf1 ~]# db2instance -instance db2inst1 -list
ID	  TYPE	           STATE		HOME_HOST		CURRENT_HOST		ALERT	PARTITION_NUMBER	LOGICAL_PORT	NETNAME
--	  ----	           -----		---------		------------		-----	----------------	------------	-------
0	MEMBER	         STARTED		  member1		     member1		   NO	               0	           0	member1
1	MEMBER	         STOPPED		  member2		     member2		   NO	               0	           0	member2
128	CF	         	 PRIMARY		      cf1		         cf1		   NO	               -	           0	    cf1

HOSTNAME		   STATE		INSTANCE_STOPPED	ALERT
--------		   -----		----------------	-----
 member2		  ACTIVE		              NO	   NO
     cf1		  ACTIVE		              NO	   NO
 member1		  ACTIVE		              NO	   NO

启动member2

[db2inst1@cf1 ~]$ db2start member 1
SQL8007W  There are "88" day(s) left in the evaluation period for the product 
"DB2 Advanced Enterprise Server Edition". For evaluation license terms and 
conditions, refer to the License Agreement document located in the license 
directory in the installation path of this product. If you have licensed this 
product, ensure the license key is properly registered. You can register the 
license by using the db2licm command line utility. The license key can be 
obtained from your licensed product CD.
09/18/2022 08:49:38     1   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

再次查看CF和MEMBER信息

[db2inst1@cf1 ~]# db2instance db2inst1 -list
ID	  TYPE	           STATE		HOME_HOST		CURRENT_HOST		ALERT	PARTITION_NUMBER	LOGICAL_PORT	NETNAME
--	  ----	           -----		---------		------------		-----	----------------	------------	-------
0	MEMBER	         STARTED		  member1		     member1		   NO	               0	           0	member1
1	MEMBER	         STARTED		  member2		     member2		   NO	               0	           0	member2
128	CF	         	 PRIMARY		      cf1		         cf1		   NO	               -	           0	    cf1

HOSTNAME		   STATE		INSTANCE_STOPPED	ALERT
--------		   -----		----------------	-----
 member2		  ACTIVE		              NO	   NO
     cf1		  ACTIVE		              NO	   NO
 member1		  ACTIVE		              NO	   NO

新增CF节点

在不关闭集群实例的情况下添加CF节点失败

[root@cf1]# db2iupdt -d -add -cf cf2 -cfnet cf2 db2inst1
DBI1446I  The db2iupdt command is running.


DB2 installation is being initialized.

 The DB2 installer detects that one or more DB2 instances "db2inst1" are still
active. Stop the active instances and rerun the command again.

A major error occurred during the execution that caused this program to
terminate prematurely. If the problem persists, contact your technical service
representative.

For more information see the DB2 installation log at "/tmp/db2iupdt.log.39734".
DBI1264E  This program failed. Errors encountered during execution were
      written to the installation log file. Program name:
      db2iupdt. Log file name: /tmp/db2iupdt.log.39734.

Explanation: 

This message is returned when some processes and operations have failed.
Detailed information about the error was written to the log file.

User response: 

Contact IBM support to get assistance in resolving this issue. Keep the
log file intact as this file is an important reference for IBM support.


      Related information:
      Contacting IBM Software Support

关闭集群实例

[db2inst1@cf1]# db2stop

添加cf2到集群

[root@cf1 ~]# db2iupdt -d -add -cf cf2 -cfnet cf2 db2inst1
DBI1446I  The db2iupdt command is running.


DB2 installation is being initialized.

 Total number of tasks to be performed: 10 
Total estimated time for all tasks to be performed: 1074 second(s) 

Task #1 start
Description: Installing DB2 files on remote hosts 
Estimated time 600 second(s) 
Task #1 end 

Task #2 start
Description: Installing or updating DB2 HA scripts for IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) 
Estimated time 40 second(s) 
Task #2 end 

Task #3 start
Description: Installing or updating DB2 Cluster Scripts for IBM General Parallel File System (GPFS) 
Estimated time 40 second(s) 
Task #3 end 

Task #4 start
Description: Registering licenses on remote hosts 
Estimated time 40 second(s) 
Task #4 end 

Task #5 start
Description: Setting default global profile registry variables 
Estimated time 1 second(s) 
Task #5 end 

Task #6 start
Description: Register NTP 
Estimated time 40 second(s) 
Task #6 end 

Task #7 start
Description: Initializing instance list 
Estimated time 5 second(s) 
Task #7 end 

Task #8 start
Description: Initiating the remote host list 
Estimated time 5 second(s) 
Task #8 end 

Task #9 start
Description: Configuring DB2 instances 
Estimated time 300 second(s) 
Task #9 end 

Task #10 start
Description: Updating global profile registry 
Estimated time 3 second(s) 
Task #10 end 

The execution completed successfully.

For more information see the DB2 installation log at "/tmp/db2iupdt.log.85153".
DBI1070I  Program db2iupdt completed successfully.

查看CF和MEMBER信息

[root@cf1 ~]# db2instance -instance db2inst1 -list
ID	  TYPE	           STATE		HOME_HOST		CURRENT_HOST		ALERT	PARTITION_NUMBER	LOGICAL_PORT	NETNAME
--	  ----	           -----		---------		------------		-----	----------------	------------	-------
0	MEMBER	         STOPPED		  member1		     member1		   NO	               0	           0	member1
1	MEMBER	         STOPPED		  member2		     member2		   NO	               0	           0	member2
128	CF	         STOPPED		      cf1		         cf1		   NO	               -	           0	    cf1
129	CF	         STOPPED		      cf2		         cf2		   NO	               -	           0	    cf2

HOSTNAME		   STATE		INSTANCE_STOPPED	ALERT
--------		   -----		----------------	-----
     cf2		  ACTIVE		              NO	   NO
     cf1		  ACTIVE		              NO	   NO
 member2		  ACTIVE		              NO	   NO
 member1		  ACTIVE		              NO	   NO

启动集群实例

[db2inst1@cf1 ~]$ db2start
SQL8007W  There are "88" day(s) left in the evaluation period for the product 
"DB2 Advanced Enterprise Server Edition". For evaluation license terms and 
conditions, refer to the License Agreement document located in the license 
directory in the installation path of this product. If you have licensed this 
product, ensure the license key is properly registered. You can register the 
license by using the db2licm command line utility. The license key can be 
obtained from your licensed product CD.
09/18/2022 09:38:16     1   0   SQL1063N  DB2START processing was successful.
09/18/2022 09:38:17     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

再次查看CF和MEMBER信息

[db2inst1@cf1 ~]$ db2instance -list
ID	  TYPE	           STATE		HOME_HOST		CURRENT_HOST		ALERT	PARTITION_NUMBER	LOGICAL_PORT	NETNAME
--	  ----	           -----		---------		------------		-----	----------------	------------	-------
0	MEMBER	         STARTED		  member1		     member1		   NO	               0	           0	member1
1	MEMBER	         STARTED		  member2		     member2		   NO	               0	           0	member2
128	CF	         PRIMARY		      cf1		         cf1		   NO	               -	           0	    cf1
129	CF	         CATCHUP		      cf2		         cf2		   NO	               -	           0	    cf2

HOSTNAME		   STATE		INSTANCE_STOPPED	ALERT
--------		   -----		----------------	-----
     cf2		  ACTIVE		              NO	   NO
     cf1		  ACTIVE		              NO	   NO
 member2		  ACTIVE		              NO	   NO
 member1		  ACTIVE		              NO	   NO

 

参考:

https://www.ibm.com/docs/zh/db2/10.5?topic=environment-installing-db2-purescale-linux

https://www.talkwithtrend.com/Article/191151