Pre-upgrade tasks for database applications and routines

Before you upgrade your database applications and routines, you should perform certain tasks to help you ensure a successful upgrade.

Procedure

Prepare for the upgrade of your database applications and routines by performing the following tasks:

  1. Review upgrade essentials for database applications to determine which changes might impact your database applications.

    For more details, see Upgrade essentials for database applications.

  2. Review upgrade essentials for routines to determine which changes might impact your routines.

    For more details, see Upgrade essentials for routines.

  3. Plan your upgrade strategy.

    For more details, see Plan your Db2 environment upgrade.

  4. Upgrade your operating system to a supported level if necessary.
  5. Upgrade your development software to a supported level if necessary.
  6. Perform benchmark tests on your database applications and routines in your production environment and save these baseline results to compare with benchmark test results after the upgrade.
  7. Optional: Upgrade your client or install a Db2 version 12.1 application driver if your application requires one.

    For more details, see Upgrade Db2 clients .

    Although Db2 version 12.1 server provides connectivity support for earlier clients, using a Db2 version 12.1 client eliminates any limitations and incompatibilities between releases.

  8. Test your database applications in a Db2 version 12.1 testing environment.
    If testing is successful, you do not need to upgrade your applications. However, review the upgrading database applications task and consider performing any steps that can help you improve performance.

    For more details, see Upgrading Db2 servers in a test environment and Upgrading database applications.

  9. Test your routines in a Db2 version 12.1 testing environment.
    If testing is successful, you do not need to upgrade your routines. However, review the upgrading routines task and consider performing any steps that can help you improve performance.

    For more details, see Upgrading Db2 servers in a test environment and Upgrading routines.