安装db2 fix pack

1.停数据库
[code="sql"]
# 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?）
[/code]

2.开始升级
[code="sql"]
# ./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".

[/code]

升级database：
[code="sql"]
# instance/db2iupdt db2inst2
DBI1070I Program db2iupdt completed successfully.
[/code]

升级相关的系统目录：

[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打完