Teradata is pleased to announce the official release of Teradata Viewpoint 13.11 effective December 17th, 2010. The fourth release of Viewpoint in 2010!

The primary focus of this Viewpoint release is the "Query Spotlight" portlet for super-advanced system and query analysis. However this release also includes a variety of improvements and feature advancements spanning many of the existing Viewpoint portlets. The Viewpoint 13.11 release also represents an integration of patch releases into the base packages.

Summary

The major portlet addition in the Teradata Viewpoint 13.11 release is Query Spotlight. Teradata Viewpoint has been excellent in providing customers the ability to review queries and their resource usage real time and also at any point in time with "Rewind". Query Spotlight now extends this monitoring to durations of time and offers the ability to initiate "Rewind" as part of that analysis. A powerful tool that changes the way DBAs perform system analysis! Other new features of this release include vertical resizing and data export capability for several portlets, new Admin permissions for roles, a new more efficient incremental backup, and native support for IE8.x. There are also significant improvements to the System Health, SQL Scratchpad and Query Monitor portlets. More details to all these feature additions can be found below.

Query Spotlight

The Query Spotlight portlet allows one to view completed queries that exceeded configurable thresholds, individual queries of interest as a line graph over time against a variety of metrics, and at any point in time with the snapshot tab. The first thing to setup is the configurable thresholds under preferences. For example, here is a preferences view with thresholds set and enabled for request CPU and spool space.

  

The preferences settings determine the qualifications for what queries to display. The second aspect to an initial setup would be choosing the Teradata system and time frame to display from the selection menu. In the screenshot below, the Teradata system Cayenne was selected with a last 24 hours duration. Note the "Custom" option which allows a configurable time duration when necessary.

  

The summary display of queries will then look and act very similar to the Query Monitor portlet including configurable column displays, threshold settings for highlighted entries, column filtering and sorting functions. The "Start" display column, shown above, now becomes more relevant considering extended time durations. Where things get really interesting is when drilling down to the details view of a query in Query Spotlight. The details view displays a graph, statistics and information about a selected query and is described as follows in the on-line help.

  

  Notice the metrics list for choosing a metric to display, the (SQL, Explain, Blocked By) tabs similar to those in Query Monitor, the date-range slider similar to the one used in Capacity Heatmap or Metrics Graph portlets. The date-range slider appears for longer queries to control the amount of data displayed in the graph. The Time Marker (which can be dragged to different times) pinpoints information about a query at a particular point in time and is used to rewind time when Control Rewind is selected. This is the first portlet that can automatically direct "Rewind" to a point in time where other rewind-able portlets on the dashboard will travel back to. That is cool and a significant breakthrough feature for system analysis. As mentioned, this is a significant portlet addition to the Teradata Management Portlets.

Vertical Resizing / "Tall" Portlets

The table display portlets (Query Monitor, Space Usage, Lock Viewer, Query Spotlight, etc) now allow vertical resizing to allow for more or less screen space for display. This is a simple drag operation on the portlet footer, circled below, for custom resizing. Notice the other icon in the footer that allows for resetting the portlet height to the default.

Export Capability

The other table display portlets feature enhancement is the data export capability. This allows exporting the current data set to a comma-separated values (CSV) file for whatever external reporting or analysis operations one may want to pursue. Also notice that this new menu interface incorporates the configure columns (change display), clear filters operations as well as the tools bar for query portlets.

Admin Permissions

Permissions have been added to the Admin menu options to allow for distributed management by Viewpoint users not in the Administrator role.  For instance, one could allow another group to manage the Viewpoint backups or LDAP configuration. These new distributed permission settings are in the Admin -> Roles Manager, under the Portlets tab. Note that the Portlet Library, Roles Manager, and User Manager remain reserved for Viewpoint administrators so the ones with the new permission option are shown checked below.

  

Incremental Backup

Viewpoint 13.11 implemented a modified backup process for the Teradata Viewpoint DCS database. The original version of the backup process created a single instance backup run on a daily basis. This served the purpose of providing a full backup should a database failure occur. However, for customers with large DCS instances, this process could take multiple hours to execute and can impact Viewpoint performance due to the high I/O activity of the backup. The new design only backs up the collected data tables that have changed since the last backup although the configuration data will continue to be completely backed up on a daily basis. This new architecture improves performance, saves space, and allows flexibility in data restores.

