This article is the official release announcement for Teradata Viewpoint/CAM 14.01 with an effective release date of October 12th, 2012. There are some great new features, in particular enhancements for usability, supportability, administration, and extensions to monitoring capabilities. We here at Teradata are really psyched with everything we brought you in this exciting TENTH Viewpoint release! Aligned with this release is also a new release of Teradata Data Lab 14.01. Check it out.

Summary

The primary themes of the Viewpoint 14.01 release are Teradata Aster monitoring, portlet resizing, and simplified high availability (HA) clustering but there is also new feature content for administrative aspects and monitoring features. Browser support has been updated to reflect support for Firefox 13, Chrome 19, Safari 5.1, IE 8.x and 9.x (no support for IE 6.x or 7.x versions). For localization, we now offer Simplified Chinese in addition to Japanese, to be released in December. If you have other Teradata solution portlets running in your environment, you should review the Viewpoint 14.01 consideration.  

Teradata Aster

Viewpoint's single operational view (SOV) monitoring has been extended to include support for Teradata Aster! As you will see, this was no lightweight implementation either. Planning this integration, Teradata wanted to leverage as many of the existing portlets as possible for easier navigation, familiarity, and support for the Viewpoint SOV strategy. So the following existing portlets were extended to include support for Aster:

  • System Health
  • Query Monitor
  • Capacity Heatmap
  • Metrics Graph
  • Metrics Analysis
  • Space Usage
  • Admin - Teradata Systems

However not all the needs of Teradata Aster's differing architecture made sense to put into an existing portlet. Therefore there are two new Aster specific portlets in this release. 

  • Aster Completed Processes
  • Aster Node Monitor  <Note, portlet renamed to "Node Monitor" in Viewpoint 14.10 as it also supports Hadoop with that release>

Integration into existing portlets do have differences for Aster however. For instance, the System Health portlet provides easy identification at the summary view with the new Aster symbol and then a similar but different set of metrics in the drill down:

Similarly, you will see different metrics for Teradata Aster in the Capacity Heatmap, Metrics Analysis, and Metrics Graph portlets. Query Monitor and Space Usage portlets offer differing report options and columns to display as shown below with Query Monitor.

The new Aster specific portlets addressed process monitoring and Aster's node architecture. Here is the summary and detailed drill down Aster Completed Processes portlet screens. Notice the SQL and Explain tabs which like Query Monitor offer export functionality. 

And here is the Aster Node Monitor portlet. Notice the hardware statistics tab leverages the Metrics Analysis portlet architecture including the new metrics export option.

Resizing

This feature shows much better on a large flat panel than it does in a DevX article. For those of you frustrated with Viewpoint and the amount of white space on your large monitors or flat panels, Viewpoint 14.01 will provide the long awaited relief you have been waiting for. Viewpoint remains a two column layout but the columns can now be resized / supersized using the drag handle (shown as double dashed lines). We do maintain a minimum size for a column however although we continue to support maximize if you want a portlet to utilize the entire dashboard. Here's a view of the drag handle within the two column architecture.

A related change to the new resizing capability is new visualization and initialization behavior for the ''rewind" bar. An example is shown below in the HA clustering section.  

High Availability Clustering

In the Viewpoint 14.01 release, HA clustering (Viewpoint and CAM combined) has become easier to implement, monitor, and extended in its automation aspects. As documented in the Viewpoint Configuration Guide, setting up a Viewpoint HA cluster is now as easy as running the new command-line tool that runs in just a few minutes. The command-line tool performs the following operations:

  • Asks a few simple questions about what hosts will comprise the cluster
  • Verifies that the software versions and times on the server match
  • Stops all the Viewpoint services in the cluster
  • Performs the necessary aspects for clustering
  • Restarts all Viewpoint services in the cluster

Once command-line tool completes, the setup of the standby Viewpoint server is handled automatically in the background with progress displayed in the new Viewpoint Notification Banner. The new banner, by default, is only displayed to Admin users although can be permissioned in the Roles Manager for other roles if desired. It will report that the setup is percentage complete, completed, or failed at a percentage. Here is the banner showing a progress percentage complete.

