DB2 Version 9.7 for Linux, UNIX, and Windows

Upgrading .NET CLR routines

Upgrading your existing .NET CLR routines involves managing the changes between DB2® Version 9.7 and previous releases that impact these routines and verifying that they function as expected.

Before you begin

Review the Upgrade essentials for routines to identify key changes that might apply to your .NET CLR routines.
Ensure that you have access to a DB2 Version 9.7 server, including instances and databases. The DB2 server can be part of a testing environment.
Ensure that a supported version of the Microsoft .NET Framework software is installed on the DB2 server.
Perform the previous steps in the Upgrading routines task.

Procedure

To upgrade your .NET CLR routines to DB2 Version 9.7:

Connect to the DB2 Version 9.7 database in which you defined the .NET CLR routines.
If you created your .NET CLR routines with execution control mode UNSAFE and you are upgrading from pre-Version 9.7 32-bit instance to Version 9.7 64-bit instance, rebuild their source code using the compile and link options specified in bldrtn.bat, the DB2 sample script for building .NET CLR routines.
If you upgraded your .NET Framework, you should also rebuild your .NET CLR routines.
Deploy the routine assembly to the DB2 server in the same location specified by the EXTERNAL clause in the routine definition. The routines should function successfully, with no differences in between previous releases and DB2 Version 9.7.

What to do next

After upgrading your .NET CLR routines, perform the remaining steps in the Upgrading routines task.