Checking the status of consistency group

You can use Db2® Db2 Intelligence Center to monitor the status of consistency group.

Live monitoring graphs display on the details page for each consistency group. They provide high-level monitoring information, and details about replication latency and throughput. You can change the time period for the statistics by clicking the time indicators at the top of the page.

Performance data is reported by the replication programs in Db2 control tables for the specified monitor interval and is retained for seven days by default. The data is refreshed in the console dashboard as configured in Data retrieval frequency.

Note: Most monitoring statistics that are reported in the console are computed when each transaction is committed at the target system. Because you often have large transactions in a Db2 Warehouse environment, for some workloads the values that are reported are clustered in specific periods. For example, if a transaction that inserts 10,000,000 rows runs for 10 minutes, and it is the only transaction that is running on your system, the throughput shows 0 for each monitoring period but then shows 10,000,000 when the transaction is finally committed at the target. In a production system with a heavy workload, the commits tend to be distributed more consistently and the graph curves are generally smoother.

High level - Consistency point

The high-level status summary on the left is labeled with the replication set name. It shows the Consistency point of transactions at the target for the active tables in the replication set, which helps you determine how caught up replication at the target is regarding database activity at the source. It is the source commit time for which all transactions to that point were applied to the target.

The graph also displays whether the replication set is active, and then breaks down activity by table to show which tables in the set are active, which tables have errors, and the status of target table loading activity.