Other items worth noting on HA clustering:

  • Use the same command line tool for recovering a HA cluster after a promotion operation
  • Clustering WAN performance is improved as we leverage new record-based streaming replication
  • Automatic promotion is available for all failure scenarios including protection from network glitches

New Administrative Features

There are a number of ease-of-use enhancements to Viewpoint administration in this release. The first of these allows for an existing alerting infrastructure to be copied to another Teradata system. So instead of having to manually recreate alerts from scratch, you can now copy an existing alert setup to another Teradata system. This new feature can be found in the Admin - Teradata Systems - Alerts menu. There is a new "copy alerts" icon (circled) that brings up a list of Teradata systems to copy to as shown below.

There is a new configuration aspect for the System Health portlet to protect summary system health conditions from system CPU or I/O skews. This new setting can be found in the Admin - Teradata Systems - System Health menu, in the same location where one can adjust system health thresholds, system health threshold activation states, customize health condition status' and related tooltips. Below is a modified view showing all these options. For more information on the system health equation, check out the excellent "Understanding the System Health Equation" blog previously published by Viewpoint Architect, Steve Ratay.

The Viewpoint collection process requires that specific macros be available to run console utilities and that the collection user has the correct privileges on the Teradata System. Previously these privileges were documented in the Viewpoint configuration guide and had to be manually input. The necessary grants are now documented in the Admin - Teradata Systems - General menu for easy setup, test, or review. With the Grant selection, you have a Continue option that, after confirming your Teradata credentials, executes the grants for you. 

Although not new functionality, adding a user interface for setting the system default "Locale" and "Session Timeout" not only makes it easier to perform these operations but eliminates the need to login into Linux directly. These items are found in the new Admin - Viewpoint Config menu under the General tab. The system locale is used to enable the Japanese and Simplified Chinese localizations. Session timeout is the security setting to automatically expire idle Viewpoint sessions. 

The final administrative enhancement is the addition of a Certificates option, as shown in the Admin - Viewpoint Config menu above. This allows management of trusted certificate authorities (CA) and HTTPS certificates. 

New Monitoring Features

Some additional monitoring enhancements have been added to Viewpoint 14.01. The first of these is extension of the export capability to the trend and metrics portlets allowing this data to be pulled out of Viewpoint. Export is already available for portlets leveraging the data grid, for SQL, Explain, and Viewpoint user information. Export has now been implemented in the Capacity Heatmap, Metrics Graph, Metrics Analysis, Viewpoint Monitoring portlets as well as the Hardware Statistics drill down in the Aster Node Monitor portlet. Here is an example showing the export icon in the top right corner of the Metrics Analysis portlet.

Another feature extension is the addition of the "Update Space" operation within the Remote Console portlet. A description of what it does is included in the execution screen as shown below. 

Upgrade Consideration

As some of the foundational software has been upgraded to enable new features, other solution portlets will need to be upgraded at the time as the Viewpoint 14.01 upgrade. See below for other solution minimum versions necessary for compatibility with Viewpoint 14.01:

  • CAM 14.01.xx.xx
  • Teradata Data Lab 14.01.xx.xx
  • Teradata Multi-System Manager (TMSM) 14.00.02.xx
  • Teradata Data Mover 14.00.00.03 

Those of you using the PDCR portlets (Teradata Professional Services offering), should contact your CS/PS representative for recommendations of how best to proceed with those portlets. 

As with any Viewpoint upgrade, please reference the associated Viewpoint Configuration Guide for full details of the upgrade process. 

That's Teradata Viewpoint 14.01, a plethora of feature additions across a number of strategic areas. Let us know what you think. Also don't forget to check out the Data Lab 14.01 release article if that interests you. Thanks.

 

Discussion
robpaller 16 comments Joined 05/09
10 Oct 2012

This update and the Data Lab Portlet updates look great!

ratnamch 3 comments Joined 06/12
01 Nov 2012

thank you

ery helpfull

mahendra.s 1 comment Joined 09/12
08 Nov 2012

Is there an Option in viewpoint to copy graphs out of Viewpoint and copy it to Spread sheet ?

gryback 132 comments Joined 12/08
08 Nov 2012

Not directly. Taking a print-screen screenshot can be used to show the actual graph outside of Viewpoint. Then as mentioned in this release article, you can now export the data from metrics portlets that could then be used to create a customized graph outside of Viewpoint.

