DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading routines

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.

Before you begin

Review upgrade essentials for routines to identify any changes that apply to your routines.
Ensure that you have access to upgraded DB2 Version 9.7 databases. These can be test databases.
Ensure that you meet the installation requirements for DB2 database products.
Ensure that the development software is at a version level that is supported by DB2 database products.
Perform the pre-upgrade tasks for routines.
Ensure that you have the necessary authorizations and privileges to use the ALTER FUNCTION or ALTER PROCEDURE statements. The authorizations allowed are listed in the SQL Reference, Volume 2.

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:
- SQL statement syntax
- SQL statements using SQL Administrative views and routines, built-in routines, and catalog views
- User defined routine names that are not fully qualified with a schema names
- Application programming interface calls such as JDBC and CLI
If you identified changes specific to the development environment that impact your routines, modify them to support these changes. Upgrade your:
- C, C++, and COBOL routines
- Java routines.
- .NET CLR routines.
- SQL stored procedures, if you created your SQL procedures in DB2 Version 8.1 and you upgraded from a 32-bit DB2 Version 8 instance to a DB2 Version 9.7 64-bit instance.
- 32-bit external routines to run on 64-bit instances.
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.