When you dump Replication Server queues into the RSSD, the queue entries are stored in rs_queuemsg. If rs_queuemsg table already has rows for a segment, those rows are deleted from the table before the latest rows from that segment are dumped.
Column |
Datatype |
Description |
---|---|---|
q_number |
int |
Queue number |
q_type |
int |
Queue type |
q_seg |
int |
Queue segment |
q_blk |
int |
Queue block |
q_row |
int |
Queue row |
len |
int |
Length of the queue entry |
origin_site_id |
int |
Origin site ID |
origin_q_id |
binary(36) |
Queue ID assigned by the origin |
origin_time |
datetime |
Time transaction was initiated |
origin_user |
varchar(30) |
User who submitted transaction at origin site |
tran_name |
varchar(30) |
Transaction name |
local_q_id |
binary(36) |
Queue ID assigned by the local Replication Server |
status |
int |
Message status |
reserved |
int |
Reserved for future use |
tran_len |
smallint |
Length of tran_id |
txt_len |
smallint |
Length of command |
tran_id |
binary(120) |
Transaction ID |
lorigin_site_id |
int |
Site ID of the logical connection that is the source of the queue entries. |
version |
int |
Release version of the message |