Column Name | Data Type | Description |
targetdb | smallint not null | Identifies the database to which the transaction must be replicated. |
sourcedb | smallint not null | Identifies the database where the transaction originated. |
transaction_id | integer not null | Identifier given by the DBMS Server to the original transaction. |
sequence_no | integer not null | The sequence of the operation (insert, update, delete) within the original transaction. |
trans_type | smallint not null | Indicates whether this operation is an: 1 = insert 2 = update 3 = delete |
table_no | smallint not null | Identifies the table changed by the original transaction. |
old_sourcedb | smallint not null | Identifies the database that originated the transaction that manipulated the row before this transaction. |
old_transaction_id | integer not null | Identifier given by the DBMS Server to the transaction that manipulated the row before this transaction. |
old_sequence_no | integer not null | The sequence of the operation (insert, update, delete) within the transaction that manipulated the row before this transaction. |
trans_time | date with null | The date and time when the transaction that manipulated the row was committed in the originating database. |
cdds_no | smallint not null with default | The numeric identifier assigned to the CDDS. This can come directly from dd_regist_tables or indirectly from a lookup table. |
dd_priority | smallint not null with default | The user-assigned priority to resolve collisions. This can be 0 or have been derived from a lookup table. |