Teradata Alerts / CAM 14.0 released

Viewpoint
Teradata Viewpoint is Teradata's strategic and innovative SOV (single operational view) for Teradata DB, Aster, and HDP Hadoop systems management and monitoring that enables Teradata's Unified Data Architecture (UDA).
Teradata Employee

Teradata Alerts / CAM 14.0 released

Teradata is pleased to announce the Teradata Alerts / Common Alerting Mechanism (CAM) 14.0 release effective March 14th, 2012. A few of the key feature additions include running actions on Linux, a new "run SQL" action, incremental backups, and usability updates to the Alert Viewer portlet.

Overview

Prior to the Viewpoint 13.12 release, Teradata Alerts also known as CAM was part of the Viewpoint foundation and therefore directly aligned with new Viewpoint releases. As more solutions leverage Viewpoint portlets for their user interface, the more these solutions are looking to leverage the alerting foundation as well. This is the "common" portion of the CAM acronym. As such, we needed Teradata Alerts to be an independent release cycle to allow flexibility in addressing all solution alerting needs. So Teradata Alerts was separated from Viewpoint bundling and release cycles as of the 13.12 releases. The remainder of this article will discuss the feature enhancements being released as part of the Teradata Alerts / CAM 14.0 version.

Release Summary

There are some really nice feature enhancements in the Teradata Alerts 14.0 release. One that has been a popular customer request for some time is offering the Teradata Notification Service on Linux. This provides the ability to have alert actions run off a Linux server instead of Windows which was the only option previously. The alerting infrastructure now offers running a SQL statement as a new alert action complimenting the existing email, SNMP, and other actions. The Alert Viewer portlet was enhanced to adopt some common portlet features as well as displaying errors that have occurred when processing an alert action. The last major feature addition to the Alerts 14.0 release being discussed is support for the incremental backup process implemented with the Viewpoint 14.0 release. 

Teradata Notification Service on Linux

With Teradata Alerts / CAM 14.0, customers can now choose between having the Teradata Notification Service run on Windows or Linux. Windows was the initial priority as we had to allow an easy migration from Teradata Manager which only offered the Windows operating system for the notification service. With the 14.0 release, support for a Linux based server is now available for running BTEQ scripts and executable programs as alert actions. Some considerations for this new feature:

  • This is only required if there is the need for Linux based alert actions
  • The supported Linux operating system options are SLES10 SP3 or SLES11
  • The hardware is a customer provided server
  • The Viewpoint Server should NOT be used for the Notification Service

Please refer to the Teradata Alerts 14.0 Installation and Configuration Guide for more information including installation aspects of this this new Linux offering. Worth mentioning, the Notification Service for Windows is also covered in that same guide. 

"Run SQL" Alert Action:

Teradata Alerts 14.0 now offers "run SQL" as an additional alert action option. To use this new option, you will need to perform configuration in the Viewpoint Admin "Alert Setup" menu.

The first step will be to have the Viewpoint or Teradata system administrator create a login under the Viewpoint Admin -> Alert Setup -> "BTEQ/SQL Login" menu option. This is required before you can create an action set that runs a BTEQ script or SQL action.

You then create the specific SQL queries you want available under the Viewpoint Admin -> Alert Setup -> SQL Queries menu option.  These queries can then be referenced when creating alert action sets in Alert Presets -> Action Sets

Finally, the alert Action Sets can then be referenced in other solutions that integrate with Teradata Alerts.  For example, when setting up specific alert triggers in the Admin -> Teradata Systems -> Alerts menu option.

Here is a view of these new options in the Alert Setup menu:

Alert Viewer Portlet Enhancements:

The Alert Viewer portlet has adopted some useful common portlet features in the 14.0 release. These include previous/next navigation at the alert detailed view, paging mechanisms for better management of numerous alerts, and addition of the "tall" / vertical resizing capability. See the screen shot below with the new previous/next buttons and vertical resize option in the portlet footer.  

The other feature addition mentioned related to the Alert Viewer portlet was the addition of the logging and display of issues when processing an alert action. For example, an email alert action was not successful because the SMTP email server was down and therefore the email send was unsuccessful.


Incremental Backups:

