Note that if the DB2 system is lightly loaded, the log latency may appear higher than it really is. The log latency value shown is the time difference between the current time and the last log record that QCapture has read. If DB2 is not processing updates, it does not write any log records, so the time of the last log record remains constant.
This value is calculated by subtracting MONITOR_TIME from CURRENT_LOG_TIME in the IBMQREP_CAPMON table.
This value is calculated by fetching ROWS_PUBLISHED from the IBMQREP_CAPQMON table and dividing the value by the number of seconds that has passed since the last row was fetched. If the ROWS_PUBLISHED value is 0, then the no activity message is shown.