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.
Table 1. bar_ixbar table columns
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:
CD
critical dbspace
L
logical log
ND
noncritical dbspace or sbspace
R
rootdbs
B
blobspace