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

Procedure

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

  1. Connect to the DB2 Version 9.7 database in which you defined the .NET CLR routines.
  2. 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.

  3. 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.