DYNCALCCACHEONLY

Specifies whether dynamic calculations can use memory outside the dynamic calculator cache in the case that it is full.

This setting does not apply to aggregate storage databases.

Syntax

DYNCALCCACHEONLY [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 Disallows the use of memory outside the dynamic calculator cache. If space for blocks with dynamically calculated members cannot be obtained from the dynamic calculator cache, Analytic Services generates an error message.
 FALSE Allows the use of memory outside the dynamic calculator cache, if necessary, for blocks containing dynamically calculated members. The default value is FALSE.

Description

When no room is available in the dynamic calculator cache, the DYNCALCCACHEWAITFORBLK and DYNCALCCACHECOMPRBLKBUFSIZE configuration settings provide options that could result in Analytic Services using memory outside the dynamic calculator cache to store blocks that contain dynamically calculated members. If you are experiencing a severe memory shortage, you can use the DYNCALCCACHEONLY setting to disallow the use of memory outside the dynamic calculator cache. If DYNCALCCACHEONLY is set to TRUE, instead of using memory outside the dynamic calculator cache, Analytic Services generates the error message, "Allocation outside the dynamic calculator cache is disallowed."

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

The default value of this setting is FALSE. Only set this value to TRUE for one or more of the following circumstances:

Example

DYNCALCCACHEONLY TRUE
specifies that the dynamic calculator cache is the only memory area that Analytic Services may use to store blocks that contain dynamically calculated blocks. If a retrieval requires space that is not available in the dynamic calculator cache, the execution of the retrieval is aborted. The user sees an error message that is also posted to the application log.

See Also

DYNCALCCACHEMAXSIZE
DYNCALCCACHEWAITFORBLK
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHECOMPRBLKBUFSIZE
DYNCALCCACHEBLKRELEASE