backup_history_list
With this command you can display the content of the backup history. You can restrict or extend the display by specifying options.
To save time, we recommend that you execute the DBM command for getting the backup history (see: backup_history_open). If you do not execute this command first, it is executed implicitly with the DBM command for displaying the backup history described here.
You have the server permission Backup or DBInfoRead.
backup_history_list [<option_list>]
<option_list> :: = <option> | <option>,<option>, ...
<option> :: = -c <columns> | -k <key> | -l <label> | -a <action> | -r <restore_flag> | -u <yyyymmddHHMMSS> | -m | -e | -Inverted
|
Option |
Description |
|---|---|
|
-c <columns> |
Specify which columns are to be displayed. If you specify multiple columns, separate them using commas. The keywords for the individual columns are: KEY: key value for the backup LABEL: label for the backup ACTION: backup action STAMP1: first time stamp for the backup STAMP2: second time stamp for the backup START: start of backup STOP: end of backup FIRSTLOG: first log IO sequence number for the backup LASTLOG: last log IO sequence number for the backup LOG: states whether log backups have to be imported after data backup has been imported MEDIA: name of the backup template used PAGES: size of the backup in pages VOLUMES: number of parts that comprise the backup RC: return value from database for the backup ERROR: backup error message |
|
-k <key> |
Only the line of the backup history that contains the key value specified under <key> is displayed. This option must not be used with the -r option. |
|
-l <label> |
Only the lines of the backup history containing the backup label specified are displayed. This option must not be used with the -r option. |
|
-a <action> |
Only the lines of the backup history that match the backup type specified are displayed. This option must not be used with the -r option. |
|
-r <restore_flag> |
Only backups required to restore the database are displayed. Possible values for <restore_flag>: * | LAST | <key> *: All data backups required to restore the database are displayed. If the log volume is still intact, then only the data backups that match the existing log entries in the log volume are displayed. LAST: All backups that are required to recover the database are displayed including the last complete database backup. <key>: Key value of the complete data backup All the backups required to restore the database are displayed. The key value of the complete data backup is stored in the backup history in the first column of the entry for this backup. |
|
-u <yyyymmddHHMMSS> |
Only the lines in the backup history containing data saved in the database before the specified time are displayed. Time format: Year Month Day Hours Minutes Seconds |
|
-m |
For each line that relates to a backup, information on the backup template used is output. |
|
-e |
For each line that relates to a backup, information is displayed about the associated external backup ID. |
|
-Inverted |
The backup history is displayed in reverse order; that is, starting with the most recent backup. |
OK
END | CONTINUE
<history_line>
[<media_line>
[<external_backup_id-line>]
<history_line>
[<media_line>]
[<external_backup_id-line>]
....
|
Value |
Description |
|---|---|
|
END |
The contents of the backup history have been transferred in full. The file is closed automatically. |
|
CONTINUE |
The backup history contains further entries that were not transferred due to the limited size of the reply package. You can display this data by entering the DBM command again, or close the backup history (see: backup_history_close). |
|
<history_line> |
Information about the last backups The columns are separated by a vertical slash ( |). A separate line is displayed for each backup. |
|
<media_line> |
Information about the backup template used for the backup The line has an M: prefix and is followed by the columns, each separated by a vertical slash ( |). |
|
<external_backup_id_line> |
If the backup was created using a backup tool, information about the external backup ID is shown here. The line has an E: prefix and is followed by the columns, each separated by a vertical slash ( |). |
In the event of errors, see Reply Format.
Database Administration, Log Files