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.
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.
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.
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.
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:
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.
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.
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.