rs_oqid

Stores the last queue ID received from an origin site, and is also used to coordinate the resetting of truncation points.

Column

Datatype

Description

origin_site_id

int

Site ID of the origin site

q_number

int

Queue number

q_type

int

Queue type

origin_q_id

binary(36)

Command ID at the origin database

local_q_id

binary(36)

Local ID for the queue

valid

int

Validation status:

  • 0 – valid

  • 1 – detecting losses

  • 2 – rejecting messages after loss detected

origin_lsite_id

int

Site ID of the logical database of the origin site

Indexes

  • Unique clustered index on (origin_site_id, q_number, q_type)