Chapter 4: Troubleshooting Sybase Replication Agent

Checking the Replication Agent status

The status of the Replication Agent instance indicates whether it is:

In Replicating state, or
In Admin state.

No replication takes place when the Replication Agent instance is in Admin state. See “Understanding Replication Agent states” for more information.

To check the current Replication Agent status

Log in to the Replication Agent instance with the administrator login.
Use the following command to check the current status of the Replication Agent:
```
ra_status
```
This command returns the current state of the Replication Agent instance, as shown in the following example:
```
State  Action
------ ----------------------------
ADMIN  Waiting for operator command
(1 row affected)
```

See the Sybase Replication Agent Reference Manual for more information about the ra_status command.

What’s next

When the Replication Agent instance is in one of the following states, take the suggested actions.

If...	Then...
The Replication Agent instance is in Replicating (Waiting at end of log) state	Examine the statistics output to check the progress of the replication process. See “Using the ra_statistics command to troubleshoot” for more information.
The Replication Agent instance is Replicating When the Replication Agent instance is in the Replicating state, all data may not have yet been replicated. You can only be sure that the Replication Agent instance is finished replicating when the state is Replicating (Waiting at end of log).	The instance is operating normally, but it has not reached the end of the transaction log. Wait until Replication Agent instance is in Replicating (Waiting at end of log) state. Then repeat the procedure on page §.
If the Replication Agent instance is in Admin state	Start replication and put the Replication Agent instance in Replicating state by executing the Replication Agent resume command. See “Starting replication in the Replication Agent” for more information. If the Replication Agent instance returns to Admin state after you invoke the resume command, then there is at least one unresolved problem that prevents the instance from going to Replicating state. See “Examining the Replication Agent logs” for more information.

If...

Then...

The Replication Agent instance is in Replicating (Waiting at end of log) state

Examine the statistics output to check the progress of the replication process. See “Using the ra_statistics command to troubleshoot” for more information.

The Replication Agent instance is Replicating

When the Replication Agent instance is in the Replicating state, all data may not have yet been replicated. You can only be sure that the Replication Agent instance is finished replicating when the state is Replicating (Waiting at end of log).

The instance is operating normally, but it has not reached the end of the transaction log. Wait until Replication Agent instance is in Replicating (Waiting at end of log) state. Then repeat the procedure on page §.

If the Replication Agent instance is in Admin state

Start replication and put the Replication Agent instance in Replicating state by executing the Replication Agent resume command. See “Starting replication in the Replication Agent” for more information.

If the Replication Agent instance returns to Admin state after you invoke the resume command, then there is at least one unresolved problem that prevents the instance from going to Replicating state. See “Examining the Replication Agent logs” for more information.

View this book as PDF