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
Field | Description |
---|---|
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:
|
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. |