Kbase P123821: How to know if a target DB is actually in synch with the source
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/4/2007 |
|
Status: Verified
GOAL:
How to know if a target DB is actually in synch with the source
GOAL:
How to know if a source DB is synchronized with the target
FACT(s) (Environment):
OpenEdge Replication
FIX:
There areseveral ways in which it is possible to see if the replicated DB's are in synch:
1.- When replication has been established the source DB log shows e.g.
(10436) The source database Source and the target database Target on host remotehost are synchronized.
2.- Run dsrutil Target ?C monitor and select option A. Replication agent status, i.e.
S. Replication server status
R. Replication server remote agents
A. Replication agent status
M. Modify display defaults
Q. Quit
Enter your selection:
On the second page of the monitor output, if the Repl Server behind Source DB by value is 0, and the transaction IDs reported are the same, then source and target are synchronized -
Repl Server behind Source DB by: 0 second(s)
Current Source Database Transaction: 20170
Last Transaction Applied to Target: 20170
Under some circumstances that the transaction IDs are different. This can happen, for example, when transactions are started on the source, then cancelled - a TRID is allocated, but because it is cancelled, no actual processing is carried out on the target. Under the dsrutil monitor > agent, further indicators for synchronization therefore are -
1. The delta for Target Current as of being 0, e.g.
Target Current as of (Target, Source): Thu Nov 29 13:15:56 2007, Thu Nov 29 13:15:56 2007 with delta of 000:00:00
2. Repl Server behind Source DB by being 0.
3. The values under AI Block Information being the same, e.g.
AI Block Information:
Source RDBMS Block (Seq / Block): 2 / 0
Last Processed Block (Seq / Block): 2 / 0
4. Agent is waiting for: Nothing
5. Under Activity information, Blocks received and Blocks processed being the same.
6. Transactions started and Transactions ended being the same.