rs_queues

Stores information to allow site recovery. Used by the Replication Server stable queue manager and guaranteed delivery system.

Column

Datatype

Description

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

Indexes

Unique clustered index on (number, type)