sp_iqbackupsummary Procedure

Summarizes backup operations performed.

Syntax

sp_iqbackupsummary [ timestamp or backup_id ]

Parameters

Parameters
Parameter	Description
timestamp or backup_id	Specifies the interval for which to report backup operations. If you specify a timestamp or a backup ID, only those records with backup_time greater than or equal to the time you enter are returned. If you specify no timestamp, the procedure returns all the backup records in ISYSIQBACKUPHISTORY.

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

sp_iqbackupsummary returns the following:

sp_iqbackupsummary columns
Column name	Description
backup_id	Identifier for the backup transaction
backup_time	Time of the backup
backup_type	Type of backup: “Full,” “Incremental since incremental,” or “Incremental since full”
selective_type	Subtype of backup: "All Inclusive", "All RW files in RW dbspaces", "Set of RO dbspace/file"
virtual_type	Type of virtual backup: “Non-virtual,” “Decoupled,” or “Encapsulated”
depends_on_id	Identifier for backup that the backup depends on
creator	Creator of the backup
backup_size	Size, in KB, of the backup
user_comment	User comment
backup_command	The backup statement issued (minus the comment)

Example

Sample output of sp_iqbackupsummary:

backup_id   backup_time             backup_type   selective_type   virtual_type
      883   2008-09-23 13:58:49.0   Full          All inclusive    Non virtual

depends_on_id   creator   backup_size   user_comment   backup_command
            0   DBA                10864               backup database to
                                                         'c:\\\\temp\\\\b1'