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

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
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.

Enable Ldap Database User Alerts Choose this option if LDAP configuration has been set up on the LDAPServers Admin Portlet, and the corresponding database, for which alert functionality is required. Note that alerts are only sent if the LDAP user has previously signed on to Viewpoint.

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.