INDEXCACHESIZE

INDEXCACHESIZE defines the initial value for the index cache size for any new databases that are created after Hyperion Essbase is restarted. The index cache is a buffer in memory that holds index pages. Hyperion Essbase allocates this memory at startup of the database.

Syntax

INDEXCACHESIZE n

n

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

Minimum value: 1 megabyte (1 M)

Maximum value: 2 gigabytes (2 G)

Default value: 10 megabytes (10 M)

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).

Description

INDEXCACHESIZE specifies, in bytes, kilobytes, megabytes, or gigabytes, the size of the index cache for new databases on the server. The specified value takes effect for all new databases that are created after the server is started. To set or change the index cache size for an individual database, choose Database > Settings in the Application Manager and select the Storage tab, or issue SetDbStateItem in ESSCMD. For more information, see the online help or HTML documentation for those items.

Example

INDEXCACHESIZE 100M

causes Hyperion Essbase to define the the index cache size of all subsequently created databases as 100 megabytes.