MAX STORED PROCS field (MAX_ST_PROC subsystem parameter)
The MAX_ST_PROC subsystem parameter determines the maximum number of stored procedures that are to be allowed for each thread.
| Acceptable values: | 0–99999 |
|---|---|
| Default: | 2000 |
| Update: | option 47 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM MAX_ST_PROC |
If an application attempts to call a stored procedure after the maximum is reached, the statement will fail.