Upgrade database applications, routines, tools, and scripts

Upgrading your Db2® database product to a new release might require upgrading your database applications, routines, tools, and scripts if changes in new release impacts them.

Upgrading your applications and routines involves the following actions:

Test whether your applications and routines perform as expected in a Db2 version 11.1 testing environment. You do not need to upgrade your applications and routines if they run successfully.
If your applications or routines have errors that run in Db2 version 11.1, you must do the following:
- Review upgrade essentials for database applications to identify any changes in Db2 version 11.1 that can impact your applications.
- Review upgrade essentials for routines to identify any changes in Db2 version 11.1 that can impact your routines.
- Plan how to modify your applications and routines to handle these changes. Determine the steps that you must perform by reviewing the Upgrading database applications or Upgrading routines tasks.
- Modify your applications and routines according to your plan.
- Test your applications and routines in a Db2 version 11.1 testing environment.
Verify that your applications and routines perform as expected in your Db2 version 11.1 production environment before deploying them.

If your applications and routines use any functionality that is deprecated in Db2 version 11.1, you must remove the use of this functionality from your application code. The deprecated functionality will not be supported in Db2 version 11.1 and may be discontinued in a future release.

Also, you must consider adopting new functionality available in Db2 version 11.1 to enhance functionality and improve performance.