var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: formula to calculate the end-to-end latency db2 (SQL replication)
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