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: - Clients upgrade or install the DB2 Version 10.1 application driver.
- Test your database applications in a DB2 Version 10.1 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 database applications and routines 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 10.1 and to remove use of functionality that is discontinued
in DB2 Version 10.1.
- 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 10.1.
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 and routines,
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 10.1 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 database applications and routines 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 10.1 and to remove use of functionality that is discontinued
in DB2 Version 10.1.
- 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 10.1.
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 database applications and 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.