Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » The database server » Database server options

 

-ca server option

Enforces a static cache size.

Syntax
{ dbsrv11 | dbeng11 } -ca 0 ...
Applies to

Windows, Unix, Mac OS X

Remarks

You can disable automatic cache increase because of high server load by specifying -ca 0 on the command line. If you do not include the -ca 0 option, the database server automatically increases the cache size. The cache size still increases if the database server would otherwise run into the error Fatal Error: dynamic memory exhausted.

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

This option is ignored if you are using an AWE cache. You can use the -cw option to create a larger cache using AWE. See -cw server option.

See also
Example

The following example starts a server named myserver that has a static cache that is 40% of the available physical memory and loads the sample database:

dbsrv11 -c 40P -ca 0 -n myserver "samples-dir\demo.db"

For information about samples-dir, see Samples directory.