Specifies IQ temporary store cache size, in MB.
-iqtc size
64MB
The switch overrides the default value of 64MB, and applies to all databases started from the time the SAP Sybase IQ 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 * -iqtc available for the temp cache. In general, avoid running multiple databases with an SAP Sybase IQ server.
Large memory requirements represent one third of all available physical memory. To ensure adequate memory for the IQ temporary store cache, set the –iqtc startup parameter to one third of all available physical memory.
Always specify the size value, without including the units of measurement; for example, specify -iqtc 32 instead of -iqtc 32MB. If you specify the unit of measurement, start_iq ignores this switch, unlike SQL Anywhere, which requires a unit of measurement.
Ensure that the IQ_SYSTEM_TEMP dbspace is at least as large as -iqtc.