-ca iqsrv15 server option

Enforces a static cache size.

Syntax

iqsrv15 -ca 0 ...

Applies to

Windows, Unix

Remarks

You can disable automatic cache size tuning by specifying -ca 0 option. If you do not include the -ca 0 option, the database server automatically increases the cache size. If you specify this option, the cache size is still adjusted if the database server would otherwise run into an error indicating that the dynamic memory is exhausted.

This server option must only be used in the form -ca 0.

This option is ignored if you are using an AWE cache.

Note: The use of AWE is deprecated. It is recommended that you use the 64-bit version of the database server on a 64-bit Windows operating system if you require a large cache.

Example

start_iq @iqdemo.cfg iqdemo.db

The following example is for Windows:

start_iq @"%
      ALLUSERSPROFILE%\SybaseIQ\demo\iqdemo.cfg"   -c 40P
      -ca
    0 -n myserver "%
      ALLUSERSPROFILE%\SybaseIQ\demo\iqdemo.db"

The following example is for Unix:

start_iq
      @$IQDIR15/demo/iqdemo.cfg -c 40P -ca 0
    $IQDIR15/demo/iqdemo.db