-c iqsrv16 Server Option

Sets initial memory reserved for caching catalog store pages and other server information.

Syntax

-c cache-size[ k| m| g| p]

Remarks

The database server uses extra memory for caching database pages if the memory is set aside in the cache. Any cache size less than 10000 is assumed to be KB (1K = 1024 bytes). Any cache size 10000 or greater is assumed to be in bytes. You can also specify the cache size nK, nM or nP (1M = 1024 KB), where P is a percentage of the physical system memory.

In the default.cfg file, the default value of -c and start_iq is 32MB (-c 32M) for Windows platforms, and 48MB (-c 48M) for UNIX platforms.Use this default or set -c to a higher value.

You can use % as an alternative to P, but as most non-UNIX operating systems use % as an environment variable escape character, you must escape the % character. For example, to use 20 percent of the physical system memory, specify:

start_iq -c 20%% ...

Do not use -c in the same configuration file or command line with -ch or -cl. For related information, see the -ch cache-size option and the -ca 0 option.