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 databases.
DYNCALCCACHEBLKRELEASE [appname [dbname]] TRUE | FALSE
appname—If you supply an application name, the setting applies to all databases within the application. If you do not supply an application name, the setting applies to all applications and databases on the server.
dbname—If you supply a database name, the setting applies only to the database. If you do not also provide an application name, the setting applies to all applications and databases 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
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 database configuration.
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.
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.