SYSBACKUP System Table

The SYSBACKUP table maintains information about each database backup. You can query this table to find the ID of and details about a backup that was run at a specific time.

SYSBACKUP system table
Column Name Type Length Nullable Contents
BACKUP_ID BIGINT 19 NO The backup ID
BEGIN_TIMESTAMP TIMESTAMP 29 NO The start time of the backup
END_TIMESTAMP TIMESTAMP 29 YES The end time of the backup
STATUS VARCHAR 10 NO The status of the backup
FILESYSTEM VARCHAR 32642 NO The backup destination directory
SCOPE VARCHAR 10 NO

The scope of the backup: database, schemas, tables, etc. The current allowable values are:

  • D for the entire database
INCREMENTAL_BACKUP BOOLEAN 1 NO

YES for incremental backups, NO for full backups

NOTE: Incremental backups are not yet available.

INCREMENTAL_PARENT_BACKUP_ID BIGINT 19 YES

For an incremental backup, this is the BACKUP_ID of the previous backup on which this incremental backup is based.

For full backups, this is -1.

NOTE: Incremental backups are not yet available.

BACKUP_ITEM INTEGER 10 YES The number of tables that were backed up.