How can I send an email in the event of a critical database problem?

This case involves monitoring for a CJDB026E message, which indicates that an SQL exception has occurred within the IBM® Sterling Control Center Monitor engine that is not a truncation or duplication exception. When such a problem occurs, IBM Sterling Control Center Monitor shuts down. In this event, you would probably want to email a responsible party that IBM Sterling Control Center Monitor has initiated shutdown due to a critical database problem.

  1. To do so, first set up a new action that will send an email to the appropriate party and generate a high-severity alert.
  2. Next, create a rule that monitors for a message ID of CJDB026E by specifying the following parameter:
    Key Operator Value
    Message ID Matches CJDB026E
  3. Within this rule, associate the email action you just created.