Specifies the size of a temporary buffer for storing compressed blocks in order to make more space in the dynamic calculator cache.
This setting does not apply to aggregate storage databases.
DYNCALCCACHECOMPRBLKBUFSIZE [appname [dbname]] n
|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.|
In order to make space available in the dynamic calculator cache, Analytic Services uses the value specified by the DYNCALCCACHECOMPRBLKBUFSIZE configuration setting to size the dynamic calculator cache compressed-block buffer. Analytic Services temporarily stores compressed blocks from the dynamic calculator cache into this buffer under the following circumstances:
The dynamic calculator cache compressed-block buffer is an area in memory where Analytic Services compresses and temporarily stores blocks from the dynamic calculator cache to free space for other blocks for other calculations. When space is again available, Analytic Services decompresses blocks stored in the compressed-block buffer and returns them to 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.
Analytic Services uses the temporary compressed-block buffer only when the DYNCALCCACHEBLKRELEASE configuration parameter is set to TRUE and the DYNCALCCACHECOMPRBLKBUFSIZE setting is greater than 0.
causes Analytic Services to set 1,000,000 (one million) bytes as the size for the dynamic calculator cache compressed-block buffer.