System Health

The System Health portlet has new functionality that will assist DBAs and the entire Viewpoint user community in better understanding Teradata system status. The first new feature is the ability to drill down on the "Component Down" metric to view the list of component types and the number of components affected. When there is a component issue, the Component Down description becomes a highlighted underlined link to the additional information as shown below:

  

The other new feature of System Health should prove to be very beneficial to many customers. This is configurable system health descriptions. No longer does one have to use Healthy, Degraded, and Critical for system status conditions. The pop-up messages can also be tailored. This is done in the Admin menu under Teradata Systems and the System Health option, the same location for setting custom thresholds. Here's an example of customizing the descriptors with custom status conditions of Fair, Busy, and Slow.

  

This results in the user experience with System Health at the summary level with the custom descriptions shown here.

  

The custom descriptions are also used at the detailed level when viewing threshold details.

  

 

So create the health descriptions and messaging you want if you so desire.

SQL Scratchpad

SQL Scratchpad has been a valuable portlet and in particular as an important self service feature of Viewpoint. As its usage continued to increase, it was time to evaluate how to improve the overall experience with this portlet. It starts with a cleaner initial view that includes easy selection/switching of Teradata systems and new buttons for various operations. The "Load" button enables the object browser and also allows viewing of saved queries and query history. The "Run" button allows query execution and saving of queries. 

So a cleaner more intuitive interface but more importantly, one should notice a drastic improvement in performance. The underlying Viewpoint architecture was re-engineered for more efficient display and results processing. Lastly, this version allows for larger results sets, no longer restricted to the 500 row limit. So enjoy!

Query Monitor

In addition to the table portlet changes described above, Query Monitor incorporated additional new features. These include the new "Not Idle" selection option, a blocking navigation tree, the ability to export the SQL and explain plan. The explain export capability is also available in the My Queries and Query Spotlight portlets.

Often customers want to view all the queries on the system doing something, in other words all queries that are not idle. So a "NOT IDLE" selection option has been added for this convenience.

The blocking navigation tree provides the ability to traverse through multiple blocked queries. For instance, if query-A blocks query-B and query-B blocks query-C, the owner of query-C will be able to easily navigate all the way back to find the root cause, in this scenario query-A. This is done by making the blocked query information a link to that actual query. Then as one traverses through the blocking tree, each of the sessions are listed in the portlet as shown below where 3574232 is blocked by 3574265 but 3574265 is blocked by 3574269 which is a link that can be followed to that query.

The new export capability for the explain plan is initiated in a new button under the Explain tab, shown below next to the "Export Explain" help pop-up.

And worth mentioning again, this release now supports Internet Explorer 8.x versions natively.

That is quite a bit of content considering this is the fourth Viewpoint release in 2010. It has been quite a year for Viewpoint!

Discussion
emilwu 34 comments Joined 12/07
20 Dec 2010

finally the block traverse!!!!

sixpakvb 1 comment Joined 05/09
22 Dec 2010

As a DBA in Managed Services, I have loved the new features and capabilities that have come out in Viewpoint over the last year. Keep it coming!!

Matthew Lipke
Senior Services Offer Manager
Teradata Global PS
Teradata 14 Certified DBA & Enterprise Architect
Cellular  :           515-974-9120
E-Mail  :      matthew.lipke@Teradata.com

gryback 151 comments Joined 12/08
30 Dec 2010

Another feature I forgot to mention. Within the Admin -> Portlet Library, "Shared" portlets now have a new column informing the DBA of the parent portlet, the original portlet that the new shared portlet derived from. This new information can assist in supportability of Viewpoint.

manoj.d 10 comments Joined 12/10
05 Jan 2011

Current Perm Max - Maximum permanent space used on a single vproc

Does this mean the maximum space used on a single AMP?

stever 28 comments Joined 08/09
05 Jan 2011

Do you mean Current Perm Max %? If so, that metric is defined as: Current Perm Max * Number of AMPs / Max Perm

