The specification must be a number between .01 and 1.0 inclusive. If not specified, the default value is 1.0. Only two digits after the decimal point are significant (for example, 0.029 is interpreted as 0.02). The total resource usage of all load buffers created on a database cannot exceed 1.0 (for example, if a buffer of size 0.9 exists, you cannot create another buffer of a size greater than 0.1). Send operations internally create load buffers of size 0.2; therefore, a load buffer of the default size of 1.0 will cause send operations to fail because of insufficient load buffer resources.

Type

number (see MaxL Syntax Notes)

Example

The specified resource_usage and the actual resource usage of the aggregate storage cache will be different, depending on how many threads you specify in ASOCACHECONCURRENTCONSUMINGTHREADS. The formula to calculate actual resource usage is:

 (1/ASOCACHECONCURRENTCONSUMINGTHREADS)*resource_usage

The actual aggregate-storage cache size Essbase allocates, in megabytes, is calculated as:

ASODEFAULTCACHESIZE*actual resource usage

Assume the following configurations are set for the cube:

ASOCACHECONCURRENTCONSUMINGTHREADS 5
ASODEFAULTCACHESIZE 500

With the above settings, you can initialize up to 5 data load buffers, specifying, for each, the maximum resource_usage of 1.0.

Using the following MaxL statements, you initialize three load buffers:

alter database AsoSamp.Basic initialize load_buffer with buffer_id 1 resource_usage 1.0;
alter database AsoSamp.Basic initialize load_buffer with buffer_id 2 resource_usage 0.5;
alter database AsoSamp.Basic initialize load_buffer with buffer_id 3 resource_usage 0.1;

The following MaxL statement displays the actual resource usage:

query database AsoSamp.Basic list load_buffers;
buffer_id internal active resource_usage aggregation_method ignore_missings ignore_zeros
----------------------------------------------------------------------------------------+
1 	  FALSE    FALSE  	     0.2  AGGREGATE_SUM      FALSE 	    FALSE
2 	  FALSE    FALSE  	     0.1  AGGREGATE_SUM      FALSE 	    FALSE
3 	  FALSE    FALSE 	     0.02 AGGREGATE_SUM      FALSE 	    FALSE

Referenced By

alter database (aggregate storage), when initializing load buffers