Setting latency thresholds and notifications

You can set a notification that specifies the latency (in minutes) of a subscription. This notification specifies how long it takes CDC Replication to apply data to the target datastore. You must set latency thresholds before you can set a notification.

About this task

When you set a notification, CDC Replication sends you a notification after the following events:
Normal
Latency for the journal or log is below the warning threshold. This means that latency is acceptable and within your normal range. Latency is normal according to the latency thresholds you have set for the subscription.
Warning
Latency for the journal or log is above the warning threshold but below the problem threshold. Latency is starting to become a problem according to the latency thresholds you have set for the subscription.
Problem
Latency for the journal or log is above the problem threshold. Latency is now a problem according to the latency thresholds you have set for the subscription.

Procedure

  1. Click Configuration > Subscriptions.
  2. Right-click on a subscription and select Latency Thresholds.
  3. Enable the Notify when latency crosses these thresholds check box.
  4. Specify a warning threshold (in minutes).
  5. Specify a problem threshold (in minutes). The problem threshold must be greater than the warning threshold.
  6. Click Set Notification.
  7. As a best practice, ensure that Target > Apply > Informational is enabled. You must configure at least one notification setting in the Informational category so that you can receive notification messages and this must be set on the Target tab. These changes will take effect the next time you start replication on this subscription.
  8. Specify how you want to send this notification in the Notification Settings area.

    Depending on the CDC Replication product you have installed, you can send this notification through email message queues, or a user exit program.