Three utilities that work with the replication and publishing
technologies help you monitor your replication and publishing environments
and keep sources and targets synchronized.
- Q Replication Dashboard
- The Q Replication Dashboard provides Web-based health
monitoring of DB2® and Q Replication
and Event Publishing. The rich Web interface includes live graphs
of throughput and latency, a health summary that helps you quickly
identify and troubleshoot problems, and at-a-glance status information
on programs, queues, Q subscriptions, and other objects. For information
about downloading the dashboard tool, see the "Q Replication Tools"
page at http://www-01.ibm.com/support/docview.wss?uid=swg27007070.
- Replication Alert Monitor
- The Replication Alert Monitor is a utility that checks the health
of programs that are part of the replication and Event Publishing
solutions. The monitor checks for situations in which a program terminates,
issues a warning or error message, reaches a threshold for a specified
value, or performs a certain action. You tell the Replication Alert
Monitor which situations to watch for. If any of them occur, the Replication
Alert Monitor sends an e-mail message to the person or group of persons
that are designated as the appropriate contacts for such a situation.
For
example, you might have the Replication Alert Monitor notify you when
a replication program is not running or has reached the maximum amount
of memory that you expect it to use.
- Reconciliation utilities
- Source and target tables can lose synchronization when, for example,
a target table is changed by an application. The asntdiff and asntrepair utilities
can detect and repair differences between source and target tables
in Q Replication and SQL Replication. By using them, you can avoid
comparing tables manually and having to reload targets to resynchronize
them with sources.
The asntdiff utility generates
a relational table of the differences between a source and target
table. After you run the asntdiff utility, you
can run the asntrepair utility, which uses this
table of differences to determine which rows to insert, update, or
delete at the target table to synchronize it with the source table.