-cl dbeng12/dbsrv12 server option

{ dbeng12 | dbsrv12 } -cl { size[ k | m | g | p ] } ...

2 MB on Windows

8 MB on Unix

Windows, Unix, Mac OS X

This option sets a lower limit to the cache. If -c is specified, and -cl is not specified, then the minimum cache size is set to the initial cache size (the -c setting). If neither -c nor -cl is set, the minimum cache set is set to a low, constant value, so that the cache can shrink if necessary. On Windows platforms this value is 2 MB.

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 maximum non-AWE cache size, whichever is lower. The maximum non-AWE cache size depends on the operating system. For example:

2.5 GB for Windows 32-bit Advanced Server, Enterprise Server and Datacenter Server
3.5 GB for the 32-bit database server running on Windows x64 Edition
1.5 GB on all other 32-bit systems
On Windows Mobile, the cache size is limited by available physical memory
On 64-bit database servers, the cache size can be considered unlimited

If you use p, the argument is a percentage. You can use % as an alternative to p, but on Windows, which uses % 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:

dbeng12 -cl 50%% ...

This option is ignored if you are using an AWE cache. See -cw dbeng12/dbsrv12 server option (deprecated).

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

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

-cl dbeng12/dbsrv12 server option

Syntax

Default

Applies to

Remarks

See also

Example