Upgrading DB2 servers in MSCS

Body

We have a very good knowledge center document to follow when upgrading db2 servers in MSCS set-ups :
     
Upgrading DB2 servers in Microsoft Cluster Server environments                                                
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0022647.html

Although above document is perfect to follow during the actual upgrade operation, there are a number of things
to consider and plan for the upgrade operation.

Here is a simple plan (outline) to use as guideline when planning to upgrade db2 server in MSCS environment (mentioned in brackets

is the team which should ensure each step completion) :                 
 

A. DB2 Version Upgrade Plan:
Part 1:

1.1 Check application and database status on the cluster then confirm if its running as usual or not (by Application Team)

1.2 Stop the application (by Application Team)

1.3 Check the location of the resources (application & DB) - On 1 or both nodes in cluster (by Windows Administrator)

1.4 Stop the Windows cluster services on the node that is NOT having the resources (by Windows Administrator)

1.5 Ensure that all resources are now locked on 1 node (by Windows Administrator)

Part 2 (by DB2 Administrator) :

2.1 DB2 System will request operations to bring DB2 down and turn automation flags off

2.2 DB2 System - Check Installation Instructions

2.3 Back up current database, DB2 Support datasets for fall back plan (B)

2.4 db2diag -A

2.5 Confirm if you are able to list the Database using "db2 list db directory"
     If Databases are not listed, catalog the databases that you want to check using the db2ckupgrade utility.
     If the Database are listed fine before but still failing on Upgrade,it might be a good idea to lock the
     cluster before attempting another database upgrade as this happens mostly when database directory drive has moved on cluster.
     (this step can be checked after db2iupgrade or db2ckupgrade in step 2.7/2.8 as well)

2.6 Install new version/level of db2

2.7 Upgrade db2 instance (using db2iupgrade command in the mentioned knowledge center link on top)

2.8 Upgrade databases

Part 3:

3.1 Check if the database version has been upgraded from old to new (by DB2 Administrator)

3.2 If yes, proceed to start back the Windows cluster services (by Windows Administrator)

3.3 If no, proceed to fall back Plan(B)

3.4 Start back the application (by App Team)

3.5 Test the application and database (by App Team)

B. Fallback Plan :

1. Fallback to old database, DB2 Support datasets. (by DB2 Administrator)

2. Check and Test old version (by DB2 Administrator)

3. DB2 System will request operations to start DB2 and related (started) tasks up and turn automation flags on (by DB2 Administrator)

4. Test the application and database (by Application Team)