Post-upgrade tasks for database applications and routines

After upgrading your database applications and routines, you should perform several post-upgrade tasks to ensure that your database applications and routines perform as expected and at their optimum levels.

Perform the following post-upgrade tasks that apply to your database applications and routines:

1. Perform benchmark tests on your database applications and routines in your production environment and compare with the baseline results that you saved before the upgrade.
2. Tune your database applications. Review important guidelines related to:
   • Character conversion
   • Optimization class
   • Isolation level
   • Locks and concurrency
   • Parallel processing for applications
   • Query optimization

   See related concepts for information about additional factors that can affect application performance.

3. Tune your routines. Review important guidelines related to:
   • Stored procedures
   • SQL procedures

   In addition, review guidelines on improving the performance of database applications that also apply to routines, such as the guidelines on optimization classes, locks, concurrency, and query tuning.

4. Remove dependencies on functionality that is deprecated in DB2® Version 9.7 in your database applications and routines before that functionality becomes discontinued.

   Refer to Deprecated or discontinued functionality that affects DB2 server upgrades.

5. Adopt new DB2 Version 9.7 functionality in database applications, where appropriate, to improve performance or add new functionality. Check the Sample files to understand how the new functionality works.

   Refer to Adopting new DB2 Version 9.7 functionality in database applications and routines.