Show TOC

rs_queuesLocate this document in the navigation structure

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)