Enables Analytic Services 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 Analytic Services 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 Analytic Services not to find room in the dynamic calculator cache for a different set of blocks. Instead, if allowed by the DYNCALCCACHEONLY setting, Analytic Services attempts to perform calculations on these blocks in memory outside the dynamic calculator cache.|
Use this setting to tell Analytic Services 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. 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.
The following sequence of events must occur and settings must be defined before Analytic Services releases space in the dynamic calculator cache:
causes Analytic Services 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.