MXSTPROC—Maximum stored procs
Use the Modify Maximum Stored Procs panel or the MXSTPROC command to specify the maximum number of stored procedure instances that can be in use by a single thread.
Modify Maximum Stored Procs panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : MAXIMUM STORED PROCS
Type the new maximum stored procs value you wish to change to. Then press Enter.
Maximum Stored Procs Parameter
Maximum Stored Procedures. . 0 (0-99999 or delta)
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
value | Maximum number of stored procedure instances that can be open at a given Db2 site per thread. If an application attempts to open a cursor once the maximum number of stored procedures has been reached, the statement will fail. Specify one of the following values:
|
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Max stored procs | DSNTIPX | None | DSN6SPRM | MAX_ST_PROC |