rs_queues

number

int

Queue ID. This column displays a number representing either:

• The source database for an inbound queue, or

• The destination database or Replication Server for an outbound queue

Values correspond to entries for databases in the dbid column in the rs_databases system table and to entries for Replication Servers in the id column in the rs_sites system table.

type

int

Queue type:

• 0 – outbound queue

• 1 – inbound queue

• large negative number – a subscription materialization queue

state

int

Current state of this queue:

• 0 – failure

• 1 – active

• 2 – deleting

twosave

int

Indicates the number of seconds the Replication Server maintains an SQM segment after all messages in the segment have been acknowledged by targets. A setting of -1 indicates a strict setting.

truncs

int

The number of truncation points