Define Exception to Send Alert to dbaser on Abort/Abort Selects | Viewpoint - Example: Defining an Exception to Send an Alert to Database User on Abort/Abort Selects - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
Suppose you want to send an email alert to the dbauser having the e-mail id dba@example.com, during core hours when a period event begins and ends.
  1. In the Monitored Systems portlet, configure TEST1 as a Teradata Active System Management (TASM) system.
    1. Next to Systems, select "", then select Add Teradata System.
    2. In System Nickname, type TEST1.
    3. Select the Enable system check box.
    4. In the TDPID box, type the TDPID of the TEST1 system.
    5. [Optional] Enter the site ID assigned by Teradata Customer Services.
    6. Enter a login name and password.
    7. Click Apply.
  2. In the Monitored Systems portlet, configure the data collectors.
    1. From the Systems list, select TEST1.
    2. From the Setup list, select Data Collectors.
    3. From the Data Collectors list, select the following collectors, enable them, and select Apply for each:
      • TASM Config
      • TASM Distribution
      • TASM Exception
      • TASM State
      • TASM Summary
      • Alert Request
  3. In the Alert Setup portlet, configure delivery settings.
    1. From the Setup Options list, select Delivery Settings.
    2. From the Delivery Types list, select Email.
    3. In the SMTP Host box, type smtp.example.com as the SMTP host address of the outgoing (SMTP) email server.
    4. Select the Enable email check box.
    5. From the Port list, select Use default port to use the default port 25.
    6. In Server Timeout, type 30 seconds.
    7. Keep the default Anonymous login.
    8. In the Reply-To box, type doNotReply@example.com.
    9. Leave the Advanced box blank.
    10. In the Test Recipient box, type dba@example.com.
    11. Select Test to verify the SMTP server delivers the email to dba@example.com.
    12. Click Apply.
  4. In the Alert Setup portlet, create an Action Set.
    1. From the Setup Options list, select Alert Presets.
    2. From the Preset Options list, select Core Hours.
    3. Verify the core hours are correctly set for your environment.
    4. Under Database User Alerts, select User Mapping.
    5. Select the system.
    6. Enter the username and password.
    7. Enter the table or view name as configured in the selected Teradata Viewpoint system. Refer Database User Alerts for details.
    8. Verify the test.
    9. Click Apply.
  5. In the Workload Designer portlet, create a period event that triggers the alert email.
    1. From the For System list, select TEST1.
    2. Select "".
    3. From the General tab, in the Name box, type TEST1_alert_email.
    4. Click Save.
    5. From the ruleset toolbar, click States.
    6. Hover over Planned Events, and click "".
    7. Select "" next to Available Events.
    8. Select Period Event.
    9. In Event Name, type CoreEnvironment.
    10. Select Create New Corresponding Planned Environment to automatically create a planned environment that this event triggers.
    11. Select Day of Week, and select all weekdays.
    12. Select Start Time, with a 9 am Start Time and 5 pm End Time.
    13. In the Exceptions, after configuring the exception criteria, select only Abort/Abort Select from Actions.
    14. Select Notify Database User from Notifications.
    15. Click OK.
    16. Select Close.
    17. Click Save.
  6. In the Workload Designer portlet, activate the ruleset.
    1. Under Working, select the TEST1_alert_email "".
    2. Select Make Active.
    3. In the Confirm Activation Request dialog box, select Activate.
  7. In the email inbox for the account dba@example.com, check for messages from doNotReply@example.com.
    The alert collection upon TDWM abort happens from Alert Request Collector rate.