manoj.d 10 comments Joined 12/10
05 Jan 2011

I referred to the metric name "Current Perm Max"

The description in the User Guide describes it as "Maximum permanent space used on a single vproc"

Does this mean the maximum space used on a single AMP? Could you please elaborate.

stever 28 comments Joined 08/09
05 Jan 2011

What portlet are you referring to?

manoj.d 10 comments Joined 12/10
05 Jan 2011

Apologies for not being specific.

This is not a portlet.I am trying to set up the database space alert.

For the Alert Type - Database Space , I could see 2 metrics(the metrics can be found on the drop down while setting up the alert).

of these 2 i am not clear with the metric named Current Perm Max %.

Current Perm Max %= Current Perm Max * Number of AMPs / Max Perm

so what does "Current Perm Max" means?

stever 28 comments Joined 08/09
05 Jan 2011

Current Perm Max is the perm space on the AMP with the most perm space for that database. This metric is typically used since when any AMP in the system is 100% full, there's a chance that a future insert into the table would fail.

helge 14 comments Joined 02/08
10 Jan 2011

Any news on when VP 13.11 will be re-released?

gryback 151 comments Joined 12/08
11 Jan 2011

Next week. I'll provide an update here when it has been re-posted.

gryback 151 comments Joined 12/08
18 Jan 2011

Teradata Viewpoint 13.11 was re-released yesterday, January 17th.

helge 14 comments Joined 02/08
03 Feb 2011

We're having problems with the Query spotlight that we don't quite understand...
It seems to work, allthough very slowly, from the AWS, but from my workstation it just hangs when I try to get details a specific query. Does this portlet require some special FW opening?

gryback 151 comments Joined 12/08
03 Feb 2011

This is not normal. Please contact the GSC for investigation.

perumallaramesh 1 comment Joined 02/11
09 Feb 2011

my name is ramesh recently i doing final year of Master of computer application now i want to learn TERADATA 13 i want brief details about teradata is dis course is become fetching to my career or not plz give ur valuable suggestions in this matter thanking you

my name is ramesh recently i doing final year of Master of computer application now i want to learn TERADATA 13 i want brief details about teradata is dis course is become fetching to my career or not plz give ur valuable suggestions in this matter thank

gryback 151 comments Joined 12/08
09 Feb 2011

General Teradata documentation is available on our Information Products page. So I'd suggest starting there.

http://www.info.teradata.com/

manoj.d 10 comments Joined 12/10
09 Feb 2011

Ramesh,

If you would need an answer on whether to choose Teradata as your career path, i do suggest you to research on your own before opting for it. Yes teradata is a good option but its for you to decide and make a choice.

pabbaskhan 6 comments Joined 02/11
24 Feb 2011

Hi Gryback,

can you send me the TERADATA DBA BOOKS and how is the job opportunities on VIEWPOINT.
Your blogs are excellent. khanasp@gmail.com is my mail id.this site gives so much information i really appriaciate this one thanks alot.

02 Mar 2011

Gryback,

I am working on Viewpoint 13.10 version. DB is at TD13 .0 (recently migrated it from TD12).

When I trying to create workloads from viewpoint (workload designer), surprisingly 'workload' option is not visible from workload designer portlet.

Is there any tables needs to be created as part of viewpoint configuration?

I could just able to see only 3 options.. ' seessions, filters& throttles'.

gryback 151 comments Joined 12/08
02 Mar 2011

Teradata documentation is available on the Teradata main web site as is the process and procedures for employment opportunities. You will need to apply there as the initial step. I would suggest adding comments that you have interest in the Viewpoint product.

gryback 151 comments Joined 12/08
02 Mar 2011

If you are looking at Workload Designer and you are limited to filters and throttles, then I'm guessing you are trying to manage one of our 1xxx/2xxx Appliance platforms, for instance like a 2650. If so, this is working as designed.

02 Mar 2011

yes working on 2580..

02 Mar 2011

its on td13. can I create worklods with TDWM on 2580 box?

gryback 151 comments Joined 12/08
06 Mar 2011

