Add or Copy Alerts | Teradata Viewpoint - Adding and Copying Alerts - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
After you configure a system in Teradata Viewpoint, you can add an alert. Available alert types differ depending on the type of system you choose.

Because you can migrate alerts only when no alerts currently exist in Teradata Viewpoint for a Teradata system, migrate existing Teradata Manager alerts before adding and copying alerts.

  1. From the Systems list, select the name of the system you want to update.
  2. From the Setup list, select Alerts.
  3. From the Alert Types list, select an alert type.
  4. From the Alerts list, do one of the following:
    • Select "" to add an alert.
    • Select "" in the row of the alert you want to copy.
    • Select the name of the alert you want to edit.
  5. Enter a name for the alert.
  6. [Optional] Select the Enable alert check box to enable the alert.
  7. Under Severity, select a severity from the list.
  8. Under Alert Rules, do the following:
    Alert Type Trigger
    • Canary Queries
    • HDFS
    • MapReduce (HDP 1.3)
    • Node
    • Process
    • Query
    • System
    • Vproc
    • YARN (HDP 2.1 and later)
    1. Under Thresholds, select a scope to apply to the defined rules.
      • All requires all criteria match to trigger the alert.
      • Any requires any one criterion match to trigger the alert.
    2. Select a metric from the list and enter a threshold value.

      You can add "" or remove "" rules.

    3. [Optional] Enter the number of minutes in the Only trigger if alert rule(s) are met for box.

      The alert triggers if the rule is true for the number of minutes that you entered.

    • Data Collectors
    Select one or more data collectors from the Available box and select "" to move the data collectors to the Selected box.

    The alert triggers if any errors are encountered by the DCS for the selected data collectors.

    • Database Space
    1. Under Threshold, select a metric and enter a threshold value in the box that appears.

      The alert triggers if the metric exceeds the value that you enter.

    2. [Optional] Select "".
    3. Select one of the following to include or exclude databases when triggering the alert:
      • All databases except the selected databases below
      • Only the selected databases below
    4. If you want to filter the list of databases in the Match string box, do any of the following:
      • Type a value.
      • Use the * wildcard character to match zero or more characters in the position it occupies. Type this symbol at the beginning, middle, or end of your search. This wildcard character can be used more than once in the same search.
      • Type a wildcard statement.
    5. If you entered values in the Match string box, do one of the following:
      • Select "" to move the values to the Selected databases box.
      • Select "", located to the right of the box, to clear the values.
    6. Select one or more databases from the Available databases box and select "" to move the databases to the Selected databases box.

      Use Ctrl or Shift to select multiple databases.

    The alert triggers if the metric conditions are encountered for the included or excluded databases or wildcard statements.

    • Events
    Under Alert Rules, the Database Restart metric is selected.

    The alert triggers if the database is restarted.

    • Manager
    1. Under Alert Rules, select one of the following:
      • Critical and warning to trigger an alert when an issue has a severity level of either critical or warning.
      • Critical only to trigger an alert when an issue has a severity level of critical.
    2. [Optional] Enter the number of minutes in the Only trigger if alert rule(s) are met for box.

      The alert triggers if the rule is true for the number of minutes you entered.

    • Session
    1. Under Thresholds, use the Match list to select a scope to apply to the defined rules:
      • All requires all criteria match to trigger the alert.
      • Any requires any one criterion match to trigger the alert.
    2. Select a metric from the list and enter a threshold value.

      If you set up an alert rule whose only condition is Sessions per User, only userName and sessionsForUser metrics are available when customizing Teradata Alerts alert actions.

    3. [Optional] Add "" or remove "" rules.
    4. [Optional] Select "" next to Users.
    5. Select one of the following to include or exclude users when triggering the alert:
      • All users except the selected users below
      • Only the selected users below
    6. If you want to filter the list of users in the Match string box, do any of the following:
      • Type a value.
      • Use the * wildcard character to match zero or more characters in the position it occupies. Type this symbol at the beginning, middle, or end of your search. This wildcard character can be used more than once in the same search.
      • Type a wildcard statement.
    7. If you entered values in the Match string box, do one of the following.
      • Select "" to move the values to the Selected users box.
      • Select "", located to the right of the box, to clear the values.
    8. Select one or more users from the Available users box and select "" to move the users to the Selected users box.

      Use Ctrl or Shift to select multiple users.

    9. [Optional] Under Users, select Ignore alert action if blocking and blocker user are the same.
      This checkbox is only visible when the Blocked Time alert is selected as the Thresholds option.
    10. [Optional] Select "" next to Account Strings
    11. Select one of the following to include or exclude account strings when triggering the alert:
      • All account strings except the selected account strings below
      • Only the selected account strings below
    12. If you want to filter the list of account strings in the Match string box, do any of the following:
      • Type a value.
      • Use the * wildcard character to match zero or more characters in the position it occupies. Type this symbol at the beginning, middle, or end of your search. This wildcard character can be used more than once in the same search.
      • Type a wildcard statement.
    13. If you entered values in the Match string box, do one of the following:
      • Select "" to move the values to the Selected Account Strings box.
      • Select "", located to the right of the box, to clear the values.
    14. Select one or more account strings from the Available Account Strings box and select "" to move the account strings to the Selected Account Strings box.

      Use Ctrl or Shift to select multiple account strings.

    The alert triggers if the metric conditions are encountered for the included or excluded account strings or wildcard statements.

    • System (QueryGrid only)
    1. Under Alert Rules, select one of the following:
      • Alert on all systems in QueryGrid.
      • Alert on selected systems in QueryGrid
    2. If you selected Alert on selected systems in QueryGrid, select one or more systems from the Available box and select "" to move the systems to the Selected box.
    3. Under Trigger for all issues of severity, select one of the following:
      • Critical and warning to trigger an alert when an issue has a severity level of either critical or warning.
      • Critical only to trigger an alert when an issue has a severity level of critical.
    4. [Optional] Select Alert only for active configuration if you want alerts issued on active versions (not on pending or previous versions) of the configuration for fabrics, connectors, links, communication policies, and networks.
    5. [Optional] Enter the number of minutes in the Only trigger if alert rule(s) are met for box.

      The alert triggers if the rule is true for the number of minutes that you entered.

    • System Health
    1. Select a health level from the Trigger if system health is this level or worse list.
    2. [Optional] Enter the number of minutes in the Only trigger if alert rule(s) are met for box.

      The alert triggers if the rule is true for the number of minutes that you entered.

    • Table Space
    [Optional] Under Table, do any of the following for the DBC.TransientJournal table:
    • Select the Current Perm check box and enter the amount of total permanent disk space the table is currently using.
    • Select the Skew check box and enter the percentage of uneven distribution of disk space used for the table across all AMPs.

    The alert triggers if the metric exceeds the value that you entered.

  9. Under Alert Action, do the following:
    1. [Optional] For session alerts only, select one of the following check boxes:
      • Abort Session

        This aborts the blocked database session after performing the selected alert action.

      • Lower Priority

        This modifies the priority level for the database session while performing the selected alert action. The priority level is configured in the Session data collector under New priority for Lower Priority action.

      • Notify Session User

        This sends an email to notify the database session user, if database user alerts have been configured in the Alert Setup portlet.

      • Notify Session Proxy User

        This sends an email to notify the database session proxy user, if database user alerts have been configured in the Alert Setup portlet.

      • If only the selected threshold is set to Blocked Time, then the following check-boxes appear:

        • Abort Blocked Session

          This aborts the blocked database session after performing the selected alert action.

        • Abort Blocking Session

          This aborts the blocking database session after performing the selected alert action.

    2. [Optional] For database space alerts only, select the Notify database user check box to send an email to notify the database user, if database user alerts have been configured in the Alert Setup portlet.
      This option uses the database name alert property to map to an email address.
    3. Select an alert action from the Action list.
    4. Type a limit for Do not run twice in ... minutes.
      The alert action does not run twice during the minutes that you entered. The alert action does not run more frequently than the data collector sample rate.
    5. [Optional] For session alerts only, select Group email by session user to send a single email that contains the IDs of each session matching the rule criteria.
      If you do not select this check box, a separate email will be generated for every session that matches the criteria.
  10. [Optional] Under Message, enter a message that appears when the alert action executes.
  11. Click Apply.
    If the operation is successful, "" appears. If the operation fails, "" appears. If you receive an error, verify that the settings are correct and try again.