SQL Open Cursors (-SQLCursors)

Use SQL Open Cursors (-SQLCursors) to define the maximum number of cursors open at any one time.

Operating system and syntax UNIX / Windows -SQLCursors value
Use with Maximum value Minimum value Single-user default Multi-user default
SQL 512 10 50
value
Number of cursors open at one time.

The SQL Open Cursors (-SQLCursors) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.