Hi ,

Can any body help me to find out how to calculate the end-to-end latency in db2 for SQL replication:

Below script is to calculate the end-to-end latency i don't know whether it's correct.

db2 "select APPLY_QUAL, date(LASTRUN), avg((ENDTIME - LASTRUN) + (SOURCE_CONN_TIME - SYNCHTIME)) from ASN.IBMSNAP_APPLYTRAIL group by APPLY_QUAL, date(LASTRUN)"

Thanks in advance