Start of change

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

Start of changeThis 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:End of change
  • External stored procedures
  • External SQL procedures
  • Native SQL procedures that satisfy at least one of the following conditions:
    • The native SQL procedure calls at least one external stored procedure, external SQL procedure, or user-defined function.
    • The native SQL procedure is defined with ALLOW DEBUG MODE or DISALLOW DEBUG MODE.
  • 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.

End of change