Defines the volumes that can be used to store multiple index and data files, and the amount of space that those volumes can occupy.
For new files, disk volume settings become effective after the database is restarted. Previously existing files and volumes are not affected.
This setting does not apply to aggregate storage databases.
DISKVOLUMES [volume_name] [disk_space]...volume_name—The name of the directory where a hard disk is mounted.
On Windows, volume_name is a letter corresponding to a disk drive.
On UNIX, volume_name is a UNIX file path that you must specify up to the directory that you are using for Essbase. Do not specify the /app directory; Essbase appends /app automatically.
Note: | Use only valid volume types. Do not use NFS, floppy, CD-ROM, or network drives. |
If you do not specify any disk volumes, Essbase uses only the volume where the ARBORPATH directory resides.
disk_space—The maximum number of bytes allocated to the volume.
Specify this setting in bytes, kilobytes (K), megabytes (M) or gigabytes (G). Do not use commas or spaces. Avoid decimals (such as 2.5G).
The value is read as bytes.
The maximum value is 2147483648 (231).
If you need to specify a value over 231, you must use a qualifier (K, M, or G); for example, 2000G.
If you enter a value with a qualifier (K, M, or G), the acceptable value range per volume is 0 to 2 terabytes. Do not exceed this amount by specifying, for example, 50000G.
If you specify volume_name without specifying disk_space, all the disk space on that volume is used, as needed.
If you do not specify volume_name, Essbase uses the volume where the ARBORPATH directory resides.
DISKVOLUMES, with its values, can be up to 2 kilobytes long. You can specify 64 items per line; for example, DISKVOLUMES D 5M E 2M C 5G contains 7 items.
Use DISKVOLUMES only if you need backward compatibility with earlier releases, or if you are setting up a large number of databases at the same time with the same DISKVOLUMES value. Otherwise, to set or change disk volumes, use Administration Services or MaxL.
You can specify disk volume names in any order.
If you wish to use a volume in the ARBORPATH directory, you must specify ARBORPATH as one of your parameters. Otherwise, you do not need to specify ARBORPATH.
On Windows, the following command causes index and data files to be stored as follows:
DISKVOLUMES D 5M E 2M C 5G
The first 5 megabytes on drive D
The next 2 megabytes on drive E
The next 5 gigabytes on drive C
On UNIX platforms the following command causes index and data files to be stored as follows::
DISKVOLUMES /vol2/essbase 5M /vol3/essbase 2M /vol1/essbase 5G
The first 5 megabytes on volume vol2
The next 2 megabytes on volume vol3
The next 5 gigabytes on volume vol1