No, the 1xxx/2xxx appliances have a different workload management strategy where the prioritization and classifications are set and static. So there is no workload creation aspect as we utilize a RHML setup with classification by account string, for instance $R. This is why you are only seeing sessions, filters, and throttles.

go161300 11 comments Joined 06/09
09 Mar 2011

At Query Monitor, If want to refresh the current session information, should be click only small refesh button ? too Small, and any more shotcut function (control + U) at teradata manager session information

go161300 11 comments Joined 06/09
10 Mar 2011

Only viewpoint user working, but at the Capacity Heatmap View, AMP I/O Skew rate higher 50%, how can i making sense.

gryback 151 comments Joined 12/08
11 Mar 2011

The Query Monitor refresh button refreshes instantly from the Viewpoint DCS. There is no other shortcut. I'm not sure I understand the question on Capacity Heatmap View.

helge 14 comments Joined 02/08
16 Mar 2011

Hi, we have set up an alert when sessions are blocked more than n number of minutes. We now want to set up a separate alert with a different action set when our backup jobs are blocked. But I can't find a way to set up a blocking alert for a specific set of users? There is an "exclude these users" option, but not an "include these users"? Is there any way to get around this?

gryback 151 comments Joined 12/08
16 Mar 2011

The first priority for the alerting infrastructure was to provide Teradata Manager feature equivalence. Teradata Manager offered the exclusion but did not have an inclusion option so that is a new feature request. It has been documented as a future implementation consideration.

helge 14 comments Joined 02/08
16 Mar 2011

Great, let's hope it gets implemented, and sooner rather than later...:-) We're very satisfied with Vp13.11, I still have TD Manager installed, but I haven't used it for weeks. We're already long past the alert setup we had in TD manager, but as we find out more possibilities, we always want more!
Thank you for quick responses to questions in this thread, I find it very useful!

gryback 151 comments Joined 12/08
16 Mar 2011

Nice to hear. We aim to please!

helge 14 comments Joined 02/08
17 Mar 2011

I'm not sure whether this is the right article to ask about this, but I'll give it a try... We're having issues with how TASM treats procedure calls. When our "nightly" batch runs into office hours, we have throttles on how many concurrent "Medium" and "Long" queries can be run at the same time. This works fine for most jobs, as the latest jobs gets put in the delay queue until there is "available slots" in the correct WD... The problems is with procedures with either many statements within it, our some kind of looping, and the fact that each statement gets classified by itself. If a procedure contains a loop that runs through 100 times, we risk that 1 procedure call gets placed in the delay queue a 100 times... Is there any way I can set up a classification rule in the TASM portlet that treats 1 procedure call as 1 query (i.e. gets classified once)? I realize that this must thought through so we don't "trick" TASM into letting to much work onto the database, but still I'd like the possibility to treat 1 procedure as 1 query, with regards to the delay queue...

gryback 151 comments Joined 12/08
17 Mar 2011

Discussion items like this make more sense in a forum. I'd suggest posting this under the Enterprise forum for response:
http://forums.teradata.com/forum/enterprise

aagrawal 11 comments Joined 06/08
23 Mar 2011

is it mandatory to enter logon credentials , at the time of query abort (manual says its optional). all of our users are using LDAP logons to teradata databse. The logon pop-up doesn't give us option for LDAP logons to database.

stever 28 comments Joined 08/09
23 Mar 2011

The 13.11.00.04 release of Viewpoint adds support for LDAP logins to Teradata. This version should be released next week (week of March 28).

aagrawal 11 comments Joined 06/08
23 Mar 2011

Thanks for the update. does the user has to logon every time, he/she needs to abort a session? can the creadential not be saved somewhere in viewpoint properties on the server?

stever 28 comments Joined 08/09
23 Mar 2011

The user's credentials are cached for the duration of the user's Viewpoint session. So, if the user is using the portlet throughout the day, he/she should only need to provide credentials once.

aagrawal 11 comments Joined 06/08
24 Mar 2011

is there inconsistencey between the viewpoint manual and actual viewpoint query abort process? Manual says the query abort user logon is optional, while in actual it is mandatory?

gryback 151 comments Joined 12/08
25 Mar 2011

I don't believe so. The section introduction on managing sessions and queries clearly states:

