Defines the initial value for the data cache size for any new databases that are created after Essbase is restarted. The data cache is a buffer in memory that holds data blocks. Essbase allocates this memory during data load, calculation, and retrieval operations, as needed.
This setting does not apply to aggregate storage databases.
DATACACHESIZE nWhere n is an integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G):
Minimum value: 3 megabytes (3 M)
Maximum value: 2 gigabytes (2 G)
Default value: 3 megabytes (3 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).
DATACACHESIZE specifies, in bytes, kilobytes, megabytes, or gigabytes, the size of the data 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 cache size for an individual database, use Administration Services or MaxL. For more information, see the online help or HTML documentation for those components.
DATACACHESIZE 90M
Sets the data cache size of all newly created or migrated databases as 90 megabytes.