Upgrading a Db2 server (Windows)

Upgrading a Db2 server on Windows to version 12.1 requires that you install a new version 12.1 copy and then upgrade your existing instances and databases to this new copy.

If you choose to automatically upgrade your existing pre- version 12.1 copy during the version 12.1 installation, your instances are upgraded but you still need to upgrade your databases after installation. If you choose to install a new version 12.1 copy, you must manually upgrade your instances, and databases.

This upgrade task describes the steps for direct upgrade to Db2 version 12.1 from version 11.1 or version 10.5. Review the steps in upgrading environments with specific characteristics and determine which task applies better to your environment.

Before you begin


Restrictions

  • This procedure applies only to upgrade from Db2 32-bit servers when you install the version 12.1 32-bit database product or from 64-bit servers when you install the version 12.1 64-bit database product. The instance bit size is determined by the operating system and the version 12.1 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 12.1:

  1. Log on to the Db2 server as a user with Local Administrator authority.
  2. Install Db2 version 12.1 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, 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 12.1, 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 are automatically upgraded to the Db2 version 12.1 copy.

  3. Install all Db2 add-on products that were installed in the Db2 copy from which you are upgrading.
  4. If you installed a new copy of Db2 version 12.1, upgrade your Db2 version 11.1 or version 10.5 instances to this new copy.
    Refer to Upgrading Db2 11.5 and 11.1 instances.
  5. 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.