rs_routes

Stores routing information about network traffic.

Column

Datatype

Description

dest_rsid

int

ID of a data server or Replication Server

through_rsid

int

Destination is reached through this Replication Server. For a direct route, the value of through_rsid is the same as that of dest_id.

source_rsid

int

Replication Server where this route is defined

status

tinyint

Status of the route:

  • 1 – being initialized

  • 2 – route is valid at this site (route is valid when status is 2 at both the source and destination Replication Servers)

  • 3 – dropping this route gracefully

  • 4 – dropping this route immediately

suspended

tinyint

One of these values:

  • 0 – route is active

  • 1 – route is suspended

  • 2 – route is being rebuilt. In the process of setting the truncation point.

  • 3 – route is suspended. In the process of setting the truncation point.

  • 8 (mask) – for an RSI outbound queue, instructs the replicate Replication Server to set the locater field in the rs_locater table to 0, for this sending Replication Server.

src_version

int

Version of source Replication Server for this route. Note that this version is the RSI version (not what appears in the rs_config stored procedure under current_rssd_version).

  • 1000 – version assigned to any pre-10.1 Replication Server

  • 1010 – version 10.1

  • 1100 – version 11.0

  • 1150 – version 11.5

  • 1200 – version 12.0

Refer to the Release Bulletin for Replication Server for any additional supported version numbers.

Indexes

Unique clustered index on (dest_rsid, source_rsid)