Tivoli Header

Administrator's Reference

QUERY VOLHISTORY (Display Sequential Volume History Information)

Use this command to display sequential volume history information. To save sequential volume history information to one or more files, use the BACKUP VOLHISTORY command.

Use the VOLUMEHISTORY server option to specify one or more volume history files. After the server is restarted, TSM updates volume information in both the database and the files.

Use the QUERY BACKUPSET command to query specified backup set information.

Privilege Class

Any administrator can issue this command.

Syntax

>>-Query VOLHistory--+----------------+--+--------------+------->
                     '-BEGINDate=date-'  '-ENDDate=date-'
 
>--+----------------+--+--------------+------------------------->
   '-BEGINTime=time-'  '-ENDTime=time-'
 
   .-Type--=--All-------------.
>--+--------------------------+--------------------------------><
   '-Type--=--+-All---------+-'
              +-DBBackup----+
              +-DBDump------+
              +-BACKUPSET---+
              +-DBSnapshot--+
              +-DBRpf-------+
              +-EXPort------+
              +-RPFile------+
              +-RPFSnapshot-+
              +-STGNew------+
              +-STGReuse----+
              '-STGDelete---'
 
 

Parameters

BEGINDate
Specifies that you want to display information beginning with records created on the specified date. This parameter is optional. The default is the earliest date for which history information exists.

You can specify the data using one of the values below:

Value Description Example
MM/DD/YYYY A specific date 09/15/1998
TODAY The current date TODAY
TODAY-days or -days The current date minus days specified TODAY-7 or -7.

To display information beginning with records created a week ago, specify BEGINDATE=TODAY-7 or BEGINDATE=-7.

ENDDate
Specifies that you want to display information ending with records created on the specified date. This parameter is optional. The default is the current date.

You can specify the data using one of the values below:

Value Description Example
MM/DD/YYYY A specific date 09/15/1998
TODAY The current date TODAY
TODAY-days or -days The current date minus days specified. The maximum number of days is 9999. TODAY-1 or -1.

To display records created up to yesterday, specify ENDDATE=TODAY-1 or ENDDATE=-1.

BEGINTime
Specifies that you want to display information beginning with records created at the specified time. This parameter is optional. The default is midnight (00:00:00).

You can specify the data using one of the values below:

Value Description Example
HH:MM:SS A specific time on the specified begin date 12:33:28
NOW The current time on the specified begin date NOW
NOW+HH:MM or +HH:MM The current time plus hours and minutes on the specified begin date NOW+03:00 or +03:00.

If you issue this command at 9:00 with BEGINTIME=NOW+03:00 or BEGINTIME=+03:00. TSM displays records with a time of 12:00 or later on the begin date.

NOW-HH:MM or -HH:MM The current time minus hours and minutes on the specified begin date NOW-03:30 or -03:30.

If you issue this command at 9:00 with BEGINTIME=NOW-03:30 or BEGINTIME=-03:30, TSM displays records with a time of 5:30 or later on the begin date.

ENDTime
Specifies that you want to display information ending with records created at the specified time on the end date. This parameter is optional. The default is the current time.

You can specify the data using one of the values below:

Value Description Example
HH:MM:SS A specific time on the specified end date 10:30:08
NOW The current time on the specified end date NOW
NOW+HH:MM or +HH:MM The current time plus hours and minutes on the specified end date NOW+03:00 or +03:00.

If you issue this command at 9:00 with ENDTIME=NOW+03:00 or ENDTIME=+03:00, TSM displays records with a time of 12:00 or later on the end date.

NOW-HH:MM or -HH:MM The current time minus hours and minutes on the specified end date NOW-03:30 or -03:30

If you issue this command at 9:00 with ENDTIME=NOW-3:30 or ENDTIME=-3:30, TSM displays records with a time of 5:30 or earlier on the end date.

Type
Specifies the type of records to display from the volume history file. This parameter is optional. The default is ALL. Possible values are:

All
Specifies all records.

DBBackup
Specifies to display only records that contain information about full and incremental database backup volumes, that is with the volume types of BACKUPFULL and BACKUPINCR.

DBDump
Specifies only records that contain information about online database dump volumes.

BACKUPSET
Specifies to display only information about backup set volumes.

DBSnapshot
Specifies to display only records that contain information about volumes used for database snapshot backups.

DBRpf
Specifies to display only records that contain information about full and incremental database backup volumes and recovery plan file object volumes (volume types of BACKUPFULL, BACKUPINCR, and RPFILE).

EXPort
Specifies only records that contain information about export volumes.

RPFile
Specifies to display only records that contain information about recovery plan file objects that were created assuming database full and incremental backups and that are saved on a target server.

RPFSnapshot
Specifies to display only records that contain information about snapshot recovery plan file objects that were created assuming snapshot database backups and that are saved on a target server.

