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.
Procedure
Perform the following post-upgrade tasks that apply to
your database applications and routines:
- 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.
- Tune your database applications. Review important guidelines
related to:
See related concepts for information about additional factors
that can affect application performance.
- Tune your routines. Review important guidelines related
to:
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.
- Remove dependencies on functionality that is deprecated
in DB2® Version 10.5 in your database applications and routines before that
functionality becomes discontinued.
For more details,
see Deprecated or discontinued functionality that affects DB2 server upgrades.
- Adopt new DB2 Version 10.5 functionality in database applications, where appropriate,
to improve performance or add new functionality. Check the Sample
files to understand how the new functionality works.
For
more details, see Adopting new Version 10.5 functionality in database applications and routines.