Starting with the Teradata Viewpoint 14.0 release, backups are performed incrementally including the alert log data. Incremental backups allow for efficiencies in both the backup and restore processes. Because log data is backed up incrementally, smaller portions of the data can also be restored. Specifically, you now have restore options for the configuration data, current data, historical data, or everything. There is more information on backups and restores in the Teradata Alerts 14.0 Installation and Configuration Guide

Conclusion:

Those are the main feature additions for this release. There are a couple minor additions worth mentioning as well. For email alerts, the recipients are now listed in the “To:” section of the email for easy identification. For SNMP traps, we added the ability to send the the alert message along with the trap providing more information to the SNMP destination. To read more about all the features of Teradata Alerting, please refer to the updated Teradata Alerts User Guide. Lastly for solution compatibility, installation of Teradata Alerts 14.0 requires a Viewpoint 14.0 or newer instance. 

Tags (4)
19 REPLIES
Enthusiast

Re: Teradata Alerts / CAM 14.0 released

Another useful and helpful enhancement. We used to run scripts to capture sql,abort session and alert user with the aborted sql. we missed that capability since we moved to viewpoint.This new feature with viewpoint revives that capability, now that we could do this on Linux through one of the TMS.
Teradata Employee

Re: Teradata Alerts / CAM 14.0 released

I don't understand why you lost that ability. Since transition from Teradata Manager, the alerting has continued to support "run program" from a Windows based server. This release just extended that to allow for Linux also.
Enthusiast

Re: Teradata Alerts / CAM 14.0 released

Gary,this was not a technical issue,just aa architecture situation since we gave up the windows servers after moving to Viewpoint and hence the disadvantage.
Teradata Employee

Re: Teradata Alerts / CAM 14.0 released

Ok, that makes sense.
Fan

Re: Teradata Alerts / CAM 14.0 released

Gary,
one of the biggest issues we have with viewpoint alerting is that it does not get the real events from the system. For example, relying on a canary query to tell if the system is up or down, and not being able to alert on things like a dbs restart. Is there any plan to incorporate some of those tvi alerts in to viewpoint? We are currently pursuing using functionality on the SWS machines to fire SNMP alerts for us, as Viewpoint does not meet all of our needs, but we would much rather have everything in once place.

thanks!
Teradata Employee

Re: Teradata Alerts / CAM 14.0 released

Actually the vast majority of Viewpoint alerting is dependent on the Teradata system, not Viewpoint collections. The canary query is used for several purposes, to see if the performance is degraded, or if Viewpoint can connect to the Teradata system. So that System Health alert for system availability is triggered if Viewpoint can't talk to the Teradata system which could be just a network issue. So yes, that can give some misconceptions about the Teradata system. The reason we didn't have a better mechanism for alerting on a Teradata restart is because we had no universal mechanism to do this. What I mean by that is we had a log entry on MP-RAS that could have been used but this didn't transition to Linux initially. This is now resolved with the Database allowing us to pursue the restart alert. Looking at trying to get that implemented in the next year.

Re: Teradata Alerts / CAM 14.0 released

A couple of different but related questions...
Does anyone know of a way within the alert system in Viewpoint to determine if a blocked user/process begins with a specific letter or symbol? Basically we want to send an alert if a production job (starting with 'P' or 'M') is being blocked.

We currently call a VB program in TD Manager (we are on TD 13.0) to determine if the blocked job is a production job and if so send an alert. Our program currently reads the TDM alert.log file to find the block information. We understand that we may need to call this program or a version of it within VP to get the desired results. We have downloaded the Teradata Notification Service to a window server and the service is running. However, we are not sure how to get the data we need from VP. Data such as the blocker and the blockee. Has anyone done this or can anyone help us with this issue?
Teradata Employee

Re: Teradata Alerts / CAM 14.0 released

Our roadmap plans will support this in the future. This new feature is to offer a "only these users" filter for blocked sessions that would support wildcards. Your use case would be implemented through two alerts, one for "P*" and one for "M*"
Enthusiast

Re: Teradata Alerts / CAM 14.0 released

Is there any alert mechanism that exists now to notify if large chunk of data is getting redistributed?