You must log on with a user ID that has permissions to abort, change priorities or workloads, or release queries. If you log out, close a portlet, or open a new portlet instance, you must log on again.

Now it does then say under a certain command process for example an abort that "[Optional] Log on." which is a true statement and what stever is referring to. To drive this point, take the following example.

I log into Viewpoint, and use Query Monitor to abort a query. As this is my first operation with this portlet in this session, I will be prompted to provide my logon credentials. Then I go and find another query to abort, I will not be prompted again for logon credentials as we maintain and honor the credentials within this portlet and session because you've already provided them. This is why we state the logon is optional as there are cases where it absolutely is not required.

Does that make sense?

Momolue 2 comments Joined 03/11
25 Mar 2011

We've just installed and configured Viewpoint 13.10.00.02 at our testing site. We are referencing 13.11 config and user manuals. We noticed that the rewind feature does not have the sliding option and graghs only show points (no lines) as you hover over with the mouse pointer. Are these normal behavior for the older version or are we missing something? Thanks.

gryback 151 comments Joined 12/08
25 Mar 2011

Not sure what you mean by rewind not having a sliding option. There is no new rewind functionality added in 13.11. Contact the GSC for the concern around metrics points versus lines. I believe that is just a data collector configuration issue.

Momolue 2 comments Joined 03/11
28 Mar 2011

Thanks, I'll check with GSC on the poits vs line issue.
About the 'sliding option' - we can only go back/forward in time by clicking the 1 hour/min/sec buttons on the Rewind Enabled bar.
I see in the 13.11 documentation that there is a also a slider button on that bar that allows you to 'slide' back and forth through time (as oppose to just clicking).

gryback 151 comments Joined 12/08
28 Mar 2011

So a couple thoughts on this.

As mentioned, Rewind behavior did not change in Viewpoint 13.11. The "slider" in Rewind is the button between the hour/min/sec back and forward click options. One can click and drag the slider above one of the hour/min/sec options enabling back or forward traversal of time. That is the Rewind "sliding" ability and has been there since its initial release. This is described by hovering over that button as the pop-up states "Drag to adjust desired time".

Now there are new time marker and date range slider features within the Viewpoint 13.11 new Query Spotlight portlet for traversing through the query plan / data collections to see how a query changes during execution. You can then control Rewind to that time slot by clicking on the "Control Rewind" button. However this is not a new Rewind slider feature.

emilwu 34 comments Joined 12/07
08 Apr 2011

now, this version of viewpoint killed that tool button on the sesion monitor widget V13.11.00.04-b59
that makes aborting multiple session impossible.
if I want to abort a group of sessions (like from sigle user or from criteria I setup in session monitor), how to do that? click through each session is so tedious!!!

gryback 151 comments Joined 12/08
11 Apr 2011

For aborting multiples, the ability is still there in Query Monitor. If you look at the screen shot discussing the Viewpoint 13.11 "Export Capability" in this article, you'll see an "Abort" command that then would bring you back to the summary screen. Once there, you will be given choice options for every item or a select all option, where you can then uncheck where necessary. Does this answer your concern?

emilwu 34 comments Joined 12/07
11 Apr 2011

great!!! saw it now, thanks !!! i am getting too old when buttons are moving around!

SeanM 3 comments Joined 04/11
27 Apr 2011

Hi Gary,
With the new Query Spotlight tool, do we foresee any upticks in the data collected and stored by Viewpoint? I.e. if we see our system is gathering and storing 100GB every month on VP 13.10. Could this possibly go up on 13.11, lets say 120GB every month? I don't need any exact numbers just an understanding of the implications.

My thoughts were that possibly with the Query Spotlight tool, and utilizing rewind, we may store additional info that we did not store before?

gryback 151 comments Joined 12/08
29 Apr 2011

Regarding additional data repository requirements for Query Spotlight, the answer is no. Query Spotlight is just presenting data in a different manner for the data we already had in the data collection. The other advantage of that is that you don't have to wait for data population, it is already all there.

AbeK 37 comments Joined 08/09
13 Jun 2011

What are the differences between the Workload Designer portlet and the current TDWM tool to configure rulesets. Is this is a one way migration and are there any key points to be aware before making this switch.

