DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading a DB2 server (Windows)

Upgrading a DB2® server on Windows to DB2 Version 9.7 requires that you install a new DB2 Version 9.7 copy and then upgrade your existing instances and databases to this new copy.

If you choose to automatically upgrade your existing pre-Version 9.7 copy during the DB2 Version 9.7 installation, your instances and DB2 administration server (DAS) are upgraded but you still need to upgrade your databases after installation. If you choose to install a new DB2 Version 9.7 copy, you must manually upgrade your instances, your DAS, and databases.

This upgrade task describes the steps for direct upgrade to DB2 Version 9.7 from DB2 Version 9.5, DB2 Version 9.1, or DB2 UDB Version 8. Review upgrading environments with specific characteristics and determine which task applies better to your environment.

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 determined 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.
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.
Additional upgrade restrictions apply. Review the complete list.

Before you begin

Ensure that you have Local Administrator authority. See the Prerequisites section in Installing DB2 servers (Windows) for additional authorization details.
Ensure that you meet the installation requirements for DB2 database products.
Review upgrade recommendations and disk space requirements.
Perform pre-upgrade tasks.

Procedure

To upgrade a DB2 server to DB2 Version 9.7:

Log on to the DB2 server as a user with Local Administrator authority.
Install DB2 Version 9.7 by running the setup command to launch the DB2 Setup wizard. You have three choices:
- To automatically upgrade a DB2 copy, all the instances running on the selected DB2 copy, and your DAS, select the Work with Existing option on the Install a Product panel. Then, in the Work with Existing window, choose the DB2 copy name with the upgrade action. The selected DB2 copy and add-on products are uninstalled.
  You will get a warning that recommends that you run the db2ckupgrade command if you have local databases. If you completed the pre-upgrade tasks, ignore this warning and continue the upgrade. Otherwise, verify that your databases are ready for DB2 upgrade before continuing with the installation.
- To create a new copy of DB2 Version 9.7, select the Install New option on the Install a Product panel.
- To create a response file and perform a response file installation, select the Work with Existing option on the Install a Product panel. Then in the Work with Existing window, choose the DB2 copy name with the upgrade action. Finally, in the Select the installation, response file creation, or both window, select the Save my installation setting in a response file option to create a response file for a response file installation. The response file has the required UPGRADE_PRIOR_VERSIONS keyword, the DB2 copy name to upgrade, and the installation path.
  
  The result of the response file installation will be the same as in the first choice, all your instances running on the selected DB2 copy and your DAS are automatically upgraded to the DB2 Version 9.7 copy.
Install all DB2 add-on products that were installed in the DB2 copy from which you are upgrading.
If you installed a new copy of DB2 Version 9.7, upgrade your instances to this new copy.
If you want your applications to access the 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. You must define a default copy if you upgraded from DB2 UDB Version 8 because there is no default copy defined in your DB2 server.
Optional: If you installed a new copy, upgrade the 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.
Upgrade your databases.

What to do next

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