Listing Aggregate Storage Data Load Buffers

The query database MaxL statement for ASO lists data load buffers that have been initialized to load data into an Essbase aggregate storage database.

Use the following MaxL statement to get a list and description of the data load buffers that exist on an aggregate storage database.

query database appname.dbname list load_buffers;

This statement returns the following information about each existing data load buffer:

Table 3-26 List Load Buffers MaxL Output Columns

Field	Description
buffer_id	ID of a data load buffer (a number between 1 and 4294967296).
internal	A Boolean that specifies whether the data load buffer was created internally by Essbase (TRUE) or by a user (FALSE).
active	A Boolean that specifies whether the data load buffer is currently in use by a data load operation.
resource_usage	The percentage (a number between .01 and 1.0 inclusive) of the aggregate storage cache that the data load buffer is allowed to use.
aggregation method	One of the methods used to combine multiple values for the same cell within the buffer: AGGREGATE_SUM: Add values when the buffer contains multiple values for the same cell. AGGREGATE_USE_LAST: Combine duplicate cells by using the value of the cell that was loaded last into the load buffer.
ignore_missings	A Boolean that specifies whether to ignore #MI values in the incoming data stream.
ignore_zeros	A Boolean that specifies whether to ignore zeros in the incoming data stream.