-ch iqsrv16 Server Option

Set catalog store cache size upper limit in bytes.

Syntax

-ch size[ k| m| g| p]

Remarks

By default, the upper limit is approximately the lower of 256MB and 90% of the physical memory of the machine.

You specify the cache-size using the K, M, and P characters as in the -c option. For the meaning and usage of the cache size argument and the K, M, and P characters, see -c cache-size.

In some cases the standard catalog cache size may be too small, for example, to accommodate certain queries that need a lot of parsing. In these cases, you may find it helpful to set -cl and -ch. For example, on 32-bit platforms, try these settings:

-cl 128M
-ch 512M

Warning! To control catalog store cache size explicitly, you must do either of the following, but not both, in your configuration file (.cfg) or on the UNIX command line for server startup:

Set the -c parameter.
Set specific upper and lower limits for the catalog store cache size using the -ch and -cl parameters.

Specifying different combinations of the parameters above can produce unexpected results.