Stores the last locator field received by stable queues from
each of their senders.
Column
|
Datatype
|
Description
|
|---|
sender
|
int
|
Sender site ID
|
type
|
char(1)
|
Who is using this row:
R – RSI (route)
D – distributor locater used for subscriptions
E – executor for Replication Agent
U – locator at last system upgrade
W – distributor locator used for a warm
standby application
C – locater for the last successfully executed
replication definition request sent by Replication Agent.
F – locater for failed command sent by
Replication Agent.
S – locater for failed command that Replication
Server skipped.
|
locater
|
binary(36)
|
Last queue ID received
from this sender
|
When you execute rs_send_repserver_cmd at
the primary database, rs_locater stores
the OQID of the RCL in type according to whether
the RCL inside ‘rs_api’ executed:
Successfully – type
C
Unsuccessfully – type F
When you execute sysadmin skip_bad_repserver_cmd for
the RCL that failed, Replication Server updates the rs_locater entry
to type “S.” Replication
Server skips the failed command the next time Replication Agent
sends the command.