Migration step 22: Configure Db2 for running stored procedures and user-defined functions (optional)

This step needs to be performed during installation, and is therefore optional for migration. Before you can use user-defined functions or the following types of stored procedures, you need to perform some set-up tasks:

  • External stored procedures
  • Native SQL procedures that satisfy any of the following conditions:
    • Calls at least one external stored procedure, external SQL procedure, or user-defined function.
    • Defined with ALLOW DEBUG MODE or DISALLOW DEBUG MODE.
  • External SQL procedures (deprecated)
  • Db2-supplied stored procedures

All routines, except native SQL procedures, must run in an environment that is established by the z/OS Workload Manager (WLM). A set of Db2-supplied routines are installed by job DSNTIJRT and validated by job DSNTIJRV as part of the migration process. You can also define your own routines or use routines that are provided by a non-IBM® vendor. Before you can use any stored procedures and user-defined functions, however, you need to set up WLM environments for these routines. If you plan to use certain Db2-supplied stored procedures or user-defined functions, you need to perform some additional steps.