-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 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, available physical memory limits 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.

For example, to set the minimum cache size to 50 percent of the physical system memory, run the following command:

dbeng12 -cl 50%% ...

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

Note

If you attempt to set your initial or minimum cache sizes to a value that is less than one eighth of the maximum cache size, the initial and minimum cache sizes are automatically increased relative to the maximum cache size.

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

Note

See also

Example