User's Manual

Column Description
offset The transaction log offset of the commit operation for
the transaction. This value uniquely identifies each
transaction
user_id The remote user where the transaction originated. This
column holds NULL if the transaction did not originate
from a remote user.
The user_id column is used to ensure that actions are not
replicated back to the remote site that entered them.
data The transaction itself, in an internal representation.
sr_confirmed_transaction table
Function Each row marks the corresponding row in sr_transaction.
Columns
Column Data type Description
confirmed_id NUMERIC
(20,0)
A unique ID
offset NUMERIC
(20,0)
A copy of an offset used to mark rows
in sr_transaction for deletion.
sr_queue_coordinate table
Function A single row, that coordinates the SQL Remote log scanning thread and the
sending thread to access the stable queue and related tables.
Columns
Column Data type Description
status CHAR(1) N if the stable queue has not yet been
used by SQL Remote. I and S if the
SQL Remote log scanning thread and
sending thread have accessed the queue.
352