gryback 151 comments Joined 12/08
13 Jun 2011

Teradata Dynamic Workload Manager (TDWM) and the Workload Designer portlet provide the same configuration options for Teradata DB 12.0 and 13.0 releases. As there is no TDWM version that will work against Teradata DB 13.10, you will need to be using Workload Designer at that time. For the overlapping releases, one can actually use both TDWM and Workload Designer concurrently. So the hard switch over is with Teradata DB 13.10. The only key point in switching is there is a learning curve so leveraging the overlapping releases is certainly best practices.

AbeK 37 comments Joined 08/09
13 Jun 2011

Thanks for the clarification. This is helpful information and is a good thing to get started before the DBS upgrade.

helge 14 comments Joined 02/08
14 Jun 2011

Hi, we are on viewpoint 13.11 and recently upgraded Firefox from 3.6.11 to 4.0.1.
We had to roll back because at least two TASM-portlets didn't work in Firefox 4. (Workloads - Priority Distribution and Workloads - Workload - Throttles)

Do you know when viewpoint will certified for Firefox 4?

gryback 151 comments Joined 12/08
14 Jun 2011

The next release of Viewpoint, 13.12 will provide official support Firefox 4.x. This release should be at the end of August. We will also provide support for Chrome and Safari but will be dropping IE6.x.

rosewang 5 comments Joined 09/10
27 Jun 2011

As viewpoint administrator, I would like to send email notification to all the viewpoint users but I don't see a way to pull the list of users/emails list. Is there a way to do it in viewpoint? Thanks.

stever 28 comments Joined 08/09
27 Jun 2011

There is not a way to pull a list of Viewpoint users and email addresses in the current release. However, in Viewpoint 13.12, scheduled for release at the end of August, you will be able to export the user list to a CSV file, similar to the export provided in other portlets like Query Monitor. From this CSV file you should be able to copy and paste the list of email addresses into your mail editor.

rosewang 5 comments Joined 09/10
27 Jun 2011

We are going to turn on LDAP logon in viewpoint. We have lot of users already created in viewpoint and I don't see a easy way to turn on external authentication globally in user manager. Looks like we have to do it at each user level??

gryback 151 comments Joined 12/08
27 Jun 2011

The Viewpoint auto-provisioning feature is located in the Admin - LDAP menu.

AbeK 37 comments Joined 08/09
27 Jun 2011

For exixting user one will have to check the option for external authentication, for all new users, the auto provisioning will take care. You'd be glad you did that sooner than later. We have it integrated with LDAP and no more password management!!

AbeK 37 comments Joined 08/09
27 Jun 2011

Gary, are there any target database version dependencies for VP 13.11?

helge 14 comments Joined 02/08
27 Jun 2011

Mozilla are currently releasing in a rapid speed, they're now pushing Firefox 5.0... I accidently clicked "yes" on the "do you want to upgrade" question, and then nothing in viewpoint was working..... I've now downgraded again, any plans on when viewpoint will be on firefox 5?

gryback 151 comments Joined 12/08
28 Jun 2011

Regarding target database version for VP 13.11. Viewpoint 13.11 will support V2R6.2, 12.0, 13.0, and 13.10 with one exception, that being Workload Designer that only supports back to Teradata 12.0.

VP 13.11 will support Firefox 4.x. Mozilla has recently changed their release plans with major releases like 5,6,7 coming out at a much faster rate. We are evaluating the best way to manage these releases. For now, we don't have a release date for support of Firefox 5.x. We are aware of the issue however and are actively working on it.

AbeK 37 comments Joined 08/09
29 Jun 2011

Thanks for the clarification. Another question...
Currently VP allows canary queries through a user which can be configured with accountstring, but there is no option to reuse an ID with multiple accountstrings, so we could run the canary in the respective workloads. Is this something that is already available, if not, would this be a feature for consideration.
Thanks in advance.

stever 28 comments Joined 08/09
29 Jun 2011

My suggestion would be to create separate canary queries for each different account string. The name of the canary query will be used to identify its metrics when you are looking at a portlet such as Canary Response Times, so there's a certain amount of configuration necessary to ensure you can identify each separate query.

