安装db2 fix pack

白森

1.停数据库

[iyunv@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.开始升级

[iyunv@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：

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