nanjing_2013
作者nanjing_20132012-07-10 10:16
系统架构师, 北京卓望

集群升级

字数 7818阅读 1241评论 0赞 0


从DB2 v98fp4升级安装DB2 v9

pureScale的新版本v98fp5发布了,为了确保客户能正确安装,我做了如下验证性测试,将用户原有的DB2v98fp4升级安装DB2 v98fp5,主要是TSAGPFS的升级安装。

 

测试环境,四台主机(LPAR),操作系统AIX,配置2CF3member

coralpib269.torolab.ibm.com

coralpib270.torolab.ibm.com

coralpib271.torolab.ibm.com

coralpib272.torolab.ibm.com

前提:

用户需要有主机root权限

 

1.确认 Tivoli® SA MP已有版本,和安装文件中的新版本

<image_path>/db2/<platform>/tsamp/db2cktsa -v install

 

root@coralpib269:/devinst/db2_v98fp5/aix64/s120605/ese_dsf/db2/aix/tsamp> db2cktsa -v install

3.2.6.2

 

root@coralpib269:/devinst/db2_v98fp5/aix64/s120605/ese_dsf/db2/aix/tsamp> db2cktsa -v media

3.2.7.1

 

2.确认GPFS™的安装情况

root@coralpib269:/devinst/db2_v98fp5/aix64/s120605/ese_dsf/db2/aix/gpfs> db2ckgpfs -v install

3.3.0.14

root@coralpib269:/devinst/db2_v98fp5/aix64/s120605/ese_dsf/db2/aix/gpfs> db2ckgpfs -v media

3.4.0.13

 

3. 在任意一台主机上运行下面的命令,停止DB2实例:

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

su - svtdbm

db2stop

exit

 

root@coralpib269:/devinst/db2_v98fp5/aix64/s120605/ese_dsf/db2/aix/gpfs> su - svtdbm

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

(svtdbm@coralpib269) /home/svtdbm

$ db2stop

06/18/2012 02:40:38     0   0   SQL1032N  No start database manager command was issued.

06/18/2012 02:40:38     1   0   SQL1032N  No start database manager command was issued.

06/18/2012 02:40:38     2   0   SQL1032N  No start database manager command was issued.

06/18/2012 02:40:39     3   0   SQL1032N  No start database manager command was issued.

SQL1032N  No start database manager command was issued.  SQLSTATE=57019

(svtdbm@coralpib269) /home/svtdbm

$ exit

 

4. 如果安装介质中SA MP的版本高于系统已安装的版本,DB2集群服务管理员必须把集群中所有的主机(中的SA MP资源)设为维护模式(maintenance mode)。在DB2 pureScale®的某一台主机运行如下的命令:

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

db2stop instance on hostname

DB2DIR/bin/db2cluster -cm -enter -maintenance -all

 

在各个node做一遍

db2stop instance on coralpib269.torolab.ibm.com

db2stop instance on coralpib270.torolab.ibm.com

db2stop instance on coralpib271.torolab.ibm.com

db2stop instance on coralpib272.torolab.ibm.com

 

只需做一遍

root@coralpib269:/opt/IBM/db2/V9.8_SB28978/bin> db2cluster -cm -enter -maintenance -all

Domain 'db2domain_20120420010253' has entered maintenance mode.

 

5. 如果安装介质中的GPFS版本高于系统已安装版本,则同样需要把GPFS的资源设为维护模式,在任一台主机运行如下命令:

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

DB2DIR/bin/db2cluster -cfs -enter -maintenance -all

 

只需做一遍

root@coralpib269:/opt/IBM/db2/V9.8_SB28978/bin> db2cluster -cfs -enter -maintenance -all

The shared file system has sucessfully entered maintenance mode.

 

 

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

6.在每一台主机上,在新的位置安装补丁包,例如:

installFixPack -L -b /opt/IBM/db2/V9.8 -p /opt/IBM/db2/V9.8fp1

 

cd /devinst/db2_v98fp5/aix64/s120605/ese_dsf

 

在各个node做一遍

