DYNCALCCACHECOMPRBLKBUFSIZE

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.

Syntax

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, Analytic Services 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)

Description

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.

Notes

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.

Example

DYNCALCCACHECOMPRBLKBUFSIZE 1000000
causes Analytic Services to set 1,000,000 (one million) bytes as the size for the dynamic calculator cache compressed-block buffer.

See Also

DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEWAITFORBLK
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHEBLKRELEASE