DB2 9.5.0.0升级至9.5.0.9(小版本升级)

联系:手机(+86 13429648788) QQ(107644445)QQ咨询惜分飞

标题:DB2 9.5.0.0升级至9.5.0.9(小版本升级)

作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

0.升级前DB2版本

[db2inst1@xifenfei ~]$ db2level
DB21085I  Instance "db2inst1" uses "32" bits and DB2 code release "SQL09050" 
with level identifier "03010107".
Informational tokens are "DB2 v9.5.0.0", "s071001", "LINUXIA3295", and Fix Pack 
"0".
Product is installed at "/opt/db2/V9.5".

1.查看哪些实例

[root@xifenfei ~]# su - db2inst1
[db2inst1@xifenfei ~]$ db2ilist
db2inst1
db2inst2

2.关闭数据库

[db2inst1@xifenfei ~]$ db2 force applications all
SQL1032N  No start database manager command was issued.  SQLSTATE=57019
[db2inst1@xifenfei ~]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
[db2inst1@xifenfei ~]$ db2stop
04/05/2012 09:17:13     0   0   SQL1032N  No start database manager command was issued.
SQL1064N  DB2STOP processing was successful.
[db2inst1@xifenfei ~]$ su - db2inst2
Password: 
[db2inst2@xifenfei ~]$ db2 force applications all
DB20000I  The FORCE APPLICATION command completed successfully.
DB21024I  This command is asynchronous and may not be effective immediately.
[db2inst2@xifenfei ~]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
[db2inst2@xifenfei ~]$ db2stop
04/05/2012 09:20:00     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.

3.关闭管理服务器(DAS)

[root@xifenfei ~]# su - dasusr1
[dasusr1@xifenfei ~]$ db2admin stop
SQL4407W  The DB2 Administration Server was stopped successfully.

4.卸装未使用的共享库

[db2inst1@xifenfei ~]$  $HOME/sqllib/bin/ipclean
/home/db2inst1/sqllib/bin/ipclean: Removing DB2 engine and client's IPC resources for db2inst1.
[db2inst2@xifenfei ~]$  $HOME/sqllib/bin/ipclean
/home/db2inst2/sqllib/bin/ipclean: Removing DB2 engine and client's IPC resources for db2inst2.

5.升级数据库软件和组件

[root@xifenfei ~]# cd server/
[root@xifenfei server]# ./installFixPack -b /opt/db2/V9.5/
DBI1017I  installFixPack is updating the DB2 product(s) installed in
      location /opt/db2/V9.5/.


DB2 installation is being initialized.

 Total number of tasks to be performed: 36 
Total estimated time for all tasks to be performed: 1165 

Task #1 start
Description: Stopping DB2 Fault Monitor 
Estimated time 10 second(s) 
Task #1 end 

Task #2 start
Description: Preparing the system 
Estimated time 120 second(s) 
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/installFixPack.log.9890".

--发生错误,通过日志文件寻找错误
[root@xifenfei server]# more /tmp/installFixPack.log.9890
Stopping DB2 Fault Monitor :.......Success 
ERROR: The installFixPack command detected some DB2 libraries are still loaded
in memory and some applications might still be running in the current
installation copy.  All applications must be stopped. See the fix pack readme
for pre-installation instructions, and re-run the installFixPack command.
Alternatively, to override automatic checking, you can re-issue the
installFixPack command with the '-f db2lib' parameter. Note: If you re-issue
the installFixPack command with the '-f db2lib' parameter, after the DB2
instances are updated, some applications might not work properly and might need
to be restarted to function properly against the updated DB2 instance.

Preparing the system :.......Failure 
--发现是some DB2 libraries are still loaded,导致升级不能进行

--使用-f db2lib参数
[root@xifenfei server]# ./installFixPack -b /opt/db2/V9.5/ -f db2lib
DBI1017I  installFixPack is updating the DB2 product(s) installed in
      location /opt/db2/V9.5/.


DB2 installation is being initialized.

 Total number of tasks to be performed: 36 
Total estimated time for all tasks to be performed: 1165 

Task #1 start
Description: Stopping DB2 Fault Monitor 
Estimated time 10 second(s) 
Task #1 end 

