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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » The Database Server » The SQL Anywhere database server » Database server options

-ch server option Next Page

-cl server option

Sets a minimum cache size as a lower limit to automatic cache resizing.


{ dbsrv10 | dbeng10 } -cl { size[ k | m | g | p ] } ...

Applies to

Windows, Unix


This option sets a lower limit to the cache. If you specify an initial cache size with the -c option, then the minimum cache size is the same as the initial cache size. If the initial cache size is not specified, then the default initial cache size is 2 MB on Windows and 8 MB on Unix.

The size is the amount of memory, in bytes. Use k, m, or g to specify units of kilobytes, megabytes, or gigabytes, respectively.

The unit p is a percentage either of the physical system memory, or of the available address space, whichever is lower. Available address space depends on the operating system. For example:

If you use p, the argument is a percentage. You can use % as an alternative to P, but as most non-Unix operating systems use % as an environment variable escape character, you must escape the % character. To set the minimum cache size to 50 percent of the physical system memory, you would use the following:

dbeng10 -cl 50%% ...
See also

The following example starts a server named silver that has a minimum cache size of 5 MB and loads the database file example.db:

dbeng10 -cl 5m -n silver "c:\example.db"