Example: Customizing and Sending an SNMP Trap as an Alert Action

Teradata® Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
Suppose that you want to send a trap to an SNMP management server when the current perm space that is used by any database on Teradata Database system TEST1 exceeds 80%. You want the trap to include the name of the database on which the threshold was exceeded as well as the actual percent of perm space in use for that database.

For this example, the SNMP management package is running on a system named prodMgr1. To configure and send an SNMP trap as an alert action, perform the following steps:

  1. In the Alert Setup portlet, create an SNMP configuration.
    1. From the Setup Options list, click Delivery Settings.
    2. From the Delivery Types list, click SNMP.
    3. Next to SNMP, click .
    4. In the Configuration Name box, type snmpConfig.
    5. Select the Enable SNMP check box.
    6. In the Destination box, type prodMgr1 as the hostname for the trap.
    7. Select the Alert message check box.
    8. Select the Alert Conditions check box.
    9. Click Apply.
  2. In the Alert Setup portlet, create an Action Set.
    1. From the Setup Options list, click Alert Presets.
    2. From the Preset Options list, click Core Hours.
    3. Verify the core hours displayed correspond to the weekday hours.
    4. From the Preset Options list, click Action Sets.
    5. Click next to Action Sets.
    6. In the Action Set Name box, type sendTrap.
    7. Under Times, select all the check boxes: Core, Evening, and Weekend.
    8. Under Actions, make sure the Include in Alert Viewer check box is selected. This option is selected by default so you can view alerts for this action set in the Alert Viewer portlet.
    9. Under Actions, select the SNMP check box and from the Config list select snmpConfig.
    10. Click Apply.
  3. In the Monitored Systems portlet for Teradata Viewpoint monitoring, configure TEST1.
    1. Click next to Systems and select Add Teradata System.
    2. In the System Nickname box, type TEST1.
    3. Select the Enable system check box to activate the TEST1 system for monitoring.
    4. In the TDPID box, type the TDPID of the TEST1 system.
    5. Enter a login name and password.
    6. Click Apply.
  4. In the Monitored Systems portlet, configure the data collectors.
    1. From the Systems list , click TEST1.
    2. From the Setup list, click Data Collectors.
    3. From the Data Collectors list, click Database Space.
    4. Select the Enable Database Space Collector check box and keep the default settings.
    5. Click Apply.
  5. In the Monitored Systems portlet, define alert rules.
    1. From the Systems list, click TEST1.
    2. From the Setup list, click Alerts.
    3. From the Alert Types list, click Database Space.
    4. Click next to Alerts.
    5. In the Alert Name box, type PermExceeds80.
    6. Select the Enable alert check box.
    7. From the Threshold list, select Current Perm.
    8. In the box to the right of the greater-than symbol (>), type 80.
    9. Click , select the All databases except the selected databases below option and include all databases, and click OK.
    10. From the Action list, select sendTrap.
    11. In the Message box, enter: Database ${databaseName} current perm use is ${spaceUsedPct}%.
    12. Click Apply.
      You can include alert properties in the Message box by enclosing the property name in curly brackets ({}) and preceding the expression with a dollar sign ($) as shown above for databaseName and spaceUsedPct. See Teradata Database Alert Metrics and Properties for a description of the alert properties that are available for Teradata Viewpoint alerts.

      When the perm space usage for a database exceeds 80%, a trap is sent to the configured trap destination, in this example, prodMgr1. Because you configured the SNMP delivery settings with both the Alert conditions and Alert message options enabled, the trap Details box contains the alert rule conditions of the event that generated the trap followed by the message you provided in the PermExceeds80 alert rule: (Space Used Percentage > 80. 0), Database finance current perm use is 81.9%.

  6. In the Alert Viewer portlet, review triggered actions.