Values for the WLM environment for IBM Data Server Driver for JDBC and SQLJ stored procedures
You need to define an application environment for Db2-supplied stored procedures that support the IBM Data Server Driver for JDBC and SQLJ to WLM.
The following example shows a WLM Definition Menu for an application environment for Db2-supplied stored procedures that support the IBM Data Server Driver for JDBC and SQLJ.
File Utilities Notes Options Help
------------------------------------------------------------------------
Definition Menu WLM Appl
Command ===> ___________________________________________________________
Definition data set . : none
Definition name . . . . DSNWLM_GENERAL
Description . . . . . . Environment for stored procedures for JDBC
Select one of the
following options. . . 9 1. Policies
2. Workloads
3. Resource Groups
4. Service Classes
5. Classification Groups
6. Classification Rules
7. Report Classes
8. Service Coefficients/Options
9. Application Environments
10. Scheduling Environments
- Definition name
- Specify the name of the WLM application environment that you are setting up for stored procedures. The Definition name value needs to match the APPLENV value in the WLM address space startup procedure.
- Description
- Specify any value.
- Options
- Specify 9 (Application Environments).
The following example shows a WLM Create an Application Environment menu with values for the application environment that is used by Db2-supplied stored procedures that support the IBM Data Server Driver for JDBC and SQLJ.
Application-Environment Notes Options Help
------------------------------------------------------------------------
Create an Application Environment
Command ===> ___________________________________________________________
Application Environment Name . : DSNWLM_GENERAL
Description . . . . . . . . . . Environment for stored procedures for JDBC
Subsystem Type . . . . . . . . . DB2
Procedure Name . . . . . . . . . DSN8WLMG
Start Parameters . . . . . . . . DB2SSN=DB2T,NUMTCB=40,APPLENV=WLMENV
_______________________________________
___________________________________
Limit on starting server address spaces for a subsystem instance:
1 1. Managed by WLM
2. Single address space per system
3. Single address spaces per sysplex
- Subsystem Type
- Specify Db2.
- Procedure Name
- Specify a name that matches the name of the JCL startup procedure for the stored procedure address spaces that are associated with this application environment.
- Start Parameters
- If the Db2 subsystem in which the stored procedure runs is not in a sysplex, specify a DB2SSN value that matches the name of that Db2 subsystem. If the same JCL is used for multiple Db2 subsystems, specify DB2SSN=&IWMSSNM. Specify a NUMTCB value between 40 and 60. Specify an APPLENV value that matches the value that you specify in the WLM address space startup procedure and on the CREATE PROCEDURE statements for the stored procedures.
- Limit on starting server address spaces for a subsystem instance
- Specify 1 (Managed by WLM).