-iqgovern iqsrv16 Server Option

Sets the number of concurrent queries allowed by the server.

Syntax

-iqgovern num

Remarks

The number of concurrent queries is not the same as the number of connections. A single connection can have multiple open cursors. -iqgovern can help SAP Sybase IQ optimize paging of buffer data out to disk and avoid overcommitting memory. The default value of this switch is equal to 2 times the number of CPUs on your machine, plus 10. You may find that another value, such as 2 times the number of CPUs plus 4, provides better throughput, especially when large numbers of users are connected.