Q Replication Dashboard

Q Capture Live Monitor

This screenshot of a stand-alone Live Monitor highlights the three types of information displayed for Q Capture:

  1. DB2 log latency
  2. Throughput on active queues
  3. No activity on a queue

1. DB2 Log Latency

The top pane shows the capture log latency. This is the amount of time that capture is behind the DB2 log. This latency applies to all the queues.

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.

2. Throughput on Active Queues

This shows a running graph of row throughput, measured in rows/sec. The average throughput is a running average over the last 1000 time intervals. If the refresh interval is 10 seconds, then this is the average over the last ~3 hours. Next to the average is the throughput trend. This is an indicator on how the average over the last 30 intervals relates to the larger average. If the trend shows as an arrow pointing up, the throughput is increasing. If the trend is an arrow pointing down, the throughput is decreasing.

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.

3. No Activity on a Queue

This is a graph of the throughput on a specific queue. Since there are no messages currently being sent on this queue, a "No Activity" message is shown.

...