ra_locator

Description

Returns the current value of the LTM locator, retrieves an LTM locator value from Replication Server, or sets the value of the LTM locator to all zeros.

Syntax

ra_locator [update|zero]

Parameters

update: The optional keyword that tells Replication Agent to retrieve a new LTM locator from the primary Replication Server.

zero: The optional keyword that tells Replication Agent to set the value of the LTM locator stored in the Replication Agent transaction log to all zeros.

Examples

Example 1

ra_locator update

This command tells Replication Agent to retrieve a new LTM locator value from the primary Replication Server.

Example 2

ra_locator zero

This command sets the value of the LTM locator maintained by Replication Agent to all zeros.

Example 3

ra_locator

This command returns the current value of the LTM locator maintained by Replication Agent, as shown below:

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

Usage

When ra_locator is invoked with no keyword, it returns the current value of the LTM locator maintained by the Replication Agent instance. The Replication Agent stores the value of the LTM locator in a table in the primary database.

The value of the LTM locator maintained by the Replication Agent is known as the origin queue ID.
When ra_locator is invoked with the update keyword, it retrieves a new LTM locator value from the primary Replication Server and stores it in the transaction log system table. The update operation is asynchronous and may take a few seconds to complete.

When the ra_locator command is invoked with the update keyword, the change takes effect only if the Replication Agent instance is in the Replicating state.
When ra_locator is invoked with the zero keyword, it sets the value of the LTM locator maintained by Replication Agent to all zeros.
The LTM locator contains information used by Replication Agent to determine where to start reading the transaction log. Upon start-up or connection failure recovery, Replication Agent requests an LTM locator from the primary Replication Server. If the value of the LTM locator returned from the primary Replication Server is all zeros, then Replication Agent uses the value of the LTM locator it has stored. If the value of the LTM locator that Replication Agent has stored is all zeros, then the Replication Agent Log Reader component starts reading the transaction log from either the current beginning of the log (trigger-based Replication Agents), or from the end of the log (log-based Replication Agents).
For more information about the format of the origin queue ID, see the appendix for your specific primary database server at the end of this book.
If the Replication Agent transaction log does not exist, the ra_locator command returns an error message.
The ra_locator command with the zero keyword is valid only when the Replication Agent instance is in the Admin state.