In this post i will give steps to upgrade DB2 9.7 GA to DB2 9.7 Fixpack 3a.
DB2 9.7 HADR with TSA Part 00 - Introduction
DB2 9.7 HADR with TSA Part 1 : Installing and configuring VMWare environment
DB2 9.7 HADR with TSA Part 2 : Installing IBM tools for querying and monitoring purpose
DB2 9.7 HADR with TSA Part 3 : Installing IBM DB2 9.7 database
DB2 fixpack are of two type. They are
1) DB2 Universal Fixpack
In this, you need to have the GA of the product installed on the machine. In this setup, it include all the APAR until this fixpack level. It does not include the base code of the product. This is ideal in the PROD environment.
2) DB2 Server Fixpack
In this, the fixpack include the base code + APAR until this fixpack level. This is just one single installation that include the Fixpack at the desired level. This is ideal for new installation.
B) Download Details
DB2 9.7 HADR with TSA Part 00 - Introduction
DB2 9.7 HADR with TSA Part 1 : Installing and configuring VMWare environment
DB2 9.7 HADR with TSA Part 2 : Installing IBM tools for querying and monitoring purpose
DB2 9.7 HADR with TSA Part 3 : Installing IBM DB2 9.7 database
A) Introduction
DB2 fixpack are of two type. They are
1) DB2 Universal Fixpack
In this, you need to have the GA of the product installed on the machine. In this setup, it include all the APAR until this fixpack level. It does not include the base code of the product. This is ideal in the PROD environment.
2) DB2 Server Fixpack
In this, the fixpack include the base code + APAR until this fixpack level. This is just one single installation that include the Fixpack at the desired level. This is ideal for new installation.
B) Download Details
| Item# | Description |
|---|---|
| Download Source | http://www-01.ibm.com/support/docview.wss?uid=swg27007053 |
C) Step to install fixpack
| Item# | Description | Command |
|---|---|---|
| 1 | Downlaod the DB2 fixpack | NA |
| 2 | Stop DAS instance | db2admin stop |
| 3 | Stop all DB2 instance | db2stop force |
| 4 | Get the current DB2 9.7 product install path | db2ls |
| 5 (a) | Execute the install Fixpack script to upgrade the already installed DB2 binary files | ./installFixpack -b (DB2 product install path taken from db2ls command) |
| ==OR== 5 (b) | Execute the install Fixpack script to install DB2 server fixpack to different location | ./installFixpack -b (New location for DB2 installation) |
| 6 | Check the DB2 installed location | db2ls |
| 7 | Validate the installation | db2val |
C) Steps to upgrade the instance to new Fixpack level
| Item# | Description | Command |
|---|---|---|
| 1 | Check the DB2 installed location | db2ls |
| 2 | Get the instance names | db2ilist |
| 3 | Get the db2fence user name | cat sqllib/ctrl/.fencedID |
| 4 | Upgrade the instance | 1) Login as root 2) cd (New DB2 install location taken from output of db2ls command) 3) cd (db2_install_path)/instance 4) ./db2iupdt -u (fence_user_name) (Instance_name) |
| 5 | Upgrade DAS instance(DAS is Deprecated in Db2 9.7) | 1) Login as root 2) cd (new_db2_install_path)/instance 3) ./dasupdt |
No comments:
Post a Comment