View a list of currently defined disk volume definitions.
Syntax
Use display disk volume to display disk volume information in the following ways:
Keyword | Description |
---|---|
all | Display all disk-volume definitions on the system. |
<unique-vol-name> | Display a disk-volume definition by name. |
on database | Display all disk-volume definitions associated with the specified database. |
Notes
To manage disk volumes, use alter database (containing add, drop, and set disk volume).
Output Columns
The values returned for the file type field are numeric, and translate as follows:
Column | Description |
---|---|
1 | Index |
2 | Data |
3 | Index and Data |
Example
display disk volume;
Displays all (if any) disk volumes defined on the system.
display disk volume sample.basic.'vol3/hyperion/Essbase';
or
display disk volume sample.basic.C;
Displays information about a particular disk volume definition on Sample.Basic.