MAX OPEN CURSORS field (MAX_NUM_CUR subsystem parameter)
The MAX_NUM_CUR subsystem parameter specifies the maximum number of cursors, including allocated cursors, that can be open at a given Db2 site for each thread.
| Acceptable values: | 0–99999 |
|---|---|
| Default: | 500 |
| Update: | option 47 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM MAX_NUM_CUR |
Db2 keeps a count of currently open cursors. If an application attempts to open a thread after the maximum is reached, the statement will fail.