Specifying the number of stored procedures that can run concurrently

Multiple stored procedures can run concurrently, each under its own z/OS® task control block (TCB). The z/OS Workload Manager (WLM) manages how many concurrent stored procedures can run in an address space. The number of concurrent stored procedures in an address space cannot exceed the value of the NUMTCB field that was specified on the DSNTIPX installation panel, during Db2 installation.

Procedure

You can override that value in the following ways:

Edit the JCL procedures that start stored procedures address spaces, and modify the value of the NUMTCB parameter.
Specify the following parameter in the Start Parameters field of the Create An Application Environment panel when you set up a WLM application environment:
```
NUMTCB=number-of-TCBs
```
Special cases:
- For REXX stored procedures, you must set the NUMTCB parameter to 1.
- Stored procedures that invoke utilities can invoke only one utility at a time in a single address space. Consequently, the value of the NUMTCB parameter is forced to 1 for those procedures.