With large schemas, the default cache settings may be too small and could exhaust dynamic memory in the Sybase IQ 15.2 server. To increase the 15.2 server's cache memory, use the -c server switch. Use the -new_startline to pass this switch to the 15.2 server.
A diagnostic example would includes these switches:
-ca 1 -c 1000m -o /iq15outputdir/iq15console.out
The value shown for -c is in bytes
and arbitrary. Set switches appropriately for your system. To specify
megabytes, use the m suffix, as shown.
The switches in the example perform as follows:
ca 1 – enables dynamic catalog cache sizing, and logs memory cache statistics to the console.
c 1000m – sets initial catalog cache at 1GB.
-o /outputdir/iq15console.out – specifies the log file for console output.
Now you can load -o /outputdir/iq15console.out into your editor and examine the log entries. You can watch how the catalog store adjusts the cache and determine if the settings of 1000m and 2000m are appropriate.
