PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

Viewpoint Alerts !!

Using Viewpoint Alerts

  • Before setting up Viewpoint alerts, make sure you have:
  • Installed a Teradata Viewpoint server and connected it to your system.
  • Enabled the RSS data collection system on your Teradata system.
  • Created the Teradata Viewpoint server logon user (viewpoint) in the database and given it the privileges necessary to logon and execute database monitoring and management functions.
  • Configured at least one administrative user to access and administer Teradata Viewpoint and enabled the Viewpoint data collectors.

You can configure Teradata Viewpoint to perform alert actions when the database achieves or exceeds certain defined thresholds. You can specify the following alert actions individually or in any combination:

  • Write a message to the alert log
  • Send an email message to a specified address
  • Communicate the alert to a specified third-party application
  • Run a specified BTEQ script or other program

Each alert action set has a unique name and is triggered according to the rules for any alert that specifies the action set name.

Creating Alerts

A Teradata Viewpoint alert is based on:

  • A threshold specified for a monitoring parameter, for example, when a database exceeds 95% space usage.
  • The time period during which the parameter must be over threshold to invoke the alert.
  • The name of an Action Set, for example, the alert notification, which defines who should receive the alert, and how the message is delivered.
  • A message that the system delivers to the list of users defined in the Action Set, if the threshold and time criteria are met.

To configure a sample alert:

  • From the Teradata Viewpoint main portal, selectAdmin>Teradata Systems.
  • From the Setup menu, selectAlerts, and then configure an alert, for example, a System Health alert that sends a message if the system is down, similar to the following example.
  • Check theEnabled box and click Apply.

Setting Up Alert Actions

The alert setup defines alert notification parameters and alert actions.

  • From the main Teradata Viewpoint portal, selectAdmin>Setup.
  • UseDelivery Settings/Email to configure communication with the host SMTP email server.
  • Select the Teradata system for which you are configuring the alert.
  • UseAlerts Presets/Action Sets to set up common alert actions, for example, an email message to all administrative users. Then you can set up monitoring parameters that invoke the associated alert action whenever Teradata Viewpoint detects that a parameter was exceeded.

Note: Specifying one or more roles in the action sends an email to each role member and is the most efficient way of identifying email recipients. You can list email addresses for any recipients that are not Teradata Viewpoint users.

Setting Up Teradata Viewpoint Alerts for Space Usage

You can use Teradata Viewpoint to regularly monitor space usage, and catch most space problems. However, it may be useful to setup a few alerts in areas where space problems can seriously affect database function.

The following table contains some examples of common space usage alerts.

Add a Comment

Your email address will not be published. Required fields are marked *