Specifying Disk Volumes with ESSCMD

  To allocate a new volume, see the ESSCMD SETDBSTATEITEM 23 in the Oracle Essbase Technical Reference.

ESSCMD prompts you for the number of new disk volumes you want to add, unless you supply the number on the command line.

Then, for each new volume, ESSCMD prompts you for the following values, unless you supply them on the command line.

  • Volume name (for each volume)

  • Volume size (maximum space to use on the volume)

    The default value is Unlimited; the minimum setting is 8 MB.

When you use ESSCMD, you can specify volume size in bytes (B), kilobytes (K), megabytes (M), gigabytes (G), or terabytes (T). ESSCMD displays minimum, maximum, and current values and 0 for unlimited.

The following example allocates up to 10 GB on Volume E, sets a maximum file size of 2 GB, and specifies that data files should be stored only on E:

SETDBSTATEITEM 23 "SAMPLE" "BASIC" "1" "E" "10G" "2" "2G"

  To change the settings on an allocated volume, enter SETDBSTATEITEM 24 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:

The following example allocates up to 20 GB on Volume C and sets a maximum file size of 2 GB:

SETDBSTATEITEM 24 "SAMPLE" "BASIC" "1" "C" "20G" "3" "2G"

  To stop Essbase from storing additional files on a volume, enter SETDBSTATEITEM 25 in ESSCMD and either follow the prompts or supply the required values on the command line. Essbase continues accessing files on the deallocated volume but does not write new files to it.

ESSCMD prompts you for the following value, unless you supply it on the command line—Delete which volume definition. Use the GETDBSTATE command in ESSCMD to see a list of the currently defined disk volumes and to see the number assigned to each volume.

The following example deallocates the volume that is specified as fourth:

SETDBSTATEITEM 25 "SAMPLE" "BASIC" "4"

Note:

If you delete an application or database, Essbase does not remove the directory containing the application or database on a disk volume. The computer's operating system still shows the folder and file labels on the disk. However, you can reuse the same name of the application or database that you had removed on the disk volume.

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

On UNIX, volume_name is a mounted UNIX file system. You must enter a fully qualified pathname to the Essbase installation directory (ESSBASEPATH). Essbase automatically appends the app directory to the path; you do not specify the app directory.

Consider the following example:

/vol2/EssbaseServer 10M

Volume size is the maximum space, in KB, allocated to the volume. The default value is unlimited—Essbase uses all available space on that volume.