Integrating Db2 Data Management Console with ServiceNow

You can integrate the IBM® Db2® Data Management Console with ServiceNow to send and receive SNMP traps.

Before you begin

Before you configure the SNMP settings on the Db2 Data Management Console, ensure the following prerequisites are met:
  • Ensure the ServiceNow platform has the following active plugins:
    • Event Management
    • ITOM Metric Management / Operational Intelligence
  • Create the SNMPv3 credentials that can be used to send traps to the ServiceNow MID server.

About this task

The ServiceNow instance uses a MID Server application to facilitate communication between the ServiceNow platform and external data sources, services, and applications. To know more about ServiceNow, refer to IT Operations Management product documentation.

This topic explains how to integrate the Db2 Data Management Console with ServiceNow.

Procedure

  1. Configure the SNMP Settings on the Db2 Data Management Console to specify where to send SNMP traps:
    1. Log into IBM Db2 Data Management Console.
    2. Click Administration and go to Settings > SNMP.
    3. Select and copy the product’s Engine ID to the clipboard.

      You need to provide the Engine ID to the SNMP Trap Collector that runs on the ServiceNow MID Server.

      Note: The Engine ID uniquely identifies a device. It is a hexadecimal string where each byte is separated by a colon. The ServiceNow input field for Engine ID has a 30 character limit. Therefore, it is recommend to paste the Engine ID to a text pad and remove the colons from the string.
    4. In the Host name field, enter the ServiceNow MID Server hostname.
    5. In the Server port field, specify the SNMP port number. You can modify the port number when you configure the SNMP Trap Collector.
    6. Using the SNMPv3 credentials created in the ServiceNow instance, specify the user name in the Username field.
    7. Select the appropriate security level. The Authentication Protocol and Privacy Protocol radio groups should reflect the chosen protocols assigned to the SNMPv3 credentials that can be used to send traps to the ServiceNow MID Server.
    8. Click Save.
  2. Configure ServiceNow to receive SNMP traps:
    1. From the ServiceNow console, navigate to the MID SNMP Traps Listener view and click the New button.
    2. From the new record view, set the SNMP version to v3, and paste the Engine ID string you copied from the Db2 Data Management Console.
    3. Provide details for the required fields based on your preferences.
    4. In the Credentials table, add the SNMPv3 credentials that you used to configure the SNMP settings on the Db2 Data Management Console.
    5. Click the Submit button to create a new SNMP Trap Collector.
      Note: If you make any changes after creating the SNMP Trap Collector, be sure to restart the SNMP Trap Collector by clicking on the Restart link the Related Links.
  3. Set up Monitoring in Db2 Data Management Console to activate Alerts:
    1. Log into IBM Db2 Data Management Console.
    2. Click the gear icon and select Monitoring profile.
    3. From the Monitoring profile page, click Create profile.
    4. From the General tab, enter the profile name and assign databases to this profile.
    5. Click the Monitor settings tab and enter the required details.
    6. Click the Alerts Settings tab and edit the alert configuration.

      You may want to configure the threshold for the Physical memory in use alert to receive the following alerts: A Critical alert when the memory in use hits 90% of the available memory and a Warning alert when it hits 85% of the available memory.

  4. Click the Notification tab and specify the email and SNMP server settings:
    1. Click the Add button.
    2. Provide a name for the rule, and select SNMP as the type of notification the rule should send.
    3. Select the availability and performance alert types that should trigger notifications.
    4. Select the severity of the alerts that should trigger the notifications.
    5. Click OK to save the notification rule, and then click Save to save this monitor profile.
  5. Verify that traps (alerts) are received:
    1. From the ServiceNow dashboard, view the trap events the SNMP Trap Collector received by going to the list of all events.
    2. You can also include additional Event Rules to convert trap events into ServiceNow Alerts. For more information on ServiceNow events, refer to the ServiceNow Event Management documentation.