The sysbuobject table provides information about the backup and restore objects that the Backup Scheduler is processing.
Column | Type | Description | ||
---|---|---|---|---|
owner | INTEGER | The coserver owner of the object | ||
priority | INTEGER | Priority in the Backup Scheduler queue for this session | ||
order_hi | INTEGER | The high-order word of the restore order for the object (high 32 bits of a 64-bit number) | ||
order_lo | INTEGER | The low-order word of the restore order for the object (low 32 bits of a 64-bit number) | ||
placement | INTEGER | The storage-manager instance where this object is located | ||
retries | INTEGER | Number of times that the backup or restore is retried | ||
timestamp | INTEGER | The global time for the object | ||
dbsname | CHAR(128) | The dbspace name | ||
level | INTEGER | The backup level of the dbspace | ||
log_num | INTEGER | The logical-log number | ||
is_backup | INTEGER | A value of 1 means this object is to be backed up. | ||
is_restore | INTEGER | A value of 1 means this object is to be restored. | ||
is_check | INTEGER | A value of 1 means this object is to be verified with the archecker utility. | ||
is_block | INTEGER | A value of 1 means the coserver is blocked for an external backup. | ||
is_external | INTEGER | A value of 1 means an external restore of a dbspace is in progress. | ||
is_dbspace | INTEGER | A value of 1 means this object is a dbspace. | ||
is_log | INTEGER | A value of 1 means this object is a logical-log file. | ||
is_coserver | INTEGER | A value of 1 means this object is a coserver (used for external backup and restore). | ||
is_running | INTEGER | A value of 1 means this object is being processed. | ||
is_ready | INTEGER | A value of 1 means this object is ready to be processed. | ||
is_waiting | INTEGER | A value of 1 means this object cannot be processed yet. | ||
is_suspend | INTEGER | A value of 1 means processing of this object is suspended. | ||
is_cold | INTEGER | A value of 1 means this object is to be cold-restored. |