Also, note that only one instance of each canary query will run at a given time. If you had a situation where one of your workloads had a big delay queue or was being allocated only a very small percent of resources, with the current solution, other canary queries will continue to be submitted against the other workloads. If we implemented something along the lines of what you are suggesting, it would probably block the submission of the queries against the other workloads.

AbeK 37 comments Joined 08/09
29 Jun 2011

The canary SQL is distinct for each account string, its the actual database ID which is constant. This allows us to do 1:many on database id to canaries and we host all the canary SQL as views with a dedicated database (Ease of management). We figured out that we could use the same user id with multiple accountstring in the VP -> Teradata Systems --> General. The challenging part now is to properly select when setting up the canary. The dropdown list sorts the userid based on the userid/accountstring combination,so this is the trick part to have the right mapping. It would be beneficial if the dropdown list, lists both the parameters provided (Username & Accountstring) at user account setup time.

martinbarrow 1 comment Joined 10/10
19 Jul 2011

Are there any plans to incorporate PM/API to allow alerting of issues as they occur?
One problem we have is that we cannot set the data colector for database space to anything less than 3600 seconds. So if a peak in space usage occurs and then drops between the 1 hr period we are not alerted. This can cause problems with DBC capacity where resusage data collection is switched off when DBC exceeds capacity. i.e. say we have an alert on DBC at 90%, db space collected at 8am and DBC = 75% populated no issue. At 8:20am DBC hits 95% and at 8:50am DB is back to 80%, db space collected at 9am (3600 seconds after previous collection) and no alert as the db is below alert threshold.

gryback 151 comments Joined 12/08
20 Jul 2011

We are aware of the current boundaries for space collections and have enhancement requests pending to address that. It has come up enough to warrant a priority increase. 2011 releases however are already committed so will look to next year for this.

rosewang 5 comments Joined 09/10
22 Jul 2011

Does anybody have problem with viewing workload piechart within workload monitor portlet? My customer had issues with IE6 before, it went away when the company upgraded to ID7. Now the problem came back again with IE8. Basically when he click on pie chart, all he gets is a blank screen and it freeze up on him. Had to kill/close the portlet and bring it back again.......anything to share on this?

gryback 151 comments Joined 12/08
22 Jul 2011

The first recommendation would be to ensure you are running the latest patch levels, which currently is 13.11.00.05. However I don't see a specific fix in the patch release article for the problem you're describing. So I would suggest a GSC incident to investigate.

bs185073 1 comment Joined 06/11
06 Oct 2011

Hi Gary,
Not sure if this is the right place for me to ask questions about issues with Heatmap. My customer is using Vp 13.11.05,, and he said,,
1) No CPU data is being collected from our Production system into viewpoint. (any portlet that allows CPU data)
2) The Heatmap portlet is showing in black and white. How to change the color for the Heatmap.

Being a newbie to Vp, I do need some guidance here. I've researched, and found that it may be caused by permission to view Table metrics. No data appears until user selects a metric using the selection menus. Found it in,,
Teradata Viewpoint
User Guide
Release 13.11
B035-2206-120A
December 2010
- About the Capacity Heatmap Menus and Toolbar (pg 108)

Could you please advise?

Thanks,
Shah
/TD Support

gryback 151 comments Joined 12/08
06 Oct 2011

Create a GSC incident for the lack of CPU data.

The Capacity Heatmap has a thresholds bar for metrics where it makes sense. Its the button right next to the display button where the threshold can be adjusted which will then introduce coloring of the outliers.

Jigar 1 comment Joined 09/11
16 Jul 2012

We are having an issue with spotlight ,It is not showing any queries executed in last 24 hours . It was working fine previously, can you provide us some pointers on the same < no filters are applied >

gryback 151 comments Joined 12/08
16 Jul 2012

Check the thresholds in preferences to ensure you have actual exceptions to view. If you are seeing queries in Query Monitor, the Spotlight should work properly. For further investigation, I'd recommend contacting GSC support.

geethareddy 145 comments Joined 10/11
09 Feb 2013

