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
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. |
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. |
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. |
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. |
Examples
Task
Display volume history information stored in the TSM database.
+--------------------------------------------------------------------------------+ | Date/Time: 02/03/1999 18:28:06 | | Volume Type: STGNEW | | Backup Series: 0 | | Backup Operation: 0 | | Volume Seq: 0 | | Device Class: FILE | | Volume Name: /adsmfct/server/prvol1 | | 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 17:28:08 | | Volume Type: DBSNAPSHOT | | Backup Series: 1 | | Backup Operation: 0 | | Volume Seq: 1 | | Device Class: FILE | | Volume Name: /adsmfct/server/prvol1 | | Volume Location: | | Command: | | | | Date/Time: 02/06/1999 20:38:16 | | Volume Type: DBSNAPSHOT | | Backup Series: 1 | | Backup Operation: 0 | | Volume Seq: 2 | | Device Class: FILE | | Volume Name: /adsmfct/server/prvol2 | | Volume Location: JANUS | | Command: | | | | Date/Time: 02/08/1999 22:39:15 | | Volume Type: BACKUPSET | | Backup Series: 1 | | Backup Operation: 0 | | Volume Seq: 1 | | Device Class: FILE | | Volume Name: /tsmfct/server/tsvo1 | | Volume Location: JANUS | | Command: | | | +--------------------------------------------------------------------------------+
where:
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.
The sequence or position of the volume within the backup series.
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.
Related Commands
Table 198. 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. |