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:
- Review upgrade essentials for database applications to
determine which changes might impact your database applications.
Refer to Upgrade essentials for database applications.
- Review upgrade essentials for routines to determine which
changes might impact your routines.
Refer to Upgrade essentials for routines.
- Plan your upgrade strategy.
Refer to Planning your DB2 environment upgrade.
- Upgrade your operating system to a supported level if necessary.
- Upgrade your development software to a supported
level if necessary.
- 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.
- Optional: Upgrade your client or install a
Version 9.7 application driver if your application requires one.
Refer to Clients upgrade .
Although DB2 Version 9.7 server provides connectivity support for earlier clients, using
a Version 9.7 client eliminates any limitations and incompatibilities
between releases.
- Test your database applications in a DB2 Version 9.7 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.
Refer
to Upgrading DB2 servers in a test environment and Upgrading database applications.
- Test your routines in a DB2 Version 9.7 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.
Refer to Upgrading DB2 servers in a test environment and Upgrading routines.