Display Disk Volume

View a list of currently defined disk volume definitions.

Syntax

Syntax diagram for display disk volume.UNIQUE-VOL-NAMEDBS-NAME

Use display disk volume to display disk volume information in the following ways:

KeywordDescription

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:

ColumnDescription

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.