DATAFILECACHESIZE

Parameters

DATAFILECACHESIZE defines the initial value for the data file cache size for all new databases that are created after Hyperion Essbase is restarted. The data file cache is a buffer in memory that holds data files. Hyperion Essbase allocates this memory during data load, calculation, and retrieval operations, as needed.

Syntax

DATAFILECACHESIZE n

n

An integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G) Minimum value: 8 megabytes (8 M) Maximum value: 2 gigabytes (2 G) Default value: 32 megabytes (32 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

DATAFILECACHESIZE specifies, in bytes, kilobytes, megabytes, or gigabytes, the size of the data file 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 data file 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

DATAFILECACHESIZE 800M

causes Hyperion Essbase to define the the data file cache size of all subsequently created databases as 800 megabytes.