DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading DB2 32-bit servers to 64-bit systems (Windows)

On the Windows operating systems, there are two ways to upgrade your DB2® 32-bit server to a DB2 Version 9.7 64-bit server. One way is to upgrade your existing DB2 32-bit server to DB2 Version 9.7 32-bit server, and then upgrade to DB2 Version 9.7 64-bit server.

The other way is to upgrade to a new computer where DB2 Version 9.7 64-bit database product is installed.

About this task

Restrictions

This procedure is covered by this task and only applies to Windows on x64.
Additional upgrade restrictions apply. Review the complete list.
If you are performing a response file installation to automatically upgrade a DB2 UDB Version 8 copy with multiple DB2 products installed, your copy must be at DB2 UDB Version 8 FixPak 7 or later.

Before you begin

Ensure that you have Local Administrator authority.
Ensure that the DB2 server is running 64-bit windows operating system.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks.

Procedure

To upgrade a pre-Version 9.7 DB2 32-bit server to a DB2 Version 9.7 64-bit server:

Log on to the DB2 server as a user with Local Administrator authority.
If you have multiples copies of DB2 UDB Version 8 32-bit server, DB2 Version 9.1 32-bit server, or DB2 Version 9.5 32-bit server, perform the following actions to have all instances running under one DB2 copy:
- Update all your instances to run under one DB2 Version 8 32-bit server copy, one DB2 Version 9.1 32-bit server copy, or one DB2 Version 9.5 32-bit server copy. You can only update instances of the same version.
- If you have instances running on multiple pre-Version 9.7 copies of different version, upgrade all instances to the highest release of pre-Version 9.7 copies. For example, if you have a Version 8 and a Version 9.1 instance, upgrade your Version 8 instance to the DB2 Version 9.1 32-bit server copy.
- Uninstall all the remaining DB2 server copies except the DB2 server copy where all instances are running. You should have only one DB2 UDB Version 8 32-bit server copy, DB2 Version 9.1 32-bit server copy, or DB2 Version 9.5 32-bit server copy.
Install DB2 Version 9.7 32-bit database product and select the Work with Existing option on the Install a Product panel. Then in the Work with an existing window, choose the DB2 copy name with the upgrade action. The selected DB2 copy is removed, and all your instances running on the selected DB2 copy and your DB2 Administration Server (DAS) are automatically upgraded. Do not install additional copies of 32-bit DB2 Version 9.7.
You will get a warning that recommends that you to run the db2ckupgrade command if you have local databases. Ignore this warning and continue the upgrade if you completed the pre-upgrade tasks. Otherwise, verify that your databases are ready for DB2 upgrade before you continue with the installation.
Install DB2 Version 9.7 64-bit database product and select the Work with Existing option on the Install a Product panel. Then in the Work with an existing window, choose the DB2 copy name with the upgrade action. This procedure removes DB2 Version 9.7 32-bit database product, and upgrades your existing 32-bit instances to 64-bit instances.
If you want your applications to access DB2 Version 9.7 copy through the default interface or if you upgraded your existing DB2 UDB Version 8 copy, set the DB2 Version 9.7 copy as the DB2 default copy .
Upgrade your databases.
If you want to have your instances running on multiples copies of DB2 Version 9.7, install additional DB2 Version 9.7 copies and issue the db2iupdt command to run an instance under a different DB2 Version 9.7 copy.

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.