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:
What to do next
After upgrading your routines, perform the recommended post-upgrade tasks for routines.