SYSIQBACKUPHISTORY system view

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)