This article is the official release announcement for Teradata Viewpoint 15.10 with an effective release date of April 9th 2015. In addition to providing support for various Teradata products, the Viewpoint 15.10 release offers two new strategic reporting portlets, Query Log and Application Queries.  

Summary

The primary themes of the Viewpoint 15.10 release are to enhance Teradata DB reporting capabilities and to support various products including Teradata Database 15.10. The highlights of the Viewpoint 15.10 release are:

Performance Reports

Two new portlets were added in Viewpoint 15.10 which support Teradata Database 14.10 and newer.  These portlets use data from Performance Data Collection and Reporting (PDCR) infrastructure.

Query Log

The Query Log portlet enables Teradata Database Administrators to view key reports based on the historical DBQL data in the PDCRDATA.DBQLogTbl_Hst table in Teradata Database. In the screenshot below, it shows that 4 applications or 3 users utilized the system named "paper" on May 18th 2015. Next to it the bar chart displays a visual representation of the numbers of queries that fall into each category for the selected metric. The chart provides details such as number queries that had single AMP, two AMP or all AMP steps or number of queries resulted in an error etc.. The trend chart next to the bar chart helps analyze key performance indicators, aggregated by day for a period of time. The trend chart also helps users understand the impact of certain events such as a Teradata version upgrade or a TASM ruleset change on the key metric. Towards the bottom of the screen, the Logged Queries tab provides key metrics for queries logged on the selected date. The Suspect Queries tab displays information for all logged queries that are designated as suspect. Suspect queries are those whose values surpass thresholds defined for the Query Log data collector in the Monitored Systems portlet.

On drill down to Users or Applications displays details about the Users or Applications that were running on the system, such as logged queries  or how many queries were classified as suspect queries etc. for a particular user or application. The screen shot below is from a drill down on Users. 

Further drill down to a particular user gives summary stats about the user such as number of logged queries, number of queries classified as suspect queries etc.. The queries tab lists all the queries submitted by the user as well as all the queries that were classified as suspect queries. The trend tab can be used to  plot multiple trend charts which helps analyze key performance indicators aggregated daily or weekly over a period of time. It also helps in analyzing  the impact of certain events such as the Teradata version change or TASM ruleset change on the key metrics for a user. The trend chart for applications also helps analyze impact of an application version change if Teradata recommended QueryBand format is followed, as Viewpoint picks up the application name and version from the QueryBand.

In the queries tab, further drill down to a query gives query level stats as to time spent in delay queue, KPI, workload details etc in the SQL and Query Band tab, one can see SQL and Query Band information.  

Application Queries

The Application Queries portlet helps application users understand their application performance. The Application Queries view displays summary information for each application and its different versions that submitted queries on a selected date. Drill down to a particular application gives summary stats about the application such as number of logged queries, number of queries classified as suspect queries etc.. The queries tab lists all the queries submitted by the application and  all the queries that were classified as suspect queries. The trend tab allows users to plot multiple trend charts which helps analyze key performance indicators, aggregated daily or weekly over a period of time for the application. Users can also see the impact of certain events such as Teradata version change or TASM ruleset change or application version change. 

In the queries tab, further drill down to a query gives query level stats as to time spent in delay queue, KPI, workload details etc, in the SQL and QueryBand tabs, one can see this information.

If the Teradata recommended QueryBand format is followed, Viewpoint automatically generates the application name using QueryBand information, administrator can assign Viewpoint users or roles to those applications in Query Group Setup portlet so that application users can see details about the applications in Application Queries portlet. If the Teradata recommended QueryBand format is not follwed, one can define applications in the Query Group Setup portlet and assign Viewpoint users or roles to them. 

Performance Data Collection and Reporting (PDCR) Scheduling

PDCR is a Teradata PS offering which collects historical data from various Teradata system tables (ResUsage, QueryLog, AmpUsage, LogonOff, TDWM) and stores within a PDCR database defined on a Teradata system. This database is then used to generate a series of customer performance analysis reports (Excel Toolkit and PS Viewpoint portlets).

PDCR involves:

  • Creation of PDCR infrastructure –  This can be done using PDCR dip script which is part of Teradata Database 14.00 and newer
  • Regular scheduling of maintenance job which moves data from Teradata system tables to the PDCR database. This can now be done using Viewpoint 15.10 on Teradata Database 15.00 and newer. Prior to this new offering, PS developed scripts were used for maintenance jobs.
  • Upgrade & Migration of PDCR database is still handled by Teradata PS
  • The PDCR excel tool kit reports and PDCR Viewpoint reporting portlets remain a Teradata PS offer.
  • The Query Log and Application Queries portlets provided in Viewpoint 15.10 use the PDCR data repository.

The PDCR scheduling portlet allows you to create, monitor and manage PDCR scheduling jobs. You can see when a particular job was last executed, whether a job was successful or failed, if failed what was the error, how many rows were accessed, tables that were loaded etc.. It also allows you to send alerts for failed jobs or when PDCR staging/reporting database reaches  space limit thresholds. 

Products Support - Teradata Database 15.10 Support

Following features in Viewpoint 15.10 requires Teradata Database 15.10 and above.

Secure Zone

Teradata Database 15.10 added the Secure Zones feature to support multi-tenancy environment or sandbox environment. This feature restricts user access to  set of database objects. Viewpoint 15.10 is built with Secure Zone awareness by assigning zones to a role in the Roles Manager portlet. Once a zone is assigned, Viewpoint users in that role when accessing the listed portlets below will only see details or queries accessing the objects assigned to a particular zone.

  • Queries Portlets (Query Monitor, MyQueries, etc.)
  • Query Log
  • Application Queries
  • Space Usage
  • Lock Viewer

In the below screenshot, the "0 of 2" for "WD" system means that out of 2 zones defined on the WD system, no zones are assigned to Administrator role. One can click on the "0 of 2" screen to assign zones to a role.

Partition Level Lock:

Teradata Database 15.10 introduced a new locking mechanism to improve partition level access. Viewpoint will display these locks in the Query Monitor and Lock Viewer portlets.

The QueryBand Option in Profiles

Teradata Database 15.10 added an option to set QueryBands in profile which will be the default queryband for a session. In Viewpoint, the user can view the profile queryband in the QueryBand tab in the Query Monitor portlet.  

Stored Procedure Monitoring

Viewpoint 15.10 can now differentiate between a SQL that is part of a stored procedure or not.  The SQL tab in the Query Monitor drill down will now display the stored procedure name.

Proxy User Information

Teradata Database 15.10 will allow users to log on as a proxy user and use access rights of that proxy user. Viewpoint 15.10 will show the proxy user details in the Query Monitor overview drill down tab and the Workload Monitor portlet. See the screenshot below.

Request Level Skew

Viewpoint 15.10 along with Teradata Database 15.10 can now report request level CPU and IO skew in addition to snapshot skew information. For this, the overview tab in the Query Monitor portlet was re-arranged.  

Products Support – Workload Management

Unless stated explicitly all new workload management features require Teradata Database 15.10 and newer. Viewpoint 15.10 supports the following workload management features:

  • Users now have an option to prioritize the delay queue based on workload priority. Users can now choose to release queries based on workload priority instead of only FIFO.
  • Users can now separately classify backup and restore job
  • Users can now classify on a MloadX utility
  • Users can now define an AMP Worker Task (AWT) throttle for Utility Name, Request Source, Query Band, DSA job type, or a combination of these criteria.
  • Users now have a new minimum response time option which will allow them to hold a query in a response state until the minimum workload response time threshold is met

