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

-cc server option Next Page

-ch server option


Sets a maximum cache size, as a limit to automatic cache growth.

Syntax

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

Applies to

Windows, Unix

Remarks

This option limits the size of the database server cache during automatic cache growth. By default the upper limit is approximately the lower of available address space and 90% of the physical memory of the computer.

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 -ch 50%% ...
See also
Example

The following example starts a server named silver that has a maximum cache size of 2 MB and loads the sample database:

dbeng10 -ch 2m -n silver "samples-dir\demo.db"

For information about samples-dir, see Samples directory.