SYSIQBACKUPHISTORYDETAIL system view

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