-iqmc iqsrv16 Server Option

Specifies the main IQ store buffer cache size, in MB.

Syntax

-iqmc size

Default

64MB

Remarks

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 buffer 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.

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

Note: Do not run multiple databases with an SAP Sybase IQ server.