In the Workload Monitor portlet when drilling into the delay request throttle view, there are additional tabs as shown in the screen shot below. This is supported for Teradata Database 13.10 and newer.

  •     By Workload - same as the previous view, displays all the sessions that are currently delayed
  •     By Throttle - Display all queries included in a throttle counter. A query that is included in a throttle counter might still be executing, it is only delayed if the limit is exceeded.
  •     By Throttle count - Displays the counters for each active throttle. For Teradata DB 15.10, this will now also display system default throttle. 

Products Support –  Aster 6.10 Support

The Viewpoint 15.10 release supports Aster Database 6.10. With this release of Viewpoint 15.10 users can cancel any process or queries running on Aster Database 6.10 and above. This is done by having Viewpoint submit an asynchronous abort to the database.

Alerts

  • Include/Exclude by Account string was added for session alerts to include/exclude account strings while defining events for session alerts.
  • User can now send alerts for a session stuck in responding state.

Online Restore and Server Migration

Migrating to a new Viewpoint server or restoring a Viewpoint server has been made easy with minimized downtime. This was accomplished by only taking Viewpoint services offline while configuration data is restored. They system is then made available as the historical data is restored in the background.

Progress of the restore or migration can be monitored in the Viewpoint portal notification area.

Below are three restore/migration options that are now supported:

  • A configuration only restore.
  • Configuration only restore or migration into a clean database.
  • A full restore or migration

Cluster Notification 

A list of e-mail addresses can now be configured to receive cluster related e-mail notifications

Please refer the compatibility matrix and associated Viewpoint Configuration Guide for details of the upgrade process and the User Guide for details of new features.

Hope you like these new changes in Tearadata Viewpoint 15.10. We always look forward to your thoughts and comments.

Discussion
27 May 2015

Very nice Article.

02 Jun 2015

Yes, very nice article.  Is there a developer api for transition of user written portlets from Viewpoint 14 to 15?  These would have been developed using tdpdk-14.01.00.01
 
 

Shrity 61 comments Joined 05/12
02 Jun 2015

Thanks. 
We officially discontinued PDK and discourage building any new custom portlets using PDK. But if you already have custom built portlets we will support that. Please contact your local CSR and ask them to get in touch with us.
 

geethareddy 145 comments Joined 10/11
28 Jun 2015

Hi Shrity,

I saw the issue when the system was is busy. But apart from the credentails are wrong fo the ID that you are using, it is also possible to see this error if there are any potential network issues due to which the Viewpoint server could not able to connect OR if the Database is too busy to accept the new connections. I suggest to submit an incident to GSC.

Thanks,
Geeta

geethareddy 145 comments Joined 10/11
12 Jul 2015

Shrity,
I was trying to access the Query Log portlet, but it is showing No Data Available, after checking the QueryLog Data Collector, I've noticed that there are no enough rights (Error Checking for New query Log data: [Teradata Database] [Teradata JDBC 15.10.00.050][Error 3523] The user does not have SELECT access to PDCRDATA.DBQLOGTBL_HST. )
So I gave the cocern role which provides the READ access to Viewpoint user on PDCRDATA (all tables). But still the data collector showing the Red Triangle (with exclmation) and query portlet with no data available. Am i missing anything here?

Thanks,
Geeta

Shrity 61 comments Joined 05/12
13 Jul 2015

Hi Geeta,
It's diffcult to comment without looking at your system on what might be wrong or missing. I would suggest you to open GSC ticket. Do you have PDCR installed in your environment, i.e. does PDCR tables has data in it ?
Thanks
Shrity

geethareddy 145 comments Joined 10/11
13 Jul 2015

Yes, we do have PDCR. I will raise this GSC, but before that I just wanted to make sure to the driver supportability in terms of the version. Do we need to have JDBC 15.10?

Thanks,
Geeta

GDHAR 7 comments Joined 08/14
14 Jul 2015

