Listing Data Load Buffers for an Aggregate Storage Database

Multiple data load buffers can exist on an aggregate storage database. For a list and description of the data load buffers that exist on an aggregate storage database, use the query database MaxL statement with the list load_buffers grammar:

query database appname.dbname list load_buffers;

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

Table 205. Data Load Buffer Information

FieldDescription

buffer_id

ID of a data load buffer (a number between 1 and 4,294,967,296).

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.