Upgrading your existing routines
to DB2® Version 9.7 involves
managing the changes between DB2 Version
9.7 and previous releases that impact these routines and verifying
that they function as expected. Managing these changes might require
that you modify your routine code, rebuild your external routines,
recreate your external routines in the database, and recreate SQL
routines.
Test your routines in a DB2 Version 9.7 testing environment. If they
run successfully, you are not required to change them. You only need
to modify your routines to manage any changes between releases, to
remove the use of discontinued or deprecated functionality in DB2 Version 9.7, or to use new functionality.
About this task
Restrictions
This
procedure only applies to SQL routines and external routines programmed
in C/C++, COBOL (procedures only), Java™,
and .NET languages.
Procedure
To upgrade your routines to DB2 Version
9.7 databases:
- If you identified changes in DB2 Version
9.7 that impact your routines, edit your routine code and modify:
- If you identified changes specific to
the development environment that impact your routines, modify them
to support these changes. Upgrade your:
- Rebuild all changed external routine libraries or if you
performed operating system or development software upgrades.
- Test your routines to verify your changes and to ensure
that the routines run as expected using DB2 Version
9.7.
What to do next
After upgrading your routines, perform the recommended
post-upgrade tasks for routines.