Progress Fathom Replication
User’s Guide

> ## Latency reporting

> If the target database transitions to a normal database, latency reporting allows you to determine how far behind the target database is from the source database. When the target transitions to a normal database, there will be some number of AI blocks that have been written to the source database that have not been applied by the Fathom Replication agent to the target database. To know how much, if any, information has not been applied to the target database, `DSRUTIL MONITOR` from the server’s perspective and from the agent’s perspective provides the following latency information:

> ##### Fathom Replication server perspective

> - Current RDBMS AI block.

> - AI block that the Fathom Replication server last read.

> - The time the last AI block was read.

> - The current transaction ID assigned to RDBMS.

> ##### Fathom Replication agent perspective

> - Current source database AI block.

> - AI block that the Fathom Replication agent last processed.

> - The last transaction ID just applied.

> - The source database machine time that the last transaction was applied to the source database. This time stamp is critical, as it will tell you that transactions committed before that date are in the target database.

> For more information on the `DSRUTIL MONITOR` reports on latency from the Fathom Replication server and agent perspective, see Table 3–5.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095