A. Data Dictionary Tables : System Catalogs : dd_distrib_queue Table
 
Share this page                  
dd_distrib_queue Table
The dd_distrib_queue table contains the queue of operations (insert, update, delete) that are to be replicated to target databases. The queue is populated by distribution threads and manipulated by one or more Replicator Servers:
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.