Installation step 19: Configure DB2 for running stored procedures and user-defined functions
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
- 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 installation 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.
