安装db2 fix pack

1.停数据库

[root@localhost universal]# su - db2inst2        --su到instance ID
[db2inst2@localhost ~]$ db2 force applications all        --断掉所有连接
DB20000I  The FORCE APPLICATION command completed successfully.
DB21024I  This command is asynchronous and may not be effective immediately.

[db2inst2@localhost ~]$ db2 terminate         --断掉自己
DB20000I  The TERMINATE command completed successfully.
[db2inst2@localhost ~]$ db2stop        --停instance
04/20/2011 21:01:34     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.
[db2inst2@localhost ~]$ db2licd -end         --停lisence管理器
[db2inst2@localhost ~]$ db2_ps        --确认关停了
Node 0
     UID        PID       PPID    C     STIME     TTY     TIME CMD
[db2inst2@localhost ~]$ db2iauto -off db2inst2        --v9的fp1,fp2需要关闭自动运行（why?）

2.开始升级

[root@localhost universal]# ./installFixPack -b /opt/ibm/db2s/v9.7 

DBI1017I  installFixPack is updating the DB2 product(s) installed in
      location /opt/ibm/db2s/v9.7.


DB2 installation is being initialized.

 Total number of tasks to be performed: 43 
Total estimated time for all tasks to be performed: 1471 

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 102 second(s) 
Task #5 end 

Task #6 start
Description: Java Runtime Support 
Estimated time 94 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 27 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 41 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 231 second(s) 
Task #14 end 

Task #15 start
Description: IBM Software Development Kit (SDK) for Java(TM) 
Estimated time 44 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: EnterpriseDB code 
Estimated time 3 second(s) 
Task #20 end 

Task #21 start
Description: Replication tools 
Estimated time 19 second(s) 
Task #21 end 

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

Task #23 start
Description: Control Center 
Estimated time 42 second(s) 
Task #23 end 

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

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

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

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

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

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

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

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

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

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

Task #34 start
Description: DB2 Text Search 
Estimated time 201 second(s) 
Task #34 end 

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

Task #36 start
Description: Installing or updating SA MP 
Estimated time 40 second(s) 

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

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

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

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

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

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

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

The execution completed successfully.

For more information see the DB2 installation log at
"/tmp/installFixPack.log.24452".

升级database：

[root@localhost v9.7]# instance/db2iupdt db2inst2
DBI1070I  Program db2iupdt completed successfully.

升级相关的系统目录：

[db2inst2@localhost universal]$ db2updv97 -d sample


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


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

db2updv97 completed successfully for database 'sample'. 

连接数据库：

[db2inst2@localhost universal]$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUX 9.7.2    --已经是新版本了
 SQL authorization ID   = DB2INST2
 Local database alias   = SAMPLE

库文件版本对比：

--升级前
[db2inst2@localhost ~]$ db2ls -a -q -b /opt/ibm/db2s/v9.7 

Install Path : /opt/ibm/db2s/v9.7

Feature Response File ID             Level   Fix Pack   Feature Description  
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT_R                       9.7.0.1          1   Base Client Support for installation with root privileges 
DB2_PRODUCT_MESSAGES_EN             9.7.0.1          1   Product Messages - English 
BASE_CLIENT                         9.7.0.1          1   Base client support 
JAVA_RUNTIME_SUPPORT                9.7.0.1          1   Java Runtime Support 
DB2_JAVA_HELP_EN                    9.7.0.1          1   Java Help (HTML) - English 
BASE_DB2_ENGINE_R                   9.7.0.1          1   Base server support for installation with root privileges 
GSK                                 9.7.0.1          1   Global Secure ToolKit 
JAVA_SUPPORT                        9.7.0.1          1   Java support 
SQL_PROCEDURES                      9.7.0.1          1   SQL procedures 
ICU_SUP                             9.7.0.1          1   ICU Utilities 
JAVA_COMMON_FILES                   9.7.0.1          1   Java Common files 
BASE_DB2_ENGINE                     9.7.0.1          1   Base server support 
JDK                                 9.7.0.1          1   IBM Software Development Kit (SDK) for Java(TM) 
DB2_CONTROL_CENTER_HELP_EN          9.7.0.1          1   Control Center Help (HTML) - English 
CONNECT_SUPPORT                     9.7.0.1          1   Connect support 
COMMUNICATION_SUPPORT_TCPIP         9.7.0.1          1   Communication support - TCP/IP 
DATABASE_PARTITIONING_SUPPORT       9.7.0.1          1   Parallel Extension 
EDB                                 9.7.0.1          1   EnterpriseDB code 
REPL_CLIENT                         9.7.0.1          1   Replication tools 
RELATIONAL_WRAPPERS_COMMON          9.7.0.1          1   Relational wrappers common 
CONTROL_CENTER                      9.7.0.1          1   Control Center 
CLPPLUS                             9.7.0.1          1   Command Line Processor Plus 
DB2_DATA_SOURCE_SUPPORT             9.7.0.1          1   DB2 data source support 
LDAP_EXPLOITATION                   9.7.0.1          1   DB2 LDAP support 
INSTANCE_SETUP_SUPPORT              9.7.0.1          1   DB2 Instance Setup wizard 
SPATIAL_EXTENDER_CLIENT_SUPPORT     9.7.0.1          1   Spatial Extender client 
APPLICATION_DEVELOPMENT_TOOLS       9.7.0.1          1   Base application development tools 
DB2_UPDATE_SERVICE                  9.7.0.1          1   DB2 Update Service 
FIRST_STEPS                         9.7.0.1          1   First Steps 
ESE_PRODUCT_SIGNATURE               9.7.0.1          1   Product Signature for DB2 Enterprise Server Edition 
DB2_SAMPLE_DATABASE                 9.7.0.1          1   Sample database source 
TEXT_SEARCH                         9.7.0.1          1   DB2 Text Search 
INFORMIX_DATA_SOURCE_SUPPORT        9.7.0.1          1   Informix data source support 

