rs_locater

Description

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_apiexecuted:

When you execute sysadmin skip_bad_repserver_cmd for the RCL that failed, Replication Server updates the rs_locater entry to typeS.” Replication Server skips the failed command the next time Replication Agent sends the command.

Indexes

Unique clustered index on (sender, type)