DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading DB2 servers in Microsoft Cluster Server environments

Upgrading DB2® servers in Microsoft Cluster Server (MSCS) environments to DB2 Version 9.7 requires that you install DB2 Version 9.7 as a new copy in all nodes and then upgrade your MSCS instances and databases.

Microsoft Cluster Server (MSCS) provides High Availability functions to windows users. During setup of DB2 server failover support on MSCS, a server instance is transformed into an MSCS instance. You can run the db2iupgrade command to upgrade your MSCS instance and to upgrade existing pre-Version 9.7 MSCS resources to DB2 Version 9.7 DB2 MSCS resources.

About this task

Restrictions

This procedure applies only to upgrade from DB2 32-bit servers when you install the DB2 Version 9.7 32-bit database product, or from DB2 64-bit servers when you install the DB2 Version 9.7 64-bit database product. The instance bit size is determine by the operating system and the DB2 Version 9.7 database product that you install, see Support changes for 32-bit and 64-bit DB2 servers for details.
Use only the Install New option in the Install a Product panel to install DB2 Version 9.7. If you choose the upgrade action when you select the Work with Existing option on the Install a Product panel, the installation process will fail.
Additional upgrade restrictions apply. Review the complete list.

Before you begin

Ensure that you have Local Administrator access.
SYSADM authority is required.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks, especially Back up your databases.

Procedure

To upgrade a DB2 server in an MSCS environment to DB2 Version 9.7:

Log on to the DB2 server as a user with Local Administrator authority.
Install DB2 Version 9.7 in all of the nodes in the MSCS cluster. Run the setup command to launch the DB2 Setup wizard and select the Install New option in the Install a Product panel. Do not select the Work with Existing option.
Take the resource for the instance offline using the Cluster Administrator. The resource name is the same as the instance name. Ensure that all the remaining resources in the same group as the instance are online.
For more information about using the Cluster Administrator refer to MSCS documentation.
Upgrade your MSCS instances by running the db2iupgrade command. This command defines a new resource type called "DB2 Server", and updates all DB2 MSCS resources to use the new resource type. Having a new resource type during the upgrade eliminates conflict with existing pre-Version 9.7 MSCS resources.
```
     $DB2DIR\bin\db2iupgrade /u:user,password MSCS-InstName
```
You must run this command from the node that owns all the instance dependent resources.
Stop and restart the cluster service in all of the nodes in the MSCS cluster using the Cluster Administrator.
Bring online the group of resources containing the upgraded instance using the Cluster Administrator.
Optional: Upgrade your DB2 Administration Server (DAS) if you want to keep your existing DAS configuration and use new functionality available in DB2 Version 9.7. If your DAS is running on DB2 UDB Version 8, upgrade it to use the Control Center to administer your instances running under DB2 Version 9.1 or later. If you choose to create a new DAS, you have to re-configure the DAS settings for your MSCS environment.
Upgrade your databases.

Results

What to do next

After upgrading the DB2 server, perform the recommended post-upgrade tasks such as resetting the diagnostic error level, adjusting log space size, and rebinding packages. In addition, verify that the upgrade of your DB2 server was successful.