Working With Large Schemas

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.

A diagnostic example includes these switches:

-ca 1
-c 1000m
-o /iq15outputdir/iq15console.out

Note: 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 determines if the setting is appropriate.