Hi Shrity,
Good day!
lock viewer portlet in viewpoint  is not showing the lock information. The base table is populating data but it is not reflecting in the viewpoint. Getting below error.
***Unable to get lock information! [Teradata Database] [TeraJDBC 15.00.00.11] [Error 9134] [SQLState HY000] AS_SHRED_BATCH:Error in function AS_SHREDTB: Insufficient memory to complete the XML operation.****
Will the XML_MemoryLimit value increase in the DBS control record - General field solve the issue?

Shrity 61 comments Joined 05/12
14 Jul 2015

Gangadhar,
I am not sure why you are getting this error. You can try increasing XML_MemoryLimit value if that doesn't work open a GSC ticket for someone to look at your box.
Thanks
Shrity

GDHAR 7 comments Joined 08/14
14 Jul 2015

Hi Shrity,
Thanks for the info..
Will try and see.
Thanks
Gangadhar.

Shrity 61 comments Joined 05/12
14 Jul 2015

Hi Geeta,
I don't think driver version is an issue.
Thanks
Shrity

geethareddy 145 comments Joined 10/11
15 Jul 2015

Shrity,
Regarding the SNAPSHOT INFO section in QueryMonitor/MYQueries, it gives us the session details in last sampling period, sampling period means for last 600 seconds OR for how much time it shows us the details. Is there any place we can increase or decrease this sampling period? Becuase, as far as i know I think the SESSIONS data collector provides the details for the SQL and EXPLAIN tabs for these portlets, i checked in SESSION data collector for SNAPSHOT INFO sample period, but i didnt find any option.  Pleaes share your thoughts.

Thanks,
Geeta

Shrity 61 comments Joined 05/12
15 Jul 2015

Geeta,
The sampling period means the snapshot data value at the time last sample was collected which depends on sampling rate defined in your data collector. For session data collector it is 30 sec by default. You can change that rate.
Thanks
Shrity

geethareddy 145 comments Joined 10/11
15 Jul 2015

Got it. So the sample rate of the sessions data collector is the sample rate of SNAPSHOT INFO.

Thank you for the quick answer.

Thanks,
Geeta

geethareddy 145 comments Joined 10/11
16 Jul 2015

Shrity,
If i do not set up a specific QUERYGROUP for each application, i cannot make use of APPLICATION QUERIES portlet based on the APPID of each application that is available in DBQL?
Becuase, i am seeing the data in QUERY LOG portlet, but Application Queries portlet is empty. As far as i understood from the manual, if we have the DBQL data we can see the data of all the application on which the dBQL is logged. Please let me know what else i am missing.

Thanks,
Geeta

Shrity 61 comments Joined 05/12
16 Jul 2015

Geeta,
Viewpoint will generate application name and version from queryband. If you follow Teradata recommended queryband format Viewpoint will automatically generate application name. After that you need to assign Viewpoint roles/users to a the application using query group setup portlet for user to see details about "only" their application, that they have access to, in Application Queries portlet.
Thanks
Shrity

geethareddy 145 comments Joined 10/11
16 Jul 2015

We are not following the TD recommended Queryband for the applications, rather we have part of the queryband for specifying the Application Name, and for Viewpoint we did not define any queryband at all. After reading your response above, i quickly checked the Viewpoint queryband, it is taking the default as you said something like =s>app=Viewpoint,version=15.10.00.03,source=DataCollectorName. So having said that, ApplicationQueries portllet should show the Viewpoint user queries because I already assign my id to the querygroup to see the details about Viewpoint. But still i could not able to see anything in ApplicationQueries Portlet.
I submitted an incident for the same.
Just for my clarification sake I am asking this question.
If we do not define the querygroup, there is no use of ApplicationQueries Portlet? Is this true statement, OR
Any application with defined QueryBand (as shown below) for its application queries can be monitored from ApplicationQueries Porlet?
For ex Querband format: appname=Informatica, appid=xxx, version=nnn
 
 

Thanks,
Geeta

Shrity 61 comments Joined 05/12
17 Jul 2015

