rs_queuemsg

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

Indexes

Unique clustered index on (q_number, q_type, q_seg, q_blk, q_row)