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