-iqmc iqsrv16 Server Option

Specifies the main IQ store cache size, in MB.

Syntax

-iqmc size

Default

64MB

Remarks

Always specify the size value, without including the units of measurement; for example, specify 32 rather than 32MB. If you specify the unit of measurement, start_iq ignores this switch, unlike SQL Anywhere, which requires a unit of measurement.

The switch overrides the default value of 64MB, and applies to all databases started from the time the server is started until the server is shut down. In other words, if you start one database at server startup and another later, you need 2 * -iqmc available for the main cache.

Large memory requirements represent one third of all available physical memory. To ensure adequate memory for the main store, set the –iqmc startup parameter to one third of all available physical memory.
Note: Do not run multiple databases with an SAP Sybase IQ server.