Upgrading routines

Upgrading your existing routines to Db2® version 12.1 involves managing the changes between Db2 version 12.1 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, re-create your external routines in the database, and re-create SQL routines.

Test your routines in a Db2 version 12.1 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 12.1, or to use new functionality.

Before you begin


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 12.1 databases:

  1. If you identified changes in Db2 version 12.1 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

  2. If you identified changes specific to the development environment that impact your routines, modify them to support these changes. Upgrade your:
  3. Rebuild all changed external routine libraries or if you performed operating system or development software upgrades.
  4. Test your routines to verify your changes and to ensure that the routines run as expected using Db2 version 12.1.

What to do next

After upgrading your routines, perform the recommended post-upgrade tasks for routines.