Changing Data Compression Settings

Changes to the data compression setting take effect immediately as Essbase writes data blocks to disk. For blocks already on disk, Essbase does not change compression schemes or enable or disable compression. When you change the data compression settings of blocks already on disk, Essbase uses the new compression scheme the next time Essbase accesses, updates, and stores the blocks.

  To view or change the current settings, use a tool:

Tool

Topic

Location

Administration Services

Selecting a Data Compression Method

Oracle Essbase Administration Services Online Help

MaxL

alter database

Oracle Essbase Technical Reference

ESSCMD

To enable or disable data compression: SETDBSTATE

or:

SETDBSTATEITEM 14

To set the data compression type: SETDBSTATEITEM 15

Oracle Essbase Technical Reference

Example of Using SETDBSTATEITEM

  To enable or disable data compression, enter SETDBSTATEITEM 14 in ESSCMD and either follow the prompts or supply the required values on the command line.

ESSCMD prompts you for the following values, unless you supply them on the command line:

  To specify the data compression type, enter SETDBSTATEITEM 15 in ESSCMD and either follow the prompts or supply the required values on the command line. ESSCMD prompts you for a value of “1” (run length encoding) or “2” (bitmap, the default).

The following example enables Bitmap compression:

SETDBSTATEITEM 14 "SAMPLE" "BASIC" "Y" "2"

For more syntax information, see the Oracle Essbase Technical Reference.