This view presents group information from ISYSIQBACKUPHISTORY in a readable format. Each row in this view describes a particular backup operation that finished successfully.
The view SYSIQBACKUP projects equivalent string values for columns type, subtype, and bkp_virtual.
Column name |
Column type |
Column constraint |
Description |
|---|---|---|---|
bu_id |
unsigned bigint |
NOT NULL |
Transaction identifier of the checkpoint of the operation. Backup ID for backup operations. |
bu_time |
timestamp |
NOT NULL |
Time of backup operation that is recorded in backup record. |
type |
tinyint |
NOT NULL |
Backup type: 0 = FULL 1 = INCREMENTAL 2 = INCREMENTAL SINCE FULL |
selective_type |
tinyint |
NOT NULL |
Backup subtype: 0 = ALL (backs up all dbfiles) 1 = READ/WRITE ONLY (backs up all read-write files) 2 = READ ONLY (backs up a particular read-only file) |
virtual_type |
tinyint |
NOT NULL |
Backup virtual type: 0 = NONE 1 = DECOUPLED 2 = ENCAPSULATED |
dependson_id |
unsigned bigint |
NULL |
NULL for FULL backup |
cmd |
long varchar |
NOT NULL |
Full text of command |
creator |
char(128) |
NOT NULL |
User who issued backup command |
version |
unsigned int |
NOT NULL |
Backup version |
Constraints on underlying system table
Primary key (bu_id)
