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 to 99999 |
Default: | 500 |
Update: | ![]() ![]() |
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.