ASOLOADBUFFERWAIT

The ASOLOADBUFFERWAIT configuration setting controls the maximum amount of time (in seconds) Essbase waits for aggregate storage cache resources to become available in order to process ASO load buffer operations. If cache resources do not become available within the specified amount of time, Essbase terminates the load buffer operation.

ASOLOADBUFFERWAIT configuration is applicable when you initialize ASO data load buffers using the wait_for_resources option, and applies to allocations, custom calculations, and grid update operations.

This setting applies only to ASO cubes.

Syntax

ASOLOADBUFFERWAIT [appname [dbname]] n

appname—Optional. Specifies the application for which the wait_for_resources option is to be set.

If you specify a value for appname and do not specify a value for dbname, the setting applies to all cubes in the specified ASO application.

To enable the setting for a specific cube, you must specify an application and cube.

If you do not specify an application, you cannot specify a cube, and the setting applies to all ASO applications and cubes on the Essbase Server.
dbname—Optional. Specifies the cube, in the application specified by appname, for which the wait_for_resources option is to be set.

If you specify a value for dbname but do not specify a value for appname, your specification is ignored.
n—Specifies the maximum number of seconds Essbase waits for cache resources to become available.

The default wait value is 10 seconds.

For changes to the configuration to take effect, you must restart the application.

Example

ASOLOADBUFFERWAIT ASOsamp Basic 20

Sets 20 seconds as the maximum wait time for cache resources to become available on the ASOSamp.Basic cube.