INDEXCACHESIZE

This configuration setting defines the value for the index cache size for Essbase cubes.

The index cache is a buffer in memory that holds index pages. Essbase allocates this memory at startup of the cube.

The value of the index cache size can be expressed in bytes, kilobytes, megabytes, or gigabytes. Terabytes must be expressed in gigabytes.

This setting does not apply to aggregate storage cubes.

Syntax

INDEXCACHESIZE n

n—An integer value expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G):

• Minimum value: 1 megabytes (1M)

• Maximum value: 256TB

• Default value: 100M

If a value is given without a B, K, M, or G qualifier, it is assumed the value is in bytes.

The qualifier can be in upper or lowercase and can be entered adjacent to the value (10M) or separated by a space (10 M).

Example

INDEXCACHESIZE 200M

Sets the index cache size of cubes to 200 megabytes.