ASA Database Administration Guide
The Database Server
The database server
Database server options
Enforces a static cache size. The zero argument is required.
{ dbsrv9 | dbeng9 } -ca 0 ...
Windows NT/2000/XP, Windows 95/98/Me, UNIX
You can disable automatic cache increase due to high server load by specifying -ca
0 on the command line. If you do not set -ca
0, the database server automatically takes additional cache as needed. The cache size still increases if the database server would otherwise run into the error Fatal Error: dynamic memory exhausted
, or if the Java VM requires memory that would lead to a fatal error.
This server option should be used only in the form -ca
0. If -ca
is omitted, automatic cache growth is enabled.
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:
dbsrv9 -c 40P -ca 0 -n myserver "C:\Program Files\Sybase\SQL Anywhere 9\asademo.db"