RNUM
The RNUM terminal in the MaxL language represents a resource-usage specification for constraining temporary Essbase aggregate storage data load buffers.
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 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