backout plan for db2 fix pack update

[Former Member]

Hi,

We are planning to do fix pack update from DB2 9.7.4 to DB2 9.7.5 (on AIX). OSS note 1363169 tells how to do it. What should be the backout plan if i something happens & i need to revert back?

Thanks & Regards,

Saravanan

[Former Member]

Steps to address worst case scenario:-

1)Stop all DB2 instances,DAS & DB2 licenses:-

                a) db2stop

                b) db2licd -end (Must be launch on each node)

                c) ipclean -a

                d) db2_kill (Clean all DB2 Process)

                e) ps –ef |grep –i db2 ( Check if still existing DB2 Process is running or not )

                f) su -  <das id>

                g) db2admin stop

2) Have a Lower Level DB2 Fix Pack code in place for rollback.

3)  Install DB2 Fix Pack from Lower Level as root

     ./installFixPack -b /opt/IBM/db2/V9.7 -f level

4)  Downgrade DB2 Instance back to DB2 V9.7 as root

a) cd /opt/IBM/db2/V9.7FP/instance

b)   ./db2iupdt -D <instance name>

5)  Downgrade DB2 Admin Server ./dasupdt –D

6) If Fixpack is installed on separate path then go to old installation path & update the instance &  bind packages.

cd /opt/IBM/db2/V9.7FP/instance

./db2iupdt -D instance name

7) Re-bind the bind files for each database.

😎  Restore database from the backup taken prior the DB2 Fix Pack Upgrade .

9)  Recycle DB2 instances & check instance & database health.

10)  Application team to start the applications & perform verification

[paul_power]

Hi Saravanan,

You can implement the new fixpack as a second instance, then switch to the new fixpack instance as per note 1363169 section III. - "Update using a new installation"

This way the previous fixpack is there as another instance in case need to switch back to it.

regards,

Paul

[Former Member]

Hi Paul,

But i'm planning to use the second option - 'Update an existing software installation' which should be easier. What would be the backout plan for this option?

Thanks & Regards,

Saravanan

[paul_power]

Hi Saravanan,

For that option you would have to uninstall the newer fixpack and re-install the lower one.

I would advise to contact support if any issues with the newer fixpack so that they may be resolved without having to try reverting to a previous fixpack.

As always, perform the update in sandbox env or test environment so that it can be tested before doing the update on productive systems so you are happy the new fixpack is working.

Regards,

Paul

[paul_power]

Please also heed the warnings of this post:

http://scn.sap.com/thread/3249292

[Former Member]

Hi Paul,

Thanks for the link. I guess the safer option would be to install a new copy and then do a switch. For reverting back, i just need to run db2iupdt from the older version, am i correct?

Thanks & Regards,

Saravanan