-ca iqsrv16 database server option

Enforces a static cache size.

Syntax

iqsrv16 -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.

Example

The following example starts a database server named myserver that has a static cache that is 40% of the total physical memory and loads the sample database, and the database server does not automatically adjust the cache size:

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
      @$IQDIR16/demo/iqdemo.cfg -c 40P -ca 0
    $IQDIR16/demo/iqdemo.db