Store data
Essbase automatically sets the default Essbase kernel storage settings. However, you can customize the major Essbase kernel settings in Application Manager or Essbase Administration Services:
- Data compression: Specify data compression on disk and the compression scheme.
- Cache sizes: You can specify the index, data file, and data cache sizes. To prevent a slow-down of the operating system, ensure that the sum of index and data cache sizes for all the active databases on the server is not more than two-thirds of the system's RAM.
- Cache memory locking: You can lock the memory that is used for the index, data file, and data caches into physical memory.
- Disk volumes: You can specify the storage location of Essbase index files and data files, specify the appropriate disk volume names and configuration parameters.
- Isolation level: Specify either committed access or uncommitted access.