This view describes all the dbfile records present in the database at backup time. Each row in this view describes a particular backup operation that finished successfully.
It presents group information from ISYSIQBACKUPHISTORYDETAIL in a readable format. The column constraint for each column is NOT NULL.
Column name |
Column type |
Description |
|---|---|---|
bu_id |
unsigned bigint |
Transaction identifier of the checkpoint of the operation. Backup ID for backup operation. |
dbspace_id |
smallint |
The dbspace ID of which this dbfile record is associated. |
dbfile_id |
smallint |
The dbfile ID present in dbspace during ongoing backup operation |
dbspace_rwstatus |
char(1) |
T indicates read-write |
dbspace_createid |
unsigned bigint |
The transaction ID of the transaction that created the dbspace |
dbspace_alterid |
unsigned bigint |
Transaction ID that marked the dbspace RO. If not marked, then the create ID |
dbspace_online |
char(1) |
T indicates online |
dbfile_rwstatus |
char(1) |
T indicates read-write |
dbfile_createid |
unsigned bigint |
The transaction ID of the transaction that created this dbfile |
dbfile_alterid |
unsigned bigint |
The transaction ID of the transaction that last altered the read-write status of this dbfile |
is_backed_up |
char(1) |
Indicates that the dbfile is backed up in this backup |
start_block |
unsigned bigint |
Start block for the dbfile |
num_blocks |
unsigned bigint |
Total number of blocks in dbfile |
num_blocks_backed_up |
unsigned bigint |
Total number of blocks backed up |
dbspace_name |
char(128) |
Dbspace name |
dbfile_name |
char(128) |
Logical file name of the dbfile |
dbfile_path |
long varchar |
Physical path of the file |
Constraints on underlying system table:
Primary key (bu_id, dbfile_id)
Foreign key (txn_id) references SYS.ISYSBACKUPHISTORY