从DB2 v98fp4升级安装DB2 v9
pureScale的新版本v98fp5发布了,为了确保客户能正确安装,我做了如下验证性测试,将用户原有的DB2从v98fp4升级安装DB2 v98fp5,主要是TSA和GPFS的升级安装。
测试环境,四台主机(LPAR),操作系统AIX,配置2个CF,3个member。
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 MP的peer 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 条评论