DYNCALCCACHEWAITFORBLK

Specifies whether Analytic Services 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.

Syntax

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 Analytic Services to wait for memory to be freed in the dynamic calculator cache.
 FALSE  
  • This is the default. If allowed by the DYNCALCCACHEONLY setting, tells Analytic Services attempt to perform calculations on these blocks in memory outside the dynamic calculator cache.
  • If the DYNCALCCACHEONLY setting is TRUE, tells Analytic Services to generate an error message instead of using memory outside the dynamic calculator cache.

Description

Use this setting to set or change how Analytic Services handles the situation when it needs additional memory to store blocks in the dynamic calculator cache for the database.

When the setting is TRUE, Analytic Services 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, Analytic Services attempts to store and calculate data blocks for the current query in memory outside the dynamic calculator cache. If the DYNCALCCACHEONLY setting is TRUE, Analytic Services 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. Analytic Services 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.

Notes

Use the DYNCALCCACHEBLKTIMEOUT setting to specify the maximum number of seconds that Analytic Services waits for space in the dynamic calculator cache.

Example

DYNCALCCACHEONLY FALSE
DYNCALCCACHEWAITFORBLK FALSE
Analytic Services 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.

See Also

DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHEBLKRELEASE
DYNCALCCACHECOMPRBLKBUFSIZE