DYNCALCCACHECOMPRBLKBUFSIZE configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

DYNCALCCACHECOMPRBLKBUFSIZE  [appname [dbname]] n

• appname—If you specify an application name, the setting applies to all cubes within the application. If you do not specify an application name, the setting applies to all applications and cubes on the server.

• dbname—If you specify a database (cube) name, the setting applies only to this cube. If you do not also specify an application name, the setting applies to all applications and cubes on the server.

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

  • Minimum value: 0 megabytes (0 M). If the value is 0, Essbase does not use the compressed block buffer.

  • Default value: 1 megabyte (1M, which is ~1,000,000 bytes)

  • 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 (1M)

Description

Using the dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations. The size of the improvement depends on your configuration.

The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Essbase allocates memory in the dynamic calculator cache to store these blocks during retrievals or calculations that involve dynamically calculated members.

The dynamic calculator cache compressed-block buffer is an area in memory where Essbase compresses and temporarily stores blocks from the dynamic calculator cache to free space for other blocks for other calculations. When space is again available, Essbase decompresses blocks stored in the compressed-block buffer and returns them to the dynamic calculator cache.

In order to make space available in the dynamic calculator cache, Essbase uses the value specified by the DYNCALCCACHECOMPRBLKBUFSIZE configuration to size the dynamic calculator cache compressed-block buffer. Essbase temporarily stores compressed blocks from the dynamic calculator cache into this buffer under the following circumstances:

• The area allocated in the dynamic calculator cache has reached the maximum allowed (specified by DYNCALCCACHEMAXSIZE) and Essbase requires additional space for blocks to be calculated in the current query.

• DYNCALCCACHEWAITFORBLK is set to TRUE and the wait period specified by DYNCALCCACHEBLKTIMEOUT has been reached.

• DYNCALCCACHEBLKRELEASE is set to TRUE, indicating Essbase should release dynamic calculator cache area.

Notes

Essbase uses the temporary compressed-block buffer only when the DYNCALCCACHEBLKRELEASE configuration parameter is set to TRUE and the DYNCALCCACHECOMPRBLKBUFSIZE setting is greater than 0.

Example

DYNCALCCACHECOMPRBLKBUFSIZE 1000000

Sets 1,000,000 (one million) bytes as the size for the dynamic calculator cache compressed-block buffer.

See Also

DYNCALCCACHEMAXSIZE

DYNCALCCACHEONLY

DYNCALCCACHEWAITFORBLK

DYNCALCCACHEBLKTIMEOUT

DYNCALCCACHEBLKRELEASE