Specifies 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 setting applies to the creation of aggregate storage data load buffers with the wait_for_resources option, and applies to allocations, custom calculations, and lock and send operations.
This setting applies only to aggregate storage databases.
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 databases in the specified application.
To enable the setting for a specific database, you must specify an application and database.
If you do not specify an application, you cannot specify a database, and the setting applies to all applications and databases on Essbase Server.
dbname—Optional. Specifies the database, 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 file to take effect, you must restart Essbase Server.
ASOLOADBUFFERWAIT ASOsamp Sample 20
Sets 20 seconds as the maximum wait time for cache resources to become available on the ASOSamp.Sample database.
Alter Database (Aggregate Storage) MaxL statement