Setting the Number of CPUs Available

Set the -iqnumbercpus startup switch to specify the number of CPUs available. This parameter overrides the physical number of CPUs for resource planning purposes.

Using the -iqnumbercpus switch is recommended only:

See “Setting the number of CPUs” in System Administration Guide: Volume 1 > Running Sybase IQ.

Related concepts
Restricting Concurrent Queries
Limiting Temporary dbspace Use By a Query
Limiting Queries by Rows Returned
Forcing Cursors to be Non-Scrolling
Limiting the Number of Cursors
Limiting the Number of Statements
Prefetching Cache Pages
Optimizing for Typical Usage
Controlling the Number of Prefetched Rows