Geeta,
Application queries are targeted for Application users to see "their" application performance only. So you have to assign appropriate Viewpoint users to their application in order for Viewpoint to know which application details should be shown to which user. You use Query Group setup portlet to do so. If you want to see all the applications running on the system you will have to look at Query Log portlet and drill down to Application section.
Thanks
Shrity 

geethareddy 145 comments Joined 10/11
17 Jul 2015

Thank  you for patiently answering my questions.

Thanks,
Geeta

JustMe 10 comments Joined 03/07
27 Jul 2015

Hi Shrity,
I am curious about multiple 'Viewpoint' user sessions.  Right now, there are five viewpoint user sessions showing in Viewpoint.  All are idle and two have been idle for over 30 days. 
Why do we have multiple sessions and only one viewpoint server?  Is it okay to abort sessions that have been idle for so long?

Tdarc1 1 comment Joined 02/12
29 Jul 2015

Shrity, I am trying add a portlet -Performane Data Collection - it says you do not have access to any system. ( even with Aamin access) . Is this beacuse My DB version is not compatable . DB is 14.10. or sould I grant additional access to Viewpoint user ?

Shrity 61 comments Joined 05/12
29 Jul 2015

Kimberly,
You could see more than one Viewpoint sessions running. There are multiple data collectors that get data from the system. But a Viewpoint session being idle for 30 days doesn't sound right. I think it should be ok to abort the long idle session but would recommend on opening a ticket to make sure nothing would break.
Thanks,
Shrity 

Shrity 61 comments Joined 05/12
29 Jul 2015

Krishna,
Yes, Performance data collection portlet works with TD 15.00 and above. So if you do not have a TD 15.00 system connected to Viewpoint server you cannot make use of that portlet. 
Thanks
Shrity

pinaldba 7 comments Joined 09/10
29 Jul 2015

Hi Shrity,
 
Very Nice article !
I would like to know if there are any major improvements for the Workload Monitor Portal as Viewpoint 14.00/15.00 does not have many functinalities.
For example :- Under the Workload Monitor Portal - CPU distruction shows the last 60 minutes trend specifically for the Pie chart. Also, It does not have any option to export the data.
Thanks
Pinal
 
 
 
 

JustMe 10 comments Joined 03/07
03 Aug 2015

Thank you very much.  I will do that.

JustMe 10 comments Joined 03/07
03 Aug 2015

One other question ...this one specifically for Viewpoint 15.10.
 
We are currently running Viewpoing 15.00 and our database verision if TD14.10.
 
We utilize TASM and DSA via viewpoint.
 
What impact, if any, would an upgrade to Viewpoint 15.10 have on TASM and DSA?

Shrity 61 comments Joined 05/12
03 Aug 2015

Pinal,
There was no major changes in Workload monitor portlet with Viewpoint 14.10 or 15.00. 
Thanks
Shrity

Shrity 61 comments Joined 05/12
03 Aug 2015

Kimberly,
Viewpoint 15.10 supports TD 13.10 and above so TASM should be fine when upgrading to Viewpoint 15.10. For DSA, what version of DSA you are on? I would recommend checking the compatibility matrix before the upgrade. Your CSR will have access to the compatibility matrix.
Thanks
Shrity

JustMe 10 comments Joined 03/07
03 Aug 2015

Thank you, Shrity!

jk186045 1 comment Joined 05/11
03 Aug 2015

Are there any best practices that can be used to track any run away queries/sessions and abort them?
 
Thanks

Shrity 61 comments Joined 05/12
03 Aug 2015

Joseph,
There is no best practice guide for Viewpoint. But you can use explain and SQL to identify runaway queries and abort it.
Thanks
Shrity

Jonesj01 1 comment Joined 03/14
06 Aug 2015

Hi Shrity, 
 
