Specifies whether Essbase should wait for memory to be freed in the dynamic calculator cache, or use outside memory.
This setting does not apply to aggregate storage databases.
DYNCALCCACHEWAITFORBLK [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 wait for memory to be freed in the dynamic calculator cache.
FALSE—This is the default. If allowed by the DYNCALCCACHEONLY setting, tells Essbase attempt to perform calculations on these blocks in memory outside the dynamic calculator cache.
If the DYNCALCCACHEONLY setting is TRUE, tells Essbase to generate an error message instead of using memory outside the dynamic calculator cache.
Use this setting to set or change how Essbase handles the situation when it needs additional memory to store blocks in the dynamic calculator cache for the database.
When the setting is TRUE, Essbase waits to store and calculate data blocks in the dynamic-calculator-cache area that is currently in use by other queries.
When the setting is FALSE, if the DYNCALCCACHEONLY setting is also FALSE, instead of waiting for area in the dynamic calculator cache, Essbase attempts to store and calculate data blocks for the current query in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, Essbase generates an error message instead of using memory outside the dynamic calculator cache.
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.
Use the DYNCALCCACHEBLKTIMEOUT setting to specify the maximum number of seconds that Essbase waits for space in the dynamic calculator cache.
DYNCALCCACHEONLY FALSE DYNCALCCACHEWAITFORBLK FALSE
Essbase attempts to perform the block calculation in memory outside the dynamic calculator cache, instead of waiting for space to become available in the dynamic calculator cache.