Task #2 start
Description: Preparing the system 
Estimated time 120 second(s) 
Task #2 end 

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

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

Task #5 start
Description: Base client support 
Estimated time 86 second(s) 
Task #5 end 

Task #6 start
Description: The DB2 required component. 
Estimated time 78 second(s) 
Task #6 end 

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

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

Task #9 start
Description: Global Secure ToolKit 
Estimated time 14 second(s) 
Task #9 end 

Task #10 start
Description: Java support 
Estimated time 11 second(s) 
Task #10 end 

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

Task #12 start
Description: ICU Utilities 
Estimated time 54 second(s) 
Task #12 end 

Task #13 start
Description: Java Common files 
Estimated time 20 second(s) 
Task #13 end 

Task #14 start
Description: Base server support 
Estimated time 197 second(s) 
Task #14 end 

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

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

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

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

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

Task #20 start
Description: Replication tools 
Estimated time 16 second(s) 
Task #20 end 

Task #21 start
Description: Control Center 
Estimated time 40 second(s) 
Task #21 end 

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

Task #23 start
Description: DB2 LDAP support 
Estimated time 3 second(s) 
Task #23 end 

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

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

Task #26 start
Description: Product Signature for DB2 Enterprise Server Edition 
Estimated time 5 second(s) 
Task #26 end 

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

Task #28 start
Description: Installing or updating SA MP Base Component 
Estimated time 40 second(s) 
Task #28 end 

Task #29 start
Description: Installing or updating DB2 HA scripts for SA MP Base Component 
Estimated time 40 second(s) 
Task #29 end 

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

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

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

Task #33 start
Description: Starting DB2 Fault Monitor 
Estimated time 10 second(s) 
Task #33 end 

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

Task #35 start
Description: Updating the DB2 Administration Server 
Estimated time 40 second(s) 
Task #35 end 

Task #36 start
Description: Updating existing DB2 instances 
Estimated time 60 second(s) 
Task #36 end 

A minor error occurred during the execution.

For more information see the DB2 installation log at
"/tmp/installFixPack.log.15581".
--提示升级有错误发生

--检查日志文件
[root@xifenfei server]# more /tmp/installFixPack.log.15581
TSAMP_VERSION=3.2.1.2
 DBI1130E  The SA MP Base Component could not be installed or updated
      because system prerequisites were not met. See the log file
      /tmp/prereqSAM.log.17293 for details.
--发现是samp组件没有安装导致该错误,忽略

6.升级数据库

[root@xifenfei server]# su - db2inst1
[db2inst1@xifenfei ~]$ db2level  -a
DB21085I  Instance "db2inst1" uses "32" bits and DB2 code release "SQL09059" 
with level identifier "060A0107".
Informational tokens are "DB2 v9.5.0.9", "s120228", "IP23310", and Fix Pack 
"9".
Product is installed at "/opt/db2/V9.5".
[db2inst1@xifenfei ~]$ db2ilist 
db2inst1
db2inst2
[db2inst1@xifenfei ~]$ db2start
04/05/2012 09:39:45     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2inst1@xifenfei ~]$ db2 list database DIRECTORY

 System Database Directory

 Number of entries in the directory = 3

Database 1 entry:

 Database alias                       = XFF
 Database name                        = XIFENFEI
 Local database directory             = /home/db2inst1
 Database release level               = c.00
 Comment                              = XIFENFEI TEST DATABASE
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

Database 2 entry:

 Database alias                       = TOOLSDB
 Database name                        = TOOLSDB
 Local database directory             = /home/db2inst1
 Database release level               = c.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

Database 3 entry:

 Database alias                       = SAMPLE
 Database name                        = SAMPLE
 Local database directory             = /home/db2inst1
 Database release level               = c.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

[db2inst1@xifenfei ~]$ db2updv95 -d toolsdb


_________________________________________________________________________     
                                                                              
                    _____   DB2 Service Tools   _____                         
                                                                              
                            I      B      M                                   
                                                                              
                               db2updv95                                      
                                                                              
   This tool is a service utility designed to update a DB2 Version 9.5        
   database to the current fixpak level.                                      
                                                                              
