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, IBM Spectrum Protect™ 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
.-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----'
- This parameter is only available on AIX, HP-UX, Linux, Solaris and Windows operating systems.
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 date 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.
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.
- 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 date 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.
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.
- 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 time 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. IBM Spectrum Protect 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, IBM Spectrum Protect 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 time 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, IBM Spectrum Protect 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, IBM Spectrum Protect 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.
- BACKUPSET
- Specifies to display only information about backup set volumes.
- 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.
- 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).
- DBSnapshot
- Specifies to display only records that contain information about volumes used for database snapshot backups.
- EXPort
- Specifies only records that contain information about export volumes.
- REMote
- Specifies to display only records that contain information about volumes used by library clients.
- RPFile
- Specifies to display only records that contain information about file objects of a recovery plan that are saved on a target server and that were created assuming database full and incremental backups. The parameter displays only records about recovery plan files that are saved on another IBM Spectrum Protect server by using the server-to-server virtual volume function for IBM Spectrum Protect.
- RPFSnapshot
- Specifies to display only records that contain information about file objects of a recovery plan that are saved on a target server and that were created assuming database snapshot backups. RPFSnapshot only displays records about recovery plan files that are saved on another IBM Spectrum Protect server by using the server-to-server virtual volume function for IBM Spectrum Protect.
- STGDelete
- Specifies only records that contain information about deleted sequential storage pool volumes.
- 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.
Example: Display volume history information for a storage pool volume
Display volume history information for a storage pool volume stored in the database. See Field descriptions for field descriptions. Issue the command: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:
Example: Display volume history information for a database backup volume
Display volume history information for a database backup volume stored in the database. See Field descriptions for field descriptions. Issue the command: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
Field descriptions
- 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 backup set volume.
- DBSNAPSHOT
- Snapshot database backup volume.
- EXPORT
- Export volume.
- REMOTE
- A volume used on the library client, which is the IBM Spectrum Protect server named in the Volume Location field. See the volume history on the server that is the library client to get details about how the volume is used.
- 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 value of this field depends on the volume type:
- For BACKUPFULL or BACKUPINCR volume types: the backup series identifier.
- For the DBSNAPSHOT volume type: the identifier of the backup series that is associated with the DBSNAPSHOT entry.
- For the RPFILE volume type: the identifier of the backup series that is associated with the RPFILE entry.
- For the RPFSNAPSHOT volume type: the identifier of the backup series that is associated with the RPFSNAPSHOT entry.
- For BACKUPSET volume types: this field is blank.
- For all other volume types: always 0.
- 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.
- For BACKUPFULL or BACKUPINCR volume types: the sequence, or position, of the volume within the backup series. Volume sequence 1 identifies the first volume used for the first operation (a full backup), and so on. For example, if the full backup occupies three volumes, these volumes are identified as volume sequence 1, 2, and 3, respectively. The first volume of the next operation (the first incremental backup) is then volume sequence 4.
- For BACKUPSET volume types: the sequence, or position, of the volume within the BACKUPSET series.
- For DBSNAPSHOT volume types: the sequence, or position, of the volume within the DBSNAPSHOT series. Volume sequence 1 identifies the first volume used for the first DBSNAPSHOT operation, and so on.
- For EXPORT volume types: the sequence number of the volume when it was used for exporting data.
- For RPFILE volume types: the value of this field is always one (1).
- For all other volume types: always 0.
- 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 the following volume types:
- BACKUPFULL
- BACKUPINCR
- EXPORT
- REMOTE
- RPFILE
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.
- Command
- When the volume type is EXPORT or BACKUPSET and the volume sequence
is 1 (for example, the first volume), 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.
For any volume type other than EXPORT or BACKUPSET, this field is blank.
- 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
Related commands
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. |