DB2 10.5 for Linux, UNIX, and Windows

Upgrading a DB2 server (Windows)

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

If you choose to automatically upgrade your existing pre-DB2 Version 10.5 copy during the DB2 Version 10.5 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 10.5 copy, you must manually upgrade your instances, your DAS, and databases.

This upgrade task describes the steps for direct upgrade to DB2 Version 10.5 from DB2 Version 10.1 or DB2 Version 9.7. Review the steps in upgrading environments with specific characteristics and determine which task applies better to your environment.

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 prerequisites.
Review upgrade recommendations and disk space requirements. Refer to Best practices for upgrading DB2 servers and Disk space requirements for DB2 server upgrades.
Perform pre-upgrade tasks. Refer to Pre-upgrade tasks for DB2 servers.

Restrictions

This procedure applies only to upgrade from DB2 32-bit servers when you install the DB2 Version 10.5 32-bit database product or from DB2 64-bit servers when you install the DB2 Version 10.5 64-bit database product. The instance bit size is determined by the operating system and the DB2 Version 10.5 database product that you install, see Support changes for 32-bit and 64-bit DB2 servers for details.
Additional upgrade restrictions apply. Refer to Upgrade restrictions for DB2 servers. Review the complete list.

Procedure

To upgrade a DB2 server to DB2 Version 10.5:

Log on to the DB2 server as a user with Local Administrator authority.
Install DB2 Version 10.5 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 10.5, 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 10.5 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 10.5, upgrade your DB2 Version 10.1 or DB2 Version 9.7 instances to this new copy. Refer to Upgrading DB2 Version 10.1 or DB2 Version 9.7 instances.
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 10.5. Refer to Upgrading the DB2 Administration Server (DAS).
Upgrade your databases. Refer to Upgrading 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. Refer to Post-upgrade tasks for DB2 servers and Verifying upgrade of DB2 servers.