With large schemas, the default cache settings may be too small and could exhaust dynamic memory in the Sybase IQ 15 server. Use the -c server switch to increase the server's cache memory, and the -new_startline to pass this switch to the server.
-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.
-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 determines if the setting is appropriate.