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: Start of changeoption 33 on panel DSNTIPBEnd of change
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.