-cl iqsrv16 database server option

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

Syntax

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

Default

2 MB on Windows

8 MB on Unix

Applies to

Windows, Unix

Remarks

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 supported cache size, whichever is lower. The maximum supported 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 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:

iqsrv16 -cl 50%% ...

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 supported cache size.

Example

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:

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