installFixPack -L -b /opt/IBM/db2/V9.8_SB28978/ -p /opt/IBM/db2/V9.8fp5

 

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

7. 如果把SA MP资源设为维护模式,则必须将系统的维护模式去掉。在pureScale环境下的任一台主机上运行如下命令:

DB2DIR/bin/db2cluster -cm -exit -maintenance -all

 

cd /opt/IBM/db2/V9.8fp5/bin

 

root@coralpib269:/opt/IBM/db2/V9.8fp5/bin> db2cluster -cm -exit -maintenance -all

Host 'coralpib269' has exited maintenance mode. Domain 'db2domain_20120420010253' has been started.

 

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

8. 如果GPFS的资源被置为维护模式,则安装完成后需要将模式还原为正常状态。在运行下面的命令之前,需要保证SA MP的资源已经还原为正常模式,在集群中任一台主机,运行如下命令:

DB2DIR/bin/db2cluster -cfs -exit -maintenance -all

 

root@coralpib269:/opt/IBM/db2/V9.8fp5/bin> db2cluster -cfs -exit -maintenance -all

The shared file system successfully exited from maintenance mode.

 

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

9. 在每一台主机上,把实例更新到新的安装路径下:

DB2DIR/instance/db2iupdt svtdbm

cd /opt/IBM/db2/V9.8fp5/instance

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

root@coralpib269:/opt/IBM/db2/V9.8fp5/instance> db2iupdt svtdbm

DBI1446I  The db2iupdt command is running, please wait.

 

 

DB2 installation is being initialized.

 

 ####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

Total number of tasks to be performed: 7

Total estimated time for all tasks to be performed: 429 second(s)

 

Task #1 start

Description: Installing or updating DB2 HA scripts for Tivoli SA MP

Estimated time 40 second(s)

Task #1 end

 

Task #2 start

Description: Installing or updating DB2 Cluster Scripts for GPFS

Estimated time 40 second(s)

Task #2 end

 

Task #3 start

Description: Setting default global profile registry variables

Estimated time 1 second(s)

Task #3 end

 

Task #4 start

Description: Register NTP

Estimated time 40 second(s)

Task #4 end

 

Task #5 start

Description: Initializing instance list

Estimated time 5 second(s)

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

Task #5 end

 

Task #6 start

Description: Configuring DB2 instances

Estimated time 300 second(s)

####

#### /home/svtdbm/readmesvt.txt does not exist, use this id with caution!

####

Task #6 end

 

Task #7 start

Description: Updating global profile registry

Estimated time 3 second(s)

Task #7 end

 

The execution completed successfully.

 

For more information see the DB2 installation log at

"/tmp/db2iupdt.log.15204516".

DBI1070I  Program db2iupdt completed successfully.

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

10. DB2集群管理员必须提交对DB2集群的更改操作,并使他们生效。在任意一台主机,运行如下命令:

DB2DIR/bin/db2cluster -cfs -commit

 

cd /opt/IBM/db2/V9.8fp5/bin

 

root@coralpib269:/opt/IBM/db2/V9.8fp5/bin> db2cluster -cfs -commit

The shared file system cluster has been successfully updated to version '3.4.0.13'.

 

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

11. 升级SA MPpeer domain.

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

12. 如果主机处在维护模式下,DB2集群管理员应该在所有的主机上都启动实例。要想启动DB2实例,在所有主机上运行如下命令:

db2start instance on hostname

 

db2start instance on hostname

 

db2start instance on coralpib269.torolab.ibm.com

db2start instance on coralpib270.torolab.ibm.com

db2start instance on coralpib271.torolab.ibm.com

db2start instance on coralpib272.torolab.ibm.com

 

13. 启动DB2管理器(db2sysc

su - iname

db2start

exit

where iname represents the instance owner name.

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

  • 直播
    评论 0 · 赞 0
  • db2的代码页 codepage
    评论 0 · 赞 0
  • 总结记录一下
    评论 0 · 赞 0
  • 常用操作实践总结
    评论 0 · 赞 0
  • reorgchk统计信息使用的相关注意事项
    评论 0 · 赞 0
  • 相关问题

    X社区推广