Suppose you want to send a trap to an SNMP management server when the current perm space that is used by any database on Teradata 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:
- In the Alert Setup portlet, create an SNMP configuration.
- From the Setup Options list, select Delivery Settings.
- From the Delivery Types list, select SNMP.
- Next to SNMP, select .
- In the Configuration Name box, type snmpConfig.
- Select the Enable SNMP check box.
- In the Destination box, type prodMgr1 as the hostname for the trap.
- Select the Alert message check box.
- Select the Alert Conditions check box.
- Click Apply.
- In the Alert Setup portlet, create an Action Set.
- From the Setup Options list, select Alert Presets.
- From the Preset Options list, select Core Hours.
- Verify the core hours displayed correspond to the weekday hours.
- From the Preset Options list, select Action Sets.
- Select next to Action Sets.
- In the Action Set Name box, type sendTrap.
- Under Times, select all the check boxes: Core, Evening, and Weekend.
- 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.
- Under Actions, select the SNMP check box and from the Config list select snmpConfig.
- Click Apply.
- In the Monitored Systems portlet for Teradata Viewpoint monitoring, configure TEST1.
- Next to Systems, select , then select Add Teradata System.
- In the System Nickname box, type TEST1.
- Select the Enable system check box to activate the TEST1 system for monitoring.
- In the TDPID box, type the TDPID of the TEST1 system.
- Enter a login name and password.
- Click Apply.
- In the Monitored Systems portlet, configure the data collectors.
- From the Systems list , select TEST1.
- From the Setup list, select Data Collectors.
- From the Data Collectors list, select Database Space.
- Select the Enable Database Space Collector check box and keep the default settings.
- Click Apply.
- In the Monitored Systems portlet, define alert rules.
- From the Systems list, select TEST1.
- From the Setup list, select Alerts.
- From the Alert Types list, select Database Space.
- Select next to Alerts.
- In the Alert Name box, type PermExceeds80.
- Select the Enable alert check box.
- From the Threshold list, select Current Perm.
- In the box to the right of the greater-than symbol (>), type 80.
- Select , select the All databases except the selected databases below option and include all databases, then select OK.
- From the Action list, select sendTrap.
- In the Message box, enter: Database ${databaseName} current perm use is ${spaceUsedPct}%.
- 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 previously for databaseName and spaceUsedPct. See Teradata 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%.
- In the Alert Viewer portlet, review triggered actions.