Display Dedicated Route Information

Use admin who to display information on dedicated routes between Replication Servers.

In this example, there is a dedicated route from the RS_NY primary Replication Server to the RS_LON replicate Replication Server for the NY_DS.pdb1 primary connection. Enter admin who at the two Replication Servers and you see:

At RS_LON:

Spid Name      State              Info
45 SQT         Awaiting Wakeup    103:1  DIST NY_DS.pdb1
13 SQM         Awaiting Message   103:1 NY_DS.pdb1
32 REP AGENT   Awaiting Command   NY_DS.pdb1
16 RSI         Awaiting Wakeup    RS_LON
11 SQM         Awaiting Message   16777318:0 RS_LON
55 RSI         Awaiting Wakeup    RS_LON(103) /* Dedicated RSI thread */
53 SQM         Awaiting Message   16777318:103 RS_LON(103) /*Dedicated RSI outbound queue */

At RS_NY:

Spid Name     State               Info
37 RSI USER   Awaiting Command    RS_NY(103) /*Dedicated RSI user */
32 RSI USER   Awaiting Command    RS_NY

See Replication Server Reference Manual > Replication Server Commands > admin who.