When performing an incremental data load, Essbase uses the aggregate storage cache for sorting data. You can control the amount of the cache a data load buffer can use by specifying the percentage . The percentage is a number between .01 and 1.0 inclusive; only two digits after the decimal point are significant—for example, 0.029 is interpreted as 0.02. By default, the resource usage of a data load buffer is set to 1.0, and the total resource usage of all data 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.
Note: | 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 data load buffer resources. |
To set the amount of resources the buffer is allowed to use, use the alter database MaxL statement with the resource_usage grammar.
For example, to set the resource_usage to 50% of the total cache, use this statement:
alter database AsoSamp.Sample initialize load_buffer with buffer_id 1 resource_usage .5;
If you plan to run concurrent send operations, use the ASOLOADBUFFERWAIT configuration setting and the alter database MaxL statement with the wait_for_resources grammar. ASOLOADBUFFERWAIT 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.