Administrator's Reference

QUERY DBVOLUME (Display Information on One or More Database Volumes)

Use this command to display information about database volumes and volume copies.

Privilege Class

Any administrator can issue this command.

Syntax

                     .-*-----------.
>>-Query DBVolume----+-------------+---------------------------->
                     '-volume_name-'
 
      .-Format--=--Standard-----.
>-----+-------------------------+------------------------------><
      '-Format--=--+-Standard-+-'
                   '-Detailed-'
 

Parameters

volume_name
Specifies the name of the database volume. This parameter is optional. You can use wildcard characters to specify names. If you do not specify a volume name, information on all database volumes is displayed.

Format
Specifies how the information is displayed. This parameter is optional. The default is STANDARD. Possible values are:

Standard
Specifies that partial information is displayed.

Detailed
Specifies that complete information is displayed.

Examples

Task 1

Command:
query dbvolume harvey.pinv

Output:
 
+--------------------------------------------------------------------------------+
|                                                                                |
|Volume Name       Copy    Volume Name  Copy    Volume Name  Copy                |
|(Copy 1)          Status  (Copy 2)     Status  (Copy 3)     Status              |
|----------------  ------  -----------  ------  -----------  ---                 |
|HARVEY.PINV       Sync'd               Sync'd              Undef-               |
|                                                            ined                |
|                                                                                |
+--------------------------------------------------------------------------------+
Task 2

Display detailed information on the database volume named HARVEY.PINV.

Command:
query dbvolume harvey.pinv format=detailed

Output:
+--------------------------------------------------------------------------------+
|                                                                                |
|Volume Name (Copy 1): HARVEY.PINV                                               |
|        Copy Status: Sync'd                                                     |
|Volume Name (Copy 2):                                                           |
|         Copy Status: Undefined                                                 |
|Volume Name (Copy 3):                                                           |
|         Copy Status: Undefined                                                 |
|Available Space (MB): 4                                                         |
|Allocated Space (MB): 4                                                         |
|     Free Space (MB): 0                                                         |
+--------------------------------------------------------------------------------+

where:

Volume Name (Copy n)
Specifies the name of the volume. The output displays status of the three volume copies (Copy 1, Copy 2, and Copy 3).

Copy Status
Specifies the status of the volume. Possible values are:

Offline
The volume is varied offline.

Stale
The volume is not synchronized with the other volumes and cannot be used for storage.

Sync'd
The volume is synchronized with the other volumes and can be used for storage.

Undefined
No volume has been defined.

Available Space (MB)
Specifies the total amount of space that is available, both allocated and free, in megabytes.

Allocated Space
Specifies the amount of space allocated, in megabytes.

Free Space
Specifies the amount of unassigned space for this mirror set that can be allocated for use, in megabytes.

Related Commands

Table 145. Commands Related to QUERY DBVOLUME

Command Description
DEFINE DBCOPY Creates a volume copy of a database volume.
DEFINE DBVOLUME Assigns a volume to be used for database storage.
DELETE DBVOLUME Deletes a volume from the database.
VARY Specifies whether a disk volume is available to the server for use.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]