16.50 - Database User Alerts - Teradata Workload Management

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
16.50
created_date
January 2021
category
User Guide
featnum
B035-2206-107K
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.