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, Tivoli® Storage Manager updates volume information in both the database and the files.
Use the QUERY BACKUPSET command to query specified backup set information.
Any administrator can issue this command.
.-BEGINDate--=--earliest_date-. >>-Query VOLHistory--+-----------------------------+------------> '-BEGINDate--=--date----------' .-ENDDate--=--current_date-. .-BEGINTime--=--00:00:00-. >--+--------------------------+--+------------------------+-----> '-ENDDate--=--date---------' '-BEGINTime--=--time-----' .-ENDTime--=--current_time-. .-Type--=--All-------------. >--+--------------------------+--+--------------------------+-->< '-ENDTime--=--time---------' '-Type--=--+-All---------+-' +-BACKUPSET---+ +-DBBackup----+ +-DBRpf-------+ +-DBSnapshot--+ +-EXPort------+ | (1) | +-REMote------+ +-RPFile------+ +-RPFSnapshot-+ +-STGDelete---+ +-STGNew------+ '-STGReuse----'
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. |
EOLM (End Of Last Month) | The last day of the previous month. | EOLM |
EOLM-days | The last day of the previous month minus days specified. | EOLM-1 To include files that were active a day before the last day of the previous month. |
BOTM (Beginning Of This Month) | The first day of the current month. | BOTM |
BOTM+days | The first day of the current month, plus days specified. | BOTM+9 To include files that were active on the 10th day of the current month. |
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. |
EOLM (End Of Last Month) | The last day of the previous month. | EOLM |
EOLM-days | The last day of the previous month minus days specified. | EOLM-1 To include files that were active a day before the last day of the previous month. |
BOTM (Beginning Of This Month) | The first day of the current month. | BOTM |
BOTM+days | The first day of the current month, plus days specified. | BOTM+9 To include files that were active on the 10th day of the current month. |
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. Tivoli Storage Manager 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, Tivoli Storage Manager displays records with a time of 5:30 or later on the begin date. |
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, Tivoli Storage Manager 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, Tivoli Storage Manager displays records with a time of 5:30 or earlier on the end date. |
query volhistory type=stgnew
Date/Time: 02/25/2011 18:28:06
Volume Type: STGNEW
Backup Series:
Backup Operation:
Volume Seq:
Device Class: FILE
Volume Name: /adsmfct/server/prvol1
Volume Location:
Command:
Database Backup ID High:
Database Backup ID LOW:
Database Backup Home Position:
Database Backup HLA:
Database Backup LLA:
Database Backup Total Data Bytes (MB):
Database Backup total Log Bytes (MB):
Database Backup Block Num High:
Database Backup Block Num Low:
Database Backup Stream Id:
Database Backup Volume Sequence for Stream:
query volhistory type=dbb
Date/Time: 02/25/2011 18:28:06
Volume Type: BACKUPFULL
Backup Series: 176
Backup Operation: 0
Volume Seq: 0
Device Class: FILE
Volume Name: /adsmfct/server/prvol1
Volume Location:
Command:
Database Backup ID High: 0
Database Backup ID LOW: 0
Database Backup Home Position: 0
Database Backup HLA:
Database Backup LLA:
Database Backup Total Data Bytes (MB): 0
Database Backup total Log Bytes (MB): 0
Database Backup Block Num High: 0
Database Backup Block Num Low: 0
Database Backup Stream Id: 1
Database Backup Volume Sequence for Stream: 10,001
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.
For the volume type of REMOTE, this location field is the server name of the library client that owns this volume.
For the volume type of 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.
For any volume type other than EXPORT or BACKUPSET, this field is blank.
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. |
QUERY BACKUPSET | Displays backup sets. |
UPDATE VOLHISTORY | Adds or changes location information for a volume in the volume history file. |