DB2 Version 9.7 for Linux, UNIX, and Windows

Database applications and routines upgrade

Upgrading to DB2® Version 9.7 involves the upgrade of your database applications and routines if changes in DB2 Version 9.7 impact your database applications and routines.

Upgrading your applications and routines involves the following actions:

Test whether your applications and routines perform as expected in a DB2 Version 9.7 testing environment. You do not need to upgrade your applications and routines if they run successfully.
If your applications or routines have errors running in DB2 Version 9.7, you should:
- Review upgrade essentials for database applications to identify any changes in DB2 Version 9.7 that can impact your applications.
- Review upgrade essentials for routines to identify any changes in DB2 Version 9.7 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 9.7 testing environment.
Verify that your applications and routines perform as expected in your DB2 Version 9.7 production environment before deploying them.

If your applications and routines use any functionality that is deprecated in DB2 Version 9.7, you should plan how to remove this functionality from your application code in the near future.

Also, you should consider adopting new functionality available in DB2 Version 9.7 to enhance functionality and improve performance.