ON–Bar writes a record to the bar_instance table for each successful backup. The table describes each object that is backed up. ON–Bar might later use the information for a restore operation. For example, if you specify a level-2 backup, ON–Bar uses this table to ensure that a level-1 backup was done previously.
| Column Name | Type | Explanation |
|---|---|---|
| ins_aid | INTEGER | Action identifier. Identifies the successful action that created this instance of the backup object. Combined with ins_oid, can be used to join with the bar_action table. |
| ins_oid | INTEGER | Object identifier. Identifies the affected object. Can be used to join with the bar_object table. Combined with ins_aid, can be used to join with the bar_action table. |
| ins_prevtime | INTEGER | Timestamp (real clock time). This value specifies the timestamp of the previous object. The value represents the number of seconds after midnight, January 1, 1970 Greenwich mean time. |
| ins_time | INTEGER | Time stamp (real clock time). The database server
uses this value when it creates the next-level backup. Value represents
the number of seconds since midnight, January 1, 1970, Greenwich
mean time.
For IDS, the ins_time value is 0. |
| rsam_time | INTEGER | The backup checkpoint time stamp. Not a clock time. The database server uses this value when it creates the next level backup. |
| ins_level | SMALLINT | Level of the backup action: 0 for a complete backup, 1 for a backup of any changes to this object since its last level-0 backup, 2 for a backup of any changes since the last level-1 backup. This value is always 0 for logical-log backups. |
| ins_copyid_hi | INTEGER | The high bits of the instance copy identifier. Combined with ins_copyid_lo, it is a unique value that the storage manager assigns to link the ON-Bar object identifier with the storage-manager object identifier. |
| ins_copyid_lo | INTEGER | The low bits of the instance copy identifier. Combined with ins_copyid_hi, it is a unique value that the storage manager assigns to link the ON-Bar object identifier with the storage-manager object identifier. |
| ins_req_aid | INTEGER | Stores the required action ID for a backup object. Used in a restore to determine which level-0 backup goes with the level-1 backup, and which level-1 backup goes with the level-2 backup. For a level-0 backup, the value of ins_req_aid is the same as ins_aid in this table. For example, if this backup is level-1, ins_req_aid holds the action ID of the corresponding level-0 backup of this object. |
| ins_logstream
(XPS only) |
INTEGER | The coserver ID from which this object came. |
| ins_first_log | INTEGER | In a standard backup, identifies the first logical log required to restore from this backup. |
| ins_chpt_log
(XPS only) |
INTEGER | The ID of the log that contains the rsam_time checkpoint. Used during backup to verify that logs needed for restore are backed up. |
| ins_last_log
(XPS only) |
INTEGER | Log ID of the last log needed during logical restore for this storage space to restore it to the time of the backup. |
| ins_lbuflags (XPS only) | INTEGER | Flag field storing attributes for log backups. |
| ins_sm_id
(XPS only) |
INTEGER | Storage-manager instance ID. Created from BAR_SM in $ONCONFIG or %ONCONFIG%. |
| ins_sm_name
(XPS only) |
VARCHAR(128, 0) | Storage-manager instance name. Created from the BAR_SM_NAME parameter in the ONCONFIG file. |
| ins_verify | INTEGER | Value is 1 if the backup is verified. Value is 0 if the backup is not verified. |
| ins_verify_date | DATETIME YEAR TO SECOND | The current date is inserted when a backup is verified. If this backup has not been not verified, a dash represents each date and time. |