Setting Data Integrity Options

For databases, Essbase automatically commits data to disk. By specifying isolation levels and related settings, you can tell Essbase how to commit data blocks to disk. For transactions, Essbase offers two isolation levels: committed access and uncommitted access (the default). Using committed access optimizes data integrity.

Note:

These options do not apply to aggregate storage databases.

You need Database Manager permissions to change isolation level settings. Changes become effective the next time that there are no transactions.

  To specify isolation levels and related settings for databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Edit, and then Properties.

  3. In the Database Properties window, select the Transactions tab.

  4. Select Committed access or Uncommitted access (the default).

  5. If you selected Committed access:

    1. Expand the Concurrency node.

    2. Select a wait time.

    3. Optional: Select Pre-image access.

  6. If you selected Uncommitted access, expand the Synchronization point node, and specify a number for Commit block and/or Commit row.

  7. Click Apply.

Related Information

Related Commands