--升级后
[db2inst2@localhost universal]$ db2ls -a -q -b /opt/ibm/db2s/v9.7 

Install Path : /opt/ibm/db2s/v9.7

Feature Response File ID             Level   Fix Pack   Feature Description  
---------------------------------------------------------------------------------------------------------------------
BASE_CLIENT_R                       9.7.0.2          2   Base Client Support for installation with root privileges 
DB2_PRODUCT_MESSAGES_EN             9.7.0.2          2   Product Messages - English 
BASE_CLIENT                         9.7.0.2          2   Base client support 
JAVA_RUNTIME_SUPPORT                9.7.0.2          2   Java Runtime Support 
DB2_JAVA_HELP_EN                    9.7.0.2          2   Java Help (HTML) - English 
BASE_DB2_ENGINE_R                   9.7.0.2          2   Base server support for installation with root privileges 
GSK                                 9.7.0.2          2   Global Secure ToolKit 
JAVA_SUPPORT                        9.7.0.2          2   Java support 
SQL_PROCEDURES                      9.7.0.2          2   SQL procedures 
ICU_SUP                             9.7.0.2          2   ICU Utilities 
JAVA_COMMON_FILES                   9.7.0.2          2   Java Common files 
BASE_DB2_ENGINE                     9.7.0.2          2   Base server support 
JDK                                 9.7.0.2          2   IBM Software Development Kit (SDK) for Java(TM) 
DB2_CONTROL_CENTER_HELP_EN          9.7.0.2          2   Control Center Help (HTML) - English 
CONNECT_SUPPORT                     9.7.0.2          2   Connect support 
COMMUNICATION_SUPPORT_TCPIP         9.7.0.2          2   Communication support - TCP/IP 
DATABASE_PARTITIONING_SUPPORT       9.7.0.2          2   Parallel Extension 
EDB                                 9.7.0.2          2   EnterpriseDB code 
REPL_CLIENT                         9.7.0.2          2   Replication tools 
RELATIONAL_WRAPPERS_COMMON          9.7.0.2          2   Relational wrappers common 
CONTROL_CENTER                      9.7.0.2          2   Control Center 
CLPPLUS                             9.7.0.2          2   Command Line Processor Plus 
DB2_DATA_SOURCE_SUPPORT             9.7.0.2          2   DB2 data source support 
LDAP_EXPLOITATION                   9.7.0.2          2   DB2 LDAP support 
INSTANCE_SETUP_SUPPORT              9.7.0.2          2   DB2 Instance Setup wizard 
SPATIAL_EXTENDER_CLIENT_SUPPORT     9.7.0.2          2   Spatial Extender client 
APPLICATION_DEVELOPMENT_TOOLS       9.7.0.2          2   Base application development tools 
DB2_UPDATE_SERVICE                  9.7.0.2          2   DB2 Update Service 
FIRST_STEPS                         9.7.0.2          2   First Steps 
ESE_PRODUCT_SIGNATURE               9.7.0.2          2   Product Signature for DB2 Enterprise Server Edition 
DB2_SAMPLE_DATABASE                 9.7.0.2          2   Sample database source 
TEXT_SEARCH                         9.7.0.2          2   DB2 Text Search 
INFORMIX_DATA_SOURCE_SUPPORT        9.7.0.2          2   Informix data source support 

至此，fix pack打完