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.
- From the Systems list, select the name of the system you want to update.
- From the Setup list, select Alerts.
- From the Alert Types list, select an alert type.
- 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.
- Enter a name for the alert.
- [Optional] Select the Enable alert check box to enable the alert.
- Under Severity, select a severity from the list.
-
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)
- 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.
- Select a metric from the list and enter a threshold value.
You can add or remove rules.
- [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
- 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.
- [Optional] Select .
- 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
- 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.
- 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.
- 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
- 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.
- [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
- 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.
- 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.
- [Optional] Add or remove rules.
- [Optional] Select next to Users.
- 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
- 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.
- 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.
- 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.
- [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.
- [Optional] Select next to Account Strings
- 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
- 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.
- 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.
- 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)
- Under Alert
Rules, select one of the following:
- Alert on all systems in QueryGrid.
- Alert on selected systems in QueryGrid
- 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.
- 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.
- [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.
- [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
- Select a health level from the Trigger if system health is this level or worse list.
- [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.
-
Under Alert Action, do the following:
-
[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.
- Abort Blocked Session
- Abort Session
- [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.
- Select an alert action from the Action list.
-
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.
- [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.
-
[Optional] For session alerts only, select one of the
following check boxes:
- [Optional] Under Message, enter a message that appears when the alert action executes.
-
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.