The bar_ixbar table
The bar_ixbar table, which stores a history of all unexpired successful backups in all timelines, is maintained and used by the onsmsync utility only.
The schema of the bar_ixbar table is identical
to the schema of the bar_syncdeltab table, except for its primary
key.
| Column name | Type | Explanation |
|---|---|---|
| ixb_sm_id | INTEGER | Storage-manager instance ID. Created from BAR_SM in $ONCONFIG or %ONCONFIG%. |
| ixb_copyid_hi | INTEGER | The high bits of the instance copy identifier. Combined with ixb_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. |
| ixb_copyid_lo | INTEGER | The low bits of the instance copy identifier. Combined with ixb_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. |
| ixb_aid | INTEGER | Action identifier, Identifies the successful action that created this instance of the backup object. |
| ixb_old | INTEGER | Object identifier. Identifies the affected object. |
| ixb_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. |
| ixb_prevtime | INTEGER | Time stamp (real clock time). This value specifies the time stamp of the previous object. Value represents the number of seconds since midnight, January 1, 1970 Greenwich mean time. |
| ixb_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. |
| ixb_act_start | datetime year to second | The date and time when the action began. |
| ixb_act_end | datetime year to second | The date and time when the action finished. |
| ixb_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. |
| ixb_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 ixb_req_aid is the same as ixb_aid in this table. For example, if this backup is level-1, ixb_req_aid holds the action ID of the corresponding level-0 backup of this object. |
| ixb_first_log | INTEGER | In a standard backup, identifies the first logical log. Required to restore from this backup. |
| ixb_chpt_log | INTEGER | The ID of the log that contains the rsam_time checkpoint. Used during back up to verify that logs needed for restore are backed up. |
| ixb_last_log | INTEGER | Log ID of the last log needed during logical restore for this storage space to restore it to the time of the backup. |
| ixb_lbuflags | INTEGER | Flags describing log backup. |
| ixb_verify | INTEGER | Value is 1 if the backup is verified. Value is 0 if the backup is not verified. |
| ixb_verify_date | datetime year to second | The current date is inserted when a backup is verified. If this backup has not been verified, a dash represents each date and time. |
| ixb_sm_name | VARCHAR(128) | Storage-manager instance name. Created from the BAR_SM_NAME parameter in the onconfig file. |
| ixb_srv_name | VARCHAR(128) | The database server name. Used to ensure that objects are restored to the correct database server. Used when multiple database servers are on the node to ensure that objects are restored in the database server instance to which the object belongs. The database server name can be up to 128 characters. |
| ixb_obj_name | VARCHAR(128) | The user name for the object. The name can be up to 128 characters. |
| ixb_obj_type | CHAR(2) | Backup object type:
|