Database User Alerts | Teradata Viewpoint - Database User 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
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.