ra_locator

Description

Returns the current value of the LTM Locator recorded in the RASD, retrieves an LTM Locator value from the Replication Server, or sets the value of the LTM Locator to all zeros.

Syntax

ra_locator [update]

Parameters

update: The optional keyword that tells Mirror Replication Agent to retrieve a new LTM Locator value from the Replication Server.

Examples

Example 1

ra_locator

This command returns the current value of the LTM Locator, from the RASD, as follows:

Locator
 ---------------------------------------------------
 000000005200000000000000527FFFFFFFFFFFFFFF0022FB3B
 (1 row affected)

Example 2

ra_locator update

This command retrieves a new LTM Locator value from the Replication Server.

Usage

When ra_locator is invoked with no option, it returns the current value of the LTM Locator stored in the RASD.

The value of the LTM Locator that is maintained by the Mirror Replication Agent is also known as the origin queue ID.
When ra_locator is invoked with the update keyword, it retrieves a new LTM Locator value from the Replication Server, and stores it in the RASD. The LTM Locator update operation is asynchronous and it may take a few seconds to complete.

When the ra_locator command is invoked with the update keyword, the LTM Locator change takes effect only if the Mirror Replication Agent instance is in Replicating state.
The LTM Locator contains information that Mirror Replication Agent uses to determine where to start reading the primary database transaction log.

Upon start-up, or recovery from a connection failure, Mirror Replication Agent automatically requests an LTM Locator value from the Replication Server.
- If the value of the LTM Locator returned from the Replication Server is zero, then Mirror Replication Agent uses the LTM Locator value stored in its RASD.
- If the value of the LTM Locator in the RASD is zero, then Mirror Replication Agent starts reading the primary database transaction log from the end of the log.
If the value of the LTM Locator does not exist in the RASD, the ra_locator command returns a zero locator value.
The ra_locator command is valid when the Mirror Replication Agent instance is in either Admin or Replicating state.