Administrator's Reference

QUERY LOGVOLUME (Display Information on One or More Log Volumes)

Use the QUERY LOGVOLUME command to display information on one or more recovery log volumes, including available, allocated, and free space on the volume. This command displays information about the specified recovery log volume and any recovery log volume copies.

Privilege Class

Any administrator can issue this command.

Syntax

                     .-*-------.  .-Format--=--Standard------.
>>-Query LOGVolume---+---------+--+--------------------------+-><
                     '-volname-'  '-Format--=--+-Standard-+--'
                                               '-Detailed-'
 

Parameters

volname

Specifies the name of the recovery log volume to be queried. This parameter is optional. You can use a pattern-matching expression to specify this name. All matching recovery log volumes are displayed. If you do not specify a volume name, all volumes are displayed.

Format=formatvalue

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

Standard

Specifies that partial information is displayed for the specified recovery log volume.

Detailed

Specifies that complete information is displayed for the specified recovery log volume.

Examples

Task 1

Display information about recovery log volume named log.1.

Command:

query logvolume log.1

Output:

 

+--------------------------------------------------------------------------------+
|                                                                                |
|Volume Name        Copy    Volume Name   Copy    Volume Name  Copy              |
|(Copy 1)           Status  (Copy 2)      Status  (Copy 3)     Status            |
|----------------   ------  ------------  ------  -----------  ------            |
|/home/bill/dsm-    Sync'd                Undef-               Undef-            |
| serv/build/log.1                        ined                 ined              |
+--------------------------------------------------------------------------------+

See Task 2 for parameter definitions.

Task 2

Display detailed information about the recovery log volume named log.1

Command:

query logvolume log.1 format=detailed

Output:

+--------------------------------------------------------------------------------+
| Volume Name (Copy 1): /home/bill/dsmserv/build/log.1                           |
|         Copy Status: Sync'd                                                    |
|Volume Name (Copy 2):                                                           |
|         Copy Status: Undefined                                                 |
|Volume Name (Copy 3):                                                           |
|         Copy Status: Undefined                                                 |
|Available Space (MB): 8                                                         |
|Allocated Space (MB): 8                                                         |
|     Free Space (MB): 0                                                         |
+--------------------------------------------------------------------------------+

where:

Volume Name (Copyn)

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

Copy Status

Specifies the status of the database volume. Possible values are:

Offline

The volume is varied offline.

Stale

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

Sync'd

The volume is synchronized with the other volumes in the recovery log 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, for the recovery log, in megabytes.

Allocated Space

Specifies the amount of space allocated for the recovery log, in megabytes.

Free Space

Specifies the amount of unassigned space in the recovery log that can be allocated for use, in megabytes.

Related Commands

Table 142. Commands Related to QUERY LOGVOLUME

Command	Description
DEFINE LOGCOPY	Creates a volume copy of a recovery log volume.
DEFINE LOGVOLUME	Defines a disk volume to the recovery log.
DELETE LOGVOLUME	Deletes a volume from the recovery log.
VARY	Specifies whether a disk volume is available to the server for use.