Database User Alerts | Teradata Viewpoint - 16.20 - 16.50 - Database User Alerts - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)
You can set up an alert action so that the database user is notified by email if there is a session or database space alert.
Notification Type Description
Domain suffix Define an email domain suffix to append to the database user name. For example, if you define teradata.com as the suffix, the database user user1 is emailed at user1@teradata.com
User mapping Define a database table or view from which Viewpoint selects and return two columns, username and email address. This approach requires that the Database Administrator creates a table or view before the database user alert is configured. The Database Administrator adds rows for specific users to receive emails. Both set and multiset are supported with Latin and Unicode as supported character sets. NOT NULL is not supported. The following example shows a sample table with a username and email.
CREATE MULTISET TABLE sysdba.user_mail ,FALLBACK , 
NO BEFORE JOURNAL, 
NO AFTER JOURNAL, 
CHECKSUM = DEFAULT, 
DEFAULT MERGEBLOCKRATIO ( 
Username VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC, 
EmailAddress VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC) 
PRIMARY INDEX ( Username );

The User mapping option requires the credentials to execute the query. The results of the query are cached and updated by Viewpoint once a day.

After database user alerts are configured in the Alerts Setup portlet, they are available in the Monitored Systems portlet for session and database space alerts.