Planning the upgrade of database applications and routines
requires that you review all of the applicable pre-upgrade tasks,
upgrade prerequisites, upgrade tasks, and post-upgrade tasks.
Procedure
To create an upgrade plan for your database applications
and routines:
- Write the upgrade plan for database applications, using
all the details that apply to your environment:
Table 1. Upgrade plan details for database applications.Upgrade plan |
Details |
Prerequisites |
Ensure that you:
|
Pre-upgrade tasks |
Include the following tasks: - Upgrade your client or install
Version 9.7 application driver.
- Test your database applications in a DB2 Version
9.7 testing environment. If your applications run successfully, the
rest of the upgrade steps are not required.
In addition, check the list of pre-upgrade
tasks for optional tasks that you might want to perform for
your environment. Even if your current operating system and development
software are supported, consider including the following tasks to
improve application performance: - Upgrade your operating system to the latest supported level
- Upgrade your development software to the latest supported level
|
Upgrade task |
You must include these steps: - Modify your application code to support changes in DB2 Version 9.7 and to remove use of functionality
that is discontinued in DB2 Version
9.7.
- Modify your application to support changes specific to the development
environment.
- Rebuild all database applications after completing your modifications.
- Test your database applications using DB2 Version 9.7.
Review the following upgrade tasks to determine the additional
steps that are required by your development environment to upgrade
database applications:
|
Post-upgrade tasks |
Perform the recommended post-upgrade
tasks for database applications, especially:
|
- Write the upgrade plan for routines, using all the details
that apply to your environment:
Table 2. Upgrade plan
details for routines.Upgrade plan |
Details |
Prerequisites |
Ensure that you:
|
Pre-upgrade tasks |
Include the following task: - Test your routines in a DB2 Version
9.7 testing environment. If your routines run successfully, the rest
of the upgrade steps are not required.
In addition, check the list of pre-upgrade
tasks for optional tasks that you might want to perform for
your environment. Even if your development software is supported,
consider upgrading your development software to the latest supported
level. |
Upgrade task |
You must include these steps: - Modify your routines to support changes in DB2 Version 9.7 and to remove use of functionality
that is discontinued in DB2 Version
9.7.
- Modify your routines to support changes specific to the development
environment.
- Rebuild all external routines after completing your modifications.
- Retest your routines using DB2 Version
9.7.
Review the following upgrade tasks to determine the additional
steps that are required by your development environment to upgrade
routines:
|
Post-upgrade tasks |
Perform the recommended post-upgrade
tasks for routines, especially:
|
- Combine with the upgrade plan for other components such
as clients and DB2 servers to
create an overall upgrade plan for your DB2 environment.