ASOBUFFERCOMMITWAIT

The Essbase configuration setting ASOBUFFERCOMMITWAIT defines what should happen if someone attempts to commit an aggregate storage (ASO) data load buffer at the same time as another buffer is being committed. If set to TRUE, concurrent commit attempts should wait. If set to FALSE, they should fail.

Syntax

ASOBUFFERCOMMITWAIT [appname] TRUE | FALSE
  • TRUE—The next concurrent ASO load buffer commit attempt waits until the previous operation completes.

  • FALSE—The next concurrent ASO load buffer commit attempt fails and returns an error. This is the default.

Description

When you load data to an ASO cube, you commit the contents of a load buffer to the cube. Creating an ASO load buffer and loading data into the buffer are not exclusive operations (they can run concurrently with other operations). However, committing the data in the load buffer to the cube is an exclusive operation.

Example

ASOBUFFERCOMMITWAIT TRUE