Returns the current state of the Replication Agent instance.
ra_status
When ra_status is invoked, it returns the current state of the Replication Agent instance, and a brief description of the current state, as follows:
State Action ------ ---------------------------- ADMIN Waiting for operator command (1 row affected)
If the first word in the description is “Transitioning,” the Replication Agent instance
is in transition between states. Some commands are not valid when
the Replication Agent instance is in state transition.
Replication Agent states are:
Admin – in this state, the Replication Agent instance is running, but no connections are up. You can change any configuration parameter when the Replication Agent instance is in Admin state.
Replicating – in this state, the Log Reader component is scanning the transaction log for operations to replicate from the primary database. If there are operations to be replicated, the Log Transfer Interface component is sending LTL commands to the Replication Server.
Replicating (Waiting at end of log) – in this state, the Log Reader component has reached the end of the transaction log, the Replication Agent has finished processing all operations in the transaction log, and the Log Transfer Interface component has successfully sent LTL commands for all replicated operations to the Replication Server.
If the primary database is not quiesced or is otherwise inactive, transactions could arrive in the log immediately after the state is returned, so even though the state is returned as Replicating (Waiting at end of log), the Replication Agent could actually be in Replicating state and processing log records.
See the Replication Agent Administration Guide for more information about Replication Agent states.
The ra_status command is valid when the Replication Agent instance is in either Admin or Replicating state.
