rs_routes

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 the following 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.