Skip to main content

Determine if the replication agent has applied all the transactions up to a particular point

For a parallel replication agent, the repadm utility "getstats" option displays the oldest uncommitted transaction log position below the last processed log position, as shown in the following output.

sid tid lognum logpos state seqno time error func
23 32 30 3300473 source 398228 2 0 ctReplGetNextChange

In this example, the log read thread has processed up to log 30 offset 3300473, and the oldest uncommitted transaction is at log 30 offset 3251827. If the oldest uncommitted transaction log position is zero, it means that the replication agent has committed all transactions up to the point of the last processed log position.

Use this information to determine if the replication agent has applied all the transactions up to a particular point in the transaction logs.

Notice

A repadm utility that does not support the newest version of the log read statistics structure will fail to read the log read thread statistics. The repadm utility will output the following error message, then exit.

"Error: Replication agent log read stat structure version (1) does not match repadm utility structure version (2)."

The solution is to use a version of the repadm utility that supports the new log read statistics structure.