DYNCALCCACHEBLKRELEASE

This configuration setting enables Essbase to create a temporary buffer for dynamic calculations in cases where the wait for space in the dynamic calculator cache has exceeded the specified wait time.

This setting does not apply to aggregate storage cubes.

Syntax

DYNCALCCACHEBLKRELEASE [appname [dbname]] TRUE | FALSE

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.
TRUE—Tells Essbase to make room available in the dynamic calculator cache by temporarily storing inactive blocks in a separate, compressed-block buffer.
FALSE—This is the default value. Tells Essbase not to find room in the dynamic calculator cache for a different set of blocks. Instead, if allowed by the DYNCALCCACHEONLY setting, Essbase attempts to perform calculations on these blocks in memory outside the dynamic calculator cache.

Description

Use this setting to tell Essbase to make room available in the dynamic calculator cache, if needed, by compressing inactive blocks from that cache and attempting to temporarily store 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. 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 configuration.

Notes

The following sequence of events must occur and settings must be defined before 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 to TRUE. Essbase releases an area in the dynamic calculator cache by compressing blocks from this cache and attempting to store them temporarily in a compressed-block buffer. The size of this buffer is defined by the DYNCALCCACHECOMPRBLKBUFSIZE configuration setting.

Example

DYNCALCCACHEBLKRELEASE TRUE

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