Upgrading a DB2 pureScale server

Upgrading a DB2® pureScale® server to DB2 Version 10.1 requires that you install a new DB2 Version 10.1 copy and then manually upgrade your existing instances and databases to this new copy.

To upgrade a DB2 server to DB2 Version 10.1:

1. Log on to the DB2 server as the instance owner.
2. Disconnect all applications and users on every member node. To get a list of all database connections for the current instance, issue the LIST APPLICATIONS command. If all applications are disconnected, this command returns the following message:

      db2 list applications
        SQL1611W No data was returned by the Database System Monitor.
        SQLSTATE=00000

   To disconnect all applications and users, use the FORCE APPLICATION command:

      db2 force application all

3. Stop all command line processor sessions by entering the following command in each session that was running the command line processor:

      db2 terminate

4. When all applications and users are disconnected and all command line processor sessions are stopped, stop the database manager instance:

      db2stop

   Note: The time that is needed for the db2stop command to complete the action depends on the number of cluster caching facilities (CFs) and members in the cluster (up to 10 minutes).
5. If the db2stop command is not successful and fails to stop the database manager instance timeout due to new incoming connections, run the following command to disconnect all user connections and stop the database manager instance:

      db2stop force

   Ensure that the db2stop force command completes successfully.
6. Stop all instance processes in members and cluster caching facilities (CFs) in any order by issuing the db2stop instance on <hostname> command on any node, where hostname is the name of each member or CF in the cluster.
7. Install DB2 Version 10.1 by performing the following steps:
   1. Log on to the DB2 server with root user authority.
   2. Put the cluster management software into maintenance mode on all members and cluster caching facilities (CFs) by issuing the following command from the pre-DB2 Version 10.1 installation path . This command stops the peer domain services on all hosts and prevents it from restarting during system maintenance. You can issue the following command only one time on any one of the members or CFs in the cluster.

      OLD_DB2_INSTALL_DIR/bin/db2cluster -cm -enter -maintenance -all

      where OLD_DB2_INSTALL_DIR is the pre-DB2 Version 10.1 installation path. For example, if you are upgrading from DB2 Version 9.8 to DB2 Version 10.1, the OLD_DB2_INSTALL_DIR is specified as /opt/IBM/db2/V9.8.
   3. Put the cluster file system into maintenance mode on all members and CFs by issuing the following command from the pre-DB2 Version 10.1 installation path. This command stops all hosts from accessing the cluster files system (GPFS™) during system maintenance. You can issue the following command only one time on any one of the members or CFs in the cluster.

      OLD_DB2_INSTALL_DIR/bin/db2cluster -cfs -enter -maintenance -all

   4. Install DB2 Version 10.1 using the DB2Setup wizard. Run the db2setup command and select the Install New option on the Install a Product panel to install a new copy of DB2 Version 10.1. In the Set up a DB2 instance panel, select the option Do not create a DB2 instance. The DB2 installer still performs the installation, but, you can create an instance at a later point by running the db2icrt or db2isetup command. The DB2Setup wizard provides a clear flow through which you can start a DB2 pureScale Feature installation from one member and successfully setup a DB2 pureScale environment across multiple members. The cluster management software and the cluster file system software are also upgraded during the installation to meet the V10.1 requirements. For more information, see Install DB2 Version 10.1.
   5. Take the cluster management software out of maintenance mode by issuing the following command from the pre-DB2 Version 10.1 installation path:

      OLD_DB2_INSTALL_DIR/bin/db2cluster -cm -exit -maintenance -all

      Note: If the old DB2 installation path is of DB2 Version 10.1 (FP3 or below), you must take the cluster management software out of maintenance mode by issuing the following command:

      OLD_DB2_INSTALL_DIR/bin/db2cluster -cm -exit -maintenance 

   6. Take the cluster file system software out of maintenance mode by issuing the following command from the pre-DB2 Version 10.1 installation path.

      OLD_DB2_INSTALL_DIR/bin/db2cluster -cfs -exit -maintenance -all

   7. Commit changes to the cluster file system by issuing the following command from the DB2 Version 10.1 installation path.

      NEW_DB2_INSTALL_DIR/bin/db2cluster -cfs -commit

      where NEW_DB2_INSTALL_DIR is the DB2 Version 10.1 installation path.
   8. Commit changes to the cluster management software by issuing the following command from the DB2 Version 10.1 installation path.

      NEW_DB2_INSTALL_DIR/bin/db2cluster -cm -commit

   9. Restart the DB2 instance processes on all members and CFs with updated resources for the cluster management software and the cluster file system software by issuing the db2start instance on <hostname> command.
8. Install all DB2 add-on products that were installed in the DB2 copy from which you are upgrading.
9. Upgrade DB2 Version 9.8 instances. Refer to Upgrading DB2 Version 9.8 instances.
10. Upgrade databases. Refer to Upgrading databases.