MK_TD 1 comment Joined 11/11
20 Nov 2012

Hi Gary,

Thanks for the informative post, is there a compatibility matrix that we can access in regards to Viewpoint vs. Data Mover etc ?
Cheers

gryback 132 comments Joined 12/08
20 Nov 2012

MK,

There is an internal compatibility matrix we maintain for CS. Send me an email within Teradata and I can provide you more information.

Gary

19 Dec 2012

Gary,
Can viewpoint be used in geneating day to day usefull reports.Please give a brief idea.We have teradata viewpoint 14.01

Meenakshi Swami

gryback 132 comments Joined 12/08
19 Dec 2012

I guess it depends on what you define as daily useful reports. The "Todays Statistics" portlet provides a list of metrics for the last hour and since midnight for system, query, and performance metric categories. Which category you want would be selected in preferences under the metrics tab. "Metrics Analysis" has a "1 day" option for plotting on metrics for a particular day as does "Alert Viewer" for showing the alerts that have triggered in the last day. "Query Spotlight" allows one to find potentially bad queries over different time durations including the last 24 hours. So those are a few you could consider for useful daily reports.

geethareddy 104 comments Joined 10/11
07 Jan 2013

Hi Gary,

We are on 14.01 VP, i used Remote console for several utilities, i remember the export option in previous version to export the output log of the utils (but no sure). I didnt see that option to export in 14.01. I think it is good to have export option in order to share the log especially while showing the proofs especially for some specific utilites, like in the case of rcvmangaer/qrysessn utilites etc. It is just my thought.

Thanks,
Geeta.

Thanks,
Geeta

gryback 132 comments Joined 12/08
07 Jan 2013

An export option for Remote Console is a future releases consideration. I agree that it would be a useful addition.

geethareddy 104 comments Joined 10/11
07 Jan 2013

Great, thanks.

Thanks,
Geeta

JPawling 2 comments Joined 08/05
23 Jan 2013

Hi Gary,

I was wondering if the Alerts (Session) in VP 14.01 allows for running the alert only outside of core hours?

We're currently on VP 14.00 and I'm trying to develop a alerting mechanism for Idle SQLA user sessions but only outside the core hours. We might implement Abort in the alert as well.

John P

John

Shrity 32 comments Joined 05/12
23 Jan 2013

John,

Yes you can. When you define an "action set" in "Alert setup" you get three options "Core", "Evening" and "Weekends" You can choose "Evening" or "Weekends" or both as per your need. Below is the definition of "Evening" or "Weekends" options.

EVENING HOURS: The hours opposite Core Hours for core days.
WEEKEND HOURS: The ending time of the ending core day to the beginning time of the beginning core day.

You could define a new action set selecting "Evening" or "Weekends" or both as per your need and then in session alert select the newly created action set.

Thanks
Shrity

JPawling 2 comments Joined 08/05
23 Jan 2013

Thanks Shrity. I have tried this. I have those hours defined and the Action Set set up for the emailing not selecting core hours, but the Abort Session is only defined in Viewpoint at the Teradata System|Setup|Alert Type|Session. Your suggestion would work if I could only enable the abort at the Action Set level.

What I was hoping was in VP 14.01 there would be an extension of the type of Action Sets that can be defined. I was hoping for ABORT in addition to eMail, SNMP, SQL, BTEQ, or "Run a program".

John

Shrity 32 comments Joined 05/12
23 Jan 2013

I see.. so you also want to abort the session. In that case yes abort can get triggered 24X7 and we don't have ABORT option as an Action Sets in Viewpoint 14.01.

Thanks
Shrity

geethareddy 104 comments Joined 10/11
24 Jan 2013

Hi Gary,
As i said before we are on recent version of VP 14.01.
Now a days we are observing the querymonitor showing several demographics in negative values. (So far we saw negative PJI, negative IO and negative spool, negative CPU like that). We are seeing once in a while for one particular session, it is reporting for a while for few sessions and reporting for 1 to 2 days for batch jobs. Not all the issues are appearing in issue. But individual negative values are appearing in individual sessions.
I know there is a concept of negative perm for dbc. but never heard above IO, CPU, PJI etc in negative values. I believe there should be something wrong with the VP gui. Can you please share your thoughts on this?

