With large schemas, the default cache settings may be too small and could exhaust dynamic memory in the Sybase IQ 15.4 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
-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.