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.
n—An integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G)
Minimum value: 0 megabytes (0 M). If the value is 0, Essbase does not use the compressed block buffer.
Default value: 1 megabyte (1M, which is 1,048,576 bytes)
If a value is given without a B, K, M, or G qualifier, it is assumed the value is in bytes.
The qualifier can be in upper or lowercase and can be entered adjacent to the value (10M) or separated by a space (1M)
In order to make space available in the dynamic calculator cache, Essbase uses the value specified by the DYNCALCCACHECOMPRBLKBUFSIZE configuration setting to size the dynamic calculator cache compressed-block buffer. Essbase temporarily stores compressed blocks from the dynamic calculator cache into this buffer under the following circumstances:
The area allocated in the dynamic calculator cache has reached the maximum allowed (specified by DYNCALCCACHEMAXSIZE) and Essbase requires additional space for blocks to be calculated in the current query.
DYNCALCCACHEWAITFORBLK is set to TRUE and the wait period specified by DYNCALCCACHEBLKTIMEOUT has been reached.
DYNCALCCACHEBLKRELEASE is set to TRUE, indicating Essbase should release dynamic calculator cache area.
The dynamic calculator cache compressed-block buffer is an area in memory where Essbase compresses and temporarily stores blocks from the dynamic calculator cache to free space for other blocks for other calculations. When space is again available, Essbase 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. 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.
Essbase uses the temporary compressed-block buffer only when the DYNCALCCACHEBLKRELEASE configuration parameter is set to TRUE and the DYNCALCCACHECOMPRBLKBUFSIZE setting is greater than 0.
DYNCALCCACHECOMPRBLKBUFSIZE 1000000
Sets 1,000,000 (one million) bytes as the size for the dynamic calculator cache compressed-block buffer.