This may not be the best place for this question but your article indicates you may be the person to help.
We are running Viewpoint 15.0 and Teradata 14.0 (sles10) - soon to be upgraded to 15 and 11 - the issue is this, I have some users who are using the Myqueries portlet and when they connect to viewpoint all their details have been dropped from the portlet, so they reset the details etc and then they can see all their queries - all good. However half an hour later the Viewpoint portlet drops all the details and associations and they have to once again set up their detils ... this continues throughout the day.
any thoughts?
thanks
 
Jeff
 

Shrity 61 comments Joined 05/12
06 Aug 2015

Jeff,
That absolutely doesn't sound right. Please open a ticket. When you say details are dropped I assume you meant details from "profile menu" where one can associate their Teradata login information.
Thanks
Shrity

26 Aug 2015

Hi Shrity,

 

Now that viewpoint 15.10 has PDCR data maintenance job portlet will there be newer versions of PS provided PDCR scripts (is there a PDCR 15.10 version?)

 

Will PS provided 14.10 PDCR scripts work on TD 15.10 ? 

Thanks
Abhishek Jadhav

TStanek 1 comment Joined 02/15
04 Sep 2015

Hi Shirty,
I need some clarification on the Application Queries and Query Log portlets.
Query Log - From your article, it appears that this portlet is only avaiable if a customer uses the PS offering.  is that correct?  This portlet is not listed in the User Guide.
Also, does the portlet rely solely on PDCR data?  Will it use DBQL data if PDCR is not available?
Application Queries - The article suggests that this portlet is provided wih the PS offering.  However, this portlet is listed in the User Guide, and makes no mention of PDCR.  Does this portlet use DBQL data if PDCR is not available?
Clarification on the availability of the portlets and the data is requires from PDCR and/or DBQL would be really helpful.
Thanks!
Tom Stanek

Shrity 61 comments Joined 05/12
04 Sep 2015

Tom,
Query Log details are in Viewpoint 15.10 User Guide ch. 19. Query Log data collector gets data from PDCRDATA.DBQLogTbl_Hst, so yes PDCR infrastructure is needed. There is no PS offering needed for Query Log or Application Queries portlet.
Thanks
Shrity 

Radsubra2003 1 comment Joined 05/14
30 Sep 2015

Hi Shirty,
 
Our database is 14.10 and we want to upgrade the viewpoint server to 15.10.Will there be any impact.
 
What are the pre requisites for view point upgrade from 15.00 to 15.10 ?
 
Thanks.

Shrity 61 comments Joined 05/12
30 Sep 2015

Viewpoint 15.10 supports TD 14.10 so you should be ok. 
Thanks
Shrity

14 Mar 2016

Hi Shrity,
we are running viewpoint 15.10 on TD 15.0.
Is there a way in viewpoint to discover on what table we are loading data with Multiload/FastLoad ?
I use remote console utility -> query session that tells me for the FASTLOAD/MULTILOAD session what are the "children" and the number of rows read from the source, but it not tells me on what table we are loading data !
Thanks & regars,
Pietro

Pietro Nardella
pietro.nardella@teradata.com
Teradata Italia

StevenSchmid 13 comments Joined 07/11
16 Aug 2016

 

Hi Shirty

 

We have just setup viewpoint 15.11, database is at 15.00.

I'm trying to setup the Query Log data collector, and after granting permisson to PDCRDATA, we are getting the error (red ! on Query Log data collector):

   "Unable to collect QueryLogHst data and flush to cache! Time zone has not been assigned for system DTD1 (id: 2)."

 

Checking the DBS control settings, we have:

   16. System Timezone Hour = 0

   17. System Timezone Minute = 0

   18 System Timezone String = Australian Eastern

 

Can you advise how tom resolve this error.

 

Cheers

 

Steven

Steven Schmid
Teradata DBA
Canberra, Australia

StevenSchmid 13 comments Joined 07/11
17 Aug 2016

Hi
We have found the issue.
Need to fill the new TimeZone field under: Monitored Systems->Setup->General System Details
Cheers

Steven Schmid
Teradata DBA
Canberra, Australia

You must sign in to leave a comment.