Help SQL Replication

The Replication Alert Monitor, the Capture program, and the Apply program

The Replication Alert Monitor uses some of the Capture control tables to monitor the Capture program, and uses some of the Apply control tables to monitor the Apply program. It reads from different replication control tables at each Capture control server or Apply control server, depending on what it is monitoring.

The Replication Alert Monitor does not interfere or communicate with the Capture or Apply program.

The following steps describe how the Replication Alert Monitor monitors conditions for the Capture or Apply program and notifies contacts when an alert condition occurs:

  1. The Replication Alert Monitor reads the alert conditions and the contact for each condition (for a Monitor qualifier) in the IBMSNAP_CONDITIONS table.
  2. For each Capture control server or Apply control server that has a defined alert condition, the Replication Alert Monitor performs the following tasks:
    1. The Replication Alert Monitor connects to the server and reads the replication control tables associated with each alert condition for that server to see if any of the conditions are met.
    2. If any condition is met, the Replication Alert Monitor stores the data that is related to that condition in memory and continues processing the remaining alert conditions for that server.
    3. When it is finished processing all the alert conditions for that server, the Replication Alert Monitor disconnects from the Capture control or Apply control server, inserts the alerts in the IBMSNAP_ALERTS table, and notifies the contacts for that condition.


Send your feedback | Information roadmap | The Q+SQL Replication Forum

Update icon Last updated: 2013-10-25