DYNCALCCACHEBLKTIMEOUT

Specifies maximum time to wait for free space in the dynamic calculator cache.

This setting does not apply to aggregate storage databases.

Syntax

DYNCALCCACHEBLKTIMEOUT [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  A number of seconds. May or may not include a decimal point. Any number less than 0.001 will be treated as 0.001. The default value is 10 seconds.

Description

Use this setting to specify the maximum number of seconds that Analytic Services should wait for space in the dynamic calculator cache in order to perform the requested calculation there. If Analytic Services waits the entire number of seconds specified in this setting, it then checks the DYNCALCCACHEBLKRELEASE setting to determine what to do next:

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

Example

DYNCALCCACHEBLKTIMEOUT 20
causes Analytic Services to wait up to 20 seconds for space in the dynamic calculator cache before checking the DYNCALCCACHEBLKRELEASE setting to determine the next step to take before performing the requested calculation.

See Also

DYNCALCCACHEMAXSIZE
DYNCALCCACHEONLY
DYNCALCCACHEWAITFORBLK
DYNCALCCACHEBLKRELEASE
DYNCALCCACHECOMPRBLKBUFSIZE