_________________________________________________________________________     


DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool

db2updv95 completed successfully for database 'toolsdb'. 
[db2inst1@xifenfei ~]$ db2updv95 -d SAMPLE


_________________________________________________________________________     
                                                                              
                    _____   DB2 Service Tools   _____                         
                                                                              
                            I      B      M                                   
                                                                              
                               db2updv95                                      
                                                                              
   This tool is a service utility designed to update a DB2 Version 9.5        
   database to the current fixpak level.                                      
                                                                              
_________________________________________________________________________     


DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool

db2updv95 completed successfully for database 'SAMPLE'.

--指定数据库别名 
[db2inst1@xifenfei ~]$ db2updv95 -d Xff


_________________________________________________________________________     
                                                                              
                    _____   DB2 Service Tools   _____                         
                                                                              
                            I      B      M                                   
                                                                              
                               db2updv95                                      
                                                                              
   This tool is a service utility designed to update a DB2 Version 9.5        
   database to the current fixpak level.                                      
                                                                              
_________________________________________________________________________     


DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool

db2updv95 completed successfully for database 'Xff'. 

[db2inst1@xifenfei ~]$ su - db2inst2
Password: 
[db2inst2@xifenfei ~]$ db2 list database DIRECTORY

 System Database Directory

 Number of entries in the directory = 1

Database 1 entry:

 Database alias                       = XIFENFEI
 Database name                        = XIFENFEI
 Local database directory             = /home/db2inst2/xifenfei
 Database release level               = c.00
 Comment                              =
 Directory entry type                 = Indirect
 Catalog database partition number    = 0
 Alternate server hostname            =
 Alternate server port number         =

[db2inst2@xifenfei ~]$ db2start
04/05/2012 09:46:47     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.
[db2inst2@xifenfei ~]$ db2updv95 -d  xifenfei


_________________________________________________________________________     
                                                                              
                    _____   DB2 Service Tools   _____                         
                                                                              
                            I      B      M                                   
                                                                              
                               db2updv95                                      
                                                                              
   This tool is a service utility designed to update a DB2 Version 9.5        
   database to the current fixpak level.                                      
                                                                              
_________________________________________________________________________     


DB2 Universal Database Version 9.5, 5622-044 (c) Copyright IBM Corp. 2007
Licensed Material - Program Property of IBM
IBM DATABASE 2 Database update to current fix pack tool

db2updv95 completed successfully for database 'xifenfei'. 

7.补充说明
1)在升级数据库前需要做好数据库和软件备份
2)升级过程时先关闭所有db2相关进程,如果不能正常关闭(非本文上面列举操作相关进程),直接kill
3)升级过程中,如果实例,DAS等升级失败,需要后续手工升级
4)检查相关进程,如果没有正常启动,需要手工给予启动
5)一些工具进行绑定和重新绑定packages

db2 terminate
db2 connect to dbname
db2 BIND /home/db2inst2/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
db2 BIND /home/db2inst2/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 BIND /home/db2inst2/sqllib/bnd/@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
db2 terminate
db2rbind xifenfei -l logfile all
此条目发表在 DB2 分类目录。将固定链接加入收藏夹。

DB2 9.5.0.0升级至9.5.0.9(小版本升级)》有 1 条评论

  1. 惜分飞 说:

    小版本升级大致流程
    0.备份数据库和软件
    1.停止相关进程

    su - iname
    db2 force applications all
    db2 terminate
    db2stop
    db2licd -end
    su - dasusr1
    db2admin stop
    

    2.安装补丁

    Patch/installFixPack -b dbpath [-f db2lib]
    

    3.升级数据库

    db2updv95 -d dbname
    

    4.启动相关进程

    su - iname
    db2start
    su - dasusr1
    db2admin start
    

    5.工具绑定

    db2 terminate
    db2 connect to dbname
    db2 BIND $HOME/sqllib/bnd/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUE
    db2 BIND $HOME/sqllib/bnd/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 BIND $HOME/sqllib/bnd/@db2cli.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
    db2 terminate
    

    6.重新绑定packages

    db2rbind dbname -l logfile all
    

      [引用]  [回复]

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>