DYNCALCCACHEBLKRELEASE

DYNCALCCACHEBLKRELEASE tells Hyperion Essbase where to store and calculate data blocks that contain Dynamic Calc members when the wait for space in the dynamic calculator cache has exceeded the specified wait time.

Syntax

DYNCALCCACHEBLKRELEASE TRUE¦FALSE

TRUE Tells Hyperion Essbase to make room available in the dynamic calculator cache by temporarily storing inactive blocks in a separate, compressed-block buffer.

FALSE Tells Hyperion Essbase not to find room in the dynamic calculator cache for a different set of blocks. Instead, if allowed by the DYNCALCCACHEONLY setting, Hyperion Essbase performs calculations on these blocks in memory outside the dynamic calculator cache.

The default value is FALSE.

Description

Use the DYNCALCCACHEBLKRELEASE setting to tell Hyperion Essbase to make room available in the dynamic calculator cache, if needed, by compressing inactive blocks from that cache and temporarily storing them in a separate, compressed-block buffer.

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

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 database configuration.

Example

The configuration setting

DYNCALCCACHEBLKRELEASE TRUE

causes Hyperion Essbase to make needed space available in the dynamic calculator cache by compressing inactive blocks and temporarily storing them in a dynamic calculator cache compressed-block buffer.

Notes

The following sequence of events must occur and settings must be defined before Hyperion Essbase releases space in the dynamic calculator cache:

The area allocated in the dynamic calculator cache has reached the maximum allowed (specified by DYNCALCCACHEMAXSIZE).
DYNCALCCACHEWAITFORBLK is set as TRUE and the wait period specified by DYNCALCCACHEBLKTIMEOUT has been reached.
DYNCALCCACHEBLKRELEASE is set as TRUE. Hyperion Essbase releases an area in the dynamic calculator cache by compressing blocks from this cache and storing them temporarily in a compressed-block buffer. The size of this buffer is defined by the DYNCALCCACHECOMPRBLKBUFSIZE configuration setting.

TRUE	Tells Hyperion Essbase to make room available in the dynamic calculator cache by temporarily storing inactive blocks in a separate, compressed-block buffer.
FALSE	Tells Hyperion Essbase not to find room in the dynamic calculator cache for a different set of blocks. Instead, if allowed by the DYNCALCCACHEONLY setting, Hyperion Essbase performs calculations on these blocks in memory outside the dynamic calculator cache.