Upgrading DB2 Express C 9.7.1 to 9.7.2 on Linux

This manual is useful for Linux only. On windows just run installer and it will update DB2 copy for you.

Because fixpacks are not supported for DB2 Express C Edition, you can not just unpack new db2 image and run ./installFixPack. If you do, it will return an error. You also can not install new db2 image over old, installer will refuse to do it.

Cookbook for update operation is very simple:

  1. Install to new DB2 to new location
  2. Switch DB2 instance to newly installed copy
  3. Optionally remove old DB2 copy

To start install DB2 9.7.2 to different location:

sudo ./db2_install -b /opt/ibm/db2/V9.7.2/

After installation you will have 2 db2 copies installed as you can see with db2ls command:

db2inst1@ubuntu:~$ db2lsInstall Path Level Fix Pack Special Install Number Install Date Installer UID
/opt/ibm/db2/V9.7 1 Thu Jan 28 18:44:43 2010 CET 0
/opt/ibm/db2/V9.7.2 2 Wed Jun 2 23:27:48 2010 CEST 0

We need to switch our DB2 instance from old copy to new. This is pretty easy to do but we need to get some information about our current installation. First get name of our instance:

db2inst1@ubuntu:~$ db2ilist

and name of db2 fenced user

db2inst1@ubuntu:~$ cat sqllib/ctrl/.fencedID

Now we have enough information for switching our db2 instance from old db2 copy to new:

sudo /opt/ibm/db2/V9.7.2/instance/db2iupdt -u db2fenc1 db2inst1

Lets switch DAS server from old to new copy too:

sudo /opt/ibm/db2/V9.7.2/instance/dasupdt

And we are now ready to remove old DB2 copy. If you dont mind about 1GB diskspace used then you can keep old copy.

hsn@ubuntu:~$ sudo /opt/ibm/db2/V9.7/install/db2_deinstall -a
DBI1016I Program db2_deinstall is performing uninstallation. Please

The execution completed successfully.

Views: 658


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service