Adding and Copying Alerts

Teradata Viewpoint User Guide

brand
Analytical Ecosystem
prodname
Teradata Viewpoint
vrm_release
16.00
category
User Guide
featnum
B035-2206-106K
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 Database system, migrate existing Teradata Manager alerts before adding and copying alerts.

  1. From the Systems list, click the name of the system you want to update.
  2. From the Setup list, click Alerts.
  3. From the Alert Types list, click an alert type.
  4. From the Alerts list, do one of the following:
    • Click to add an alert.
    • Click in the row of the alert you want to copy.
    • Click 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 menu.
  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 click to move them 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] Click .
    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:
      • Click to move it to the Selected databases box.
      • Click , located to the right of the box, to clear the values.
    6. Select one or more databases from the Available databases box and click to move them 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 Teradata 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 that 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] Click 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.
      • Click to move it to the Selected users box.
      • Click , located to the right of the box, to clear the values.
    8. Select one or more users from the Available users box and click to move them to the Selected users box.

      Use Ctrl or Shift to select multiple users.

    9. [Optional] Click next to Account Strings
    10. 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
    11. 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.
    12. If you entered values in the Match string box, do one of the following:
      • Click to move it to the Selected Account Strings box.
      • Click , located to the right of the box, to clear the values.
    13. Select one or more users from the Available Account Strings box and click to move them 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 click to move them 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 Teradata Database session after performing the selected alert action.

      • Lower Priority

        This modifies the priority level for the Teradata 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 Teradata 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 Teradata Database session proxy user, if database user alerts have been configured in the Alert Setup portlet.

    2. [Optional] For database space alerts only, select the Notify database user check box to send an email to notify the Teradata Database user, if database user alerts have been configured in the Alert Setup portlet. This option will use 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.
  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.