Setting up the DB2 core WLM environments during migration
DB2® stored procedures (except native SQL procedures) must run in WLM-managed stored procedure address spaces. You must assign each stored procedure to a WLM application environment, which routes the stored procedure work to the appropriate WLM-managed address space.
About this task
For DB2-supplied
routines, you can use the provided definitions for core WLM environments
as a starting point for defining your environments. You can also manually
define the WLM environments by using the IWMARIN0 application, as
described in Setting up a WLM application environment for stored procedures during installation.
Exception: You do not need to complete this
configuration task for native SQL procedures unless they call at least
one external stored procedure or external SQL procedure. This task
also applies to native SQL procedures that call at least one user-defined
function or that are defined with ALLOW DEBUG MODE or DISALLOW DEBUG
MODE. Otherwise, this task applies to only user-defined functions,
external stored procedures, external SQL procedures, and DB2-supplied
stored procedures
Procedure
To set up the provided core WLM environments:
Run job DSNTIJRW.
Job DSNTIJRW invokes the DSNTWLMB tool to create the core WLM environments. The CLIST assigns the core WLM environment names in DSNTIJRW according to the values that are specified on panel DSNTIPR1. For detailed information about the environments that are created by DSNTIJRW, see Core WLM environments for DB2-supplied routines.