STGNew
Specifies only records that contain information about new sequential access storage volumes.

STGReuse
Specifies only records that contain information about reused sequential storage pool volumes.

STGDelete
Specifies only records that contain information about deleted sequential storage pool volumes.

Examples

Task

Display volume history information stored in the TSM database.

Command:
query volhistory

Output:
+--------------------------------------------------------------------------------+
|        Date/Time: 02/03/1999 18:28:06                                          |
|      Volume Type: STGNEW                                                       |
|    Backup Series: 0                                                            |
| Backup Operation: 0                                                            |
|       Volume Seq: 0                                                            |
|     Device Class: 8MMTAPE                                                      |
|      Volume Name: TAPE01                                                       |
|  Volume Location:                                                              |
|          Command:                                                              |
|                                                                                |
|        Date/Time: 02/04/1999 16:20:46                                          |
|      Volume Type: BACKUPFULL                                                   |
|    Backup Series: 1                                                            |
| Backup Operation: 0                                                            |
|       Volume Seq: 1                                                            |
|     Device Class: DEV.JANUS                                                    |
|      Volume Name: JANUS.DBB.895533646                                          |
|  Volume Location: JANUS                                                        |
|         Command:                                                               |
|                                                                                |
|        Date/Time: 02/05/1999 16:26:02                                          |
|      Volume Type: RPFILE                                                       |
| Backup Operation: 0                                                            |
|       Volume Seq: 1                                                            |
|     Device Class: DEV.JANUS                                                    |
|      Volume Name: JANUS.19980518.162102                                        |
|  Volume Location: JANUS                                                        |
|                                                                                |
|        Date/Time: 02/06/1999 20:38:16                                          |
|      Volume Type: DBSNAPSHOT                                                   |
|    Backup Series: 1                                                            |
| Backup Operation: 0                                                            |
|       Volume Seq: 2                                                            |
|     Device Class: 8MMTAPE                                                      |
|      Volume Name: TAPE01                                                       |
|  Volume Location: JANUS                                                        |
|          Command:                                                              |
|                                                                                |
|        Date/Time: 02/08/2001 22:39:15                                          |
|      Volume Type: BACKUPSET                                                    |
|    Backup Series: 1                                                            |
| Backup Operation:                                                              |
|       Volume Seq:                                                              |
|     Device Class: 8MMTAPE                                                      |
|      Volume Name: TAPE01                                                       |
|  Volume Location: JANUS                                                        |
|          Command:  generate backupset bill pers_data devclass=8mmtape          |
+--------------------------------------------------------------------------------+

where:

Date/Time
The date and time that the volume was created.

Volume Type
The type of volume:

BACKUPFULL
Full database backup volume

BACKUPINCR
Incremental database backup volume

BACKUPSET
Client backupset volume

DBSNAPSHOT
Snapshot database backup volume

DBDUMP
Online database dump

EXPORT
Export volume

RPFILE
Recovery plan file object volume created assuming full and incremental database backups

RPFSnapshot
Recovery plan file object volume created assuming snapshot database backups

STGDELETE
Deleted sequential access storage pool volume

STGNEW
Added sequential access storage pool volume

STGREUSE
Reused sequential access storage pool volume

Backup Series
The full backup and all incremental backups that apply to that full backup. Another series begins with the next full backup of the database.

Backup Operation

For BACKUPFULL or BACKUPINCR volume types: the operation number of this backup volume within the backup series. The full backup within a backup series is operation 0. The first incremental backup for that full backup is operation 1, the second incremental backup is operation 2, and so on.

For DBSNAPSHOT volume types: the operation number of this DBSNAPSHOT volume within the DBSNAPSHOT series.

For all other volume types: always 0.

This field is blank when the volume type is BACKUPSET.

Volume Seq

The sequence or position of the volume within the backup series.

Device Class
The name of the device class associated with this volume.

Volume Name
The name of the volume.

Volume Location
The location of the volume. This information is available only for volume types of BACKUPFULL, BACKUPINCR, DBDUMP, EXPORT and RPFILE.

For RPFILE this location field is the server name defined in the device class definition used by the PREPARE command when the DEVCLASS parameter is specified.

Command
When the volume type is EXPORT or BACKUPSET, this field shows the command that was used to generate the volume. If the EXPORT or BACKUPSET is on more than one volume, the command is displayed with the first volume but not with any of the other volumes.

When any volume type other than EXPORT or BACKUPSET is used, this field is blank.

Related Commands

Table 222. Commands Related to QUERY VOLHISTORY

Command Description
BACKUP VOLHISTORY Records volume history information in external files.
DELETE VOLHISTORY Removes sequential volume history information from the volume history file.
PREPARE Creates a recovery plan file.
QUERY RPFILE Displays information about recovery plan files.
UPDATE VOLHISTORY Adds or changes location information for a volume in the volume history file.


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