Setting up IBM InfoSphere Change Data Capture event notifications

To set up InfoSphere CDC event notifications:

1. Determine the SMTP server name by consulting the network administrator.
2. Log in to the InfoSphere CDC Management Console as access-server-user.
3. Stop mirroring and end replication on the subscription for your shadow tables. InfoSphere CDC does not allow any configuration changes while a subscription is active.
   1. Click Monitoring > Subscriptions.
   2. Right-click the subscription, select End Replication > Normal, and click OK.
4. Set email notification at the datastore-level:
   1. Click Configuration > Datastores.
   2. Right-click the datastore for your shadow tables and select Notifications.
   3. Click the Source tab.
   4. From Notification Categories, select the first category for which you want to enable notifications.
   5. Select the INTERNET MAIL box, and enter the following information:
      • In the SMTP Mail Host in the hostname box, enter the name the outgoing mail server.
      • In the Alert Account box, enter the one or more email addresses or a distribution list that you want to notify. If you specify multiple email addresses, use a semicolon (;) to separate them.
      • In the Sender Mail Address box, enter the email address.
      • In the Sender Mail Password box, enter the password of the sender.
   6. Click Copy Setting.
   7. Select the notification categories to apply the same notification settings. Because in shadow tables the source and the target are the same datastore, select Target categories from that list.
   8. Select the Target > Apply > Informational category to copy the notification settings and to enable latency threshold and notification for the subscription.
   9. Return to the main Configuration > Datastores view by clicking OK in the Copy Notification Settings window and then also in the Notifications window.
5. Set the latency threshold and notification:
   1. Click Configuration > Subscriptions.
   2. Right-click the subscription for your shadow tables and select Latency Thresholds.
   3. Select the Notify when latency crosses these thresholds check box.
   4. Specify a warning threshold in minutes. A good value is 75% of the value of the CURRENT REFRESH AGE special register.
   5. Specify a problem threshold in minutes. The value must be greater than the warning threshold. A good value is 90% of the CURRENT REFRESH AGE.
   6. Click OK. Do not click Set Notification, because you specified all the required notification settings in step 4.
6. Set event filtering to disable event notification for InfoSphere CDC event IDs that you are not interested in.
   Enabling Target Informational events to capture latency threshold notifications returns notifications for event IDs that you are might not interested in.
   1. Click Configuration > Subscriptions.
   2. Right-click the subscription and select Notifications.
   3. In the Notification Categories window, click the Target tab.
   4. Click Filter Messages. The event ID filtering applies to all the categories of the target datastore.
   5. In the list, enter the event IDs that you do not want to be notified of (one event on each line), and select the Do not send these messages option.
   6. Filter the same event IDs for the source datastore, because it is the same as the target datastore.
7. Start mirroring to start receiving event notifications by email.
   1. Click Configuration > Subscriptions.
   2. Right-click the subscription name and select Start Mirroring.
   3. In the Start Mirroring window, specify the mirroring method by selecting Continuous, and click OK.
   The following text shows examples of event notifications that are sent by email:

   Event ID: 1463
   Publisher(S)/Subscriber(T): S
   System ID: SUBS_SHADOW_TABLE_LI_SVT_INST1
   Event Text: +++ Subscription SUBS_SHA is starting in Continuous Mirroring
     mode.
   
   Event ID: 3172
   Publisher(S)/Subscriber(T): T
   System ID: SUBS_SHA
   Event Text: Latency for journal JOURNAL has exceeded the problem threshold
     of 15 minutes.