Hi Greg,
We are on V14.01.00.02-b47 . Workload designer showing Unknown for the active rule set. Generally it should show the admin name or user who activated that but it showing the UKNOWN. I heard there is a JIRA opened on WL designer issues. Is this known bug or new one. Can you please share your thoughts on this?

Thanks,
Geeta.

Thanks,
Geeta

gryback 151 comments Joined 12/08
11 Feb 2013

Geeta,

Not sure who you are referring to on the last post when you mention "Greg" but if you have concerns about a potential bug, this needs to go through the Teradata Support Services process.

Gary

bcherian 2 comments Joined 01/11
11 Feb 2013

Geeta,
There are 3 things that could be 'Unknown'; the ruleset name, activated at, and activated by.
The ruleset name could be unknown if, for whatever reason, we have the config id for the active ruleset, but have not been able to collect more data about it. The other two will happen for any ruleset which does not exist in 'Working' at the time of activation. This is because we only store metadata (activated by, activated time) for rulesets that are currently in Viewpoint.

Betsy

geethareddy 145 comments Joined 10/11
11 Feb 2013

Gary, sorry i was working on something else with the person name Greg. I referred the same name while posting this to you. Thank you for the response.

Betsy, I just want to undestand more from your response with the below ex, in any rule set which is in "Active" section, it will show the name of the rule set(21 TPT and 3 Atanasoft Exe 1.1), Activaed At ( 2/10/13 5:50:15 AM), Activated by (by admin).

Ex:
21 TPT and 3 Atanasoft Exe 1.1
Activated: 2/10/13 5:50:15 AM
by admin

Q1)From your response i didnt understand the below point, can you pleaes eloberate more on this?
The ruleset name could be unknown if, for whatever reason, we have the config id for the active ruleset, but have not been able to collect more data about it.

Q2)What you mean by the other two from below point
The other two will happen for any ruleset which does not exist in 'Working' at the time of activation. This is because we only store metadata (activated by, activated time) for rulesets that are currently in Viewpoint.

Thanks,
Geeta

bcherian 2 comments Joined 01/11
12 Feb 2013

Geeta,

If the any of the data in the 'Active' section displays 'Unknown', it does not indicate a problem.

#1) Viewpoint displays information that is collected from Teradata, periodically. The id of the active ruleset, and the name of the ruleset are collected by different collectors. So, if one collector runs successfully, but the other doesnt, you could have missing data in the portlet. These are usually temporary problems, and fix themselves once the collector completes successfully.

#2) The time of activation, and the user who performed the activation, are stored in Viewpoint, not Teradata. If, e.g., the ruleset was never saved to Viewpoint, or was activated from outside of Workload Designer, then this information will not be available.

Hope that helps.

I'm afraid further explanations on this feature will move beyond the scope of a public forum, please contact Teradata Support if you need more assistance.

geethareddy 145 comments Joined 10/11
12 Feb 2013

Fantastic, thank you Betsy.

Thanks,
Geeta

geethareddy 145 comments Joined 10/11
13 Feb 2013

Not sure whether i can ask this question here in this thread or not.
But just had a quick question aboutt he 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 ssytem.

Thanks,
Geeta.

Thanks,
Geeta

gryback 151 comments Joined 12/08
13 Feb 2013

Geeta,

You need to post these types of general Viewpoint questions in the Viewpoint forum, not as a comment to an unrelated article.

geethareddy 145 comments Joined 10/11
15 Feb 2013

OK, thanks Gary.

Thanks,
Geeta

touseef_081 5 comments Joined 05/15
02 Jun 2015

Hi Gary,
I have facing an issue that i have enabled external authentication for all the users. but one user having an issue that he cann't be login through LDAP (external authentication). I have checked his profile and tried to enable external authentication but getting the error i.e. user firstname.last@domain.com  update failed [Identity Manager Exception]. Even i have tried to grant more roles to the user but failed to do so.
Could you please tell me what should be the issue with this?  The Teradata viewpoint version is 14.10.

gryback 151 comments Joined 12/08
02 Jun 2015

Not sure what the issue is. Please submit a formal support incident. Note you are running an older version of Viewpoint as there are already 15.00 and 15.10 released versions. 

You must sign in to leave a comment.