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 load buffer operations.

If cache resources do not become available within the specified amount of time, Essbase aborts the load buffer operation.

This configuration setting applies to the initialization of aggregate storage data load buffers with the wait_for_resources option, and applies to allocations, custom calculations, and grid update operations.

This setting applies only to aggregate storage 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 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 applications and cubes on 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 value is 10 seconds.

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

Example

ASOLOADBUFFERWAIT ASOsamp Basic 20

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

See Also

alter database MaxL statement