Thanks,
Geeta

gryback 132 comments Joined 12/08
24 Jan 2013

My thought is that this needs to be submitted to the Teradata Support Center for analysis and explanation. Sorry.

geethareddy 104 comments Joined 10/11
17 Feb 2013

I am posting the below question here as my question belongs to the 14.01 version,

This is about the NODE DOWN alert in Viewpoint.
We recently saw the node down (3-02) issue on our production box, we recieved an alert on the same. But after couple of days, another node went down (4-02) and the first down (3-02) came online. But still VP showing the same alert (with Subject of the email like this:[Alert] PRODUCTION - Node Down (Source: Viewpoint, Type: Node)

****Body of the email looks like this****
Event Timestamp: 2013-02-13T14:02:11.640-07:00

Proc ID=98
Node ID=3-02
Status=D
CPU Use=
Disk Use=
Network A Use=
Cic Use=
Disk Outage Request Average=
Disk IO=
Host IO=
Swaps=
Memory Failures=
Average Node CPU Usage=14.761381
Average Node Disk Usage=97.31792
System Network A Use=58.241455
Node CPU Skew=3.1299293

Description: (Status = D)

***My question is***,
Is there any way we can see the node name (or number) in the email, so that we can have some idea about the exact node which is down currently on the system.
Something like a this in the subject line: "PRODUCTION - Node Down (Source: Viewpoint, Type: Node-2-03)" instead of "PRODUCTION - Node Down (Source: Viewpoint, Type: Node)"

Thanks,
Geeta.

Thanks,
Geeta

geethareddy 104 comments Joined 10/11
06 May 2013

Hi Gary,

I have been noticing my production box workload designer porlet is getting lengthier under the Local section with older versions rule sets. It is the length of 3 to 4 page downs. I know we can get rid of some of the older versions, but just want to know having them on that local section with extended length porlet can cause any impact?
 
Thanks,
Geeta.

Thanks,
Geeta

gryback 132 comments Joined 12/08
07 May 2013

Geeta,
No real impact other than making it cumbersome to navigate through. There is a delete option if you want to get rid of some that are no longer useful.
Gary

geethareddy 104 comments Joined 10/11
07 May 2013

Thank you Gary.

Thanks,
Geeta

geethareddy 104 comments Joined 10/11
26 Jul 2013

hi Carrie/Gary,
I was looking at the metrics analysis portlet for wait IO. I can see AVG, MAX & MIN over there, I think i should consider the "AVG Wait CPU" as the right one instead of taking "MAX Wait CPU". I am trying to understand to match the VP display with SAR command output during that period. Please correct me if I am wrong.
 
And when i tried to export the data for one particular range, for ex: 07-19-2013 to 07-20-2013, it is exporting the data in to the .csv file, but when i open the file i can see the data for whole period from when we enabled the Viewpoint.
Thank you,
Geeta.

Thanks,
Geeta

gryback 132 comments Joined 12/08
29 Jul 2013

Geeta,
For the Metrics Analysis portlet, the available metric to use would be "Wait I/O CPU".
Export should only be exporting the data for the chosen duration in the Metrics Analysis header bar so for instance 1 hour, 1 day, 1 week, etc even if you are using Rewind to look at a duration in the past. If you are exporting for a 1 day duration and it is bringing back more than one days worth of data, you should submit this as an incident for analysis. 
 

geethareddy 104 comments Joined 10/11
29 Jul 2013

Thanks Gary, i created an incident.

 

Thanks,
Geeta

geethareddy 104 comments Joined 10/11
15 Oct 2013

Hi Gary,
I heard Viewpoint 2.0 will be announced @ Partners 2013, Dallas TX.
Is that advnaced version to 14.10?

Thanks,
Geeta

gryback 132 comments Joined 12/08
16 Oct 2013

Viewpoint 2.0 is more of an internal naming convention around a new Viewpoint foundation release. This will be released as the next Viewpoint version release but has a whole new look and feel. See more at Partners.

geethareddy 104 comments Joined 10/11
16 Oct 2013

Sure, eager to see the new one.

Thank you for the clue.
 
Geeta.

Thanks,
Geeta

You must sign in to leave a comment.