Teradata is very pleased to announce the official release of the new product offering called Teradata Data Lab. At this same time, Teradata is releasing the new Teradata Viewpoint 14.00 version. These are two separate offerings just released in the same timeframe as a matter of convenience. Read below for information on both of these new Teradata offerings.

Summary

The primary goal of Teradata Viewpoint 14.0 is to support the Teradata Database 14.0 releases, both TD 14.0 on SLES10 and TD 14.0 on SLES11. The majority of this work was to provide the enabling interfaces for the TD 14.0 SLES11 new workload management stack. As such, the amount of "general" features was limited but there are still some additions of interest. Check out the Teradata Viewpoint 14.0 section below for more details. Lastly as always, the new Viewpoint release represents an integration of patch releases into the base release.

Aligned with this Viewpoint release is the very exciting new Teradata offering called Teradata Data Lab. Teradata Data Lab refers to work spaces or maybe better known as "sandboxes" within the data warehouse where users can explore, analyze new data, and test data value theories. Teradata Data Lab is a separately sold product that provides Viewpoint portlets that assist in governance, auto-provisioning, and monitoring of these "sandboxes". See below for more details on Teradata Data Lab and the Lab Group Setup and Data Labs portlets in this initial release.

Teradata Viewpoint 14.0

As mentioned, Viewpoint 14.0 main focus was on the interface support of the Teradata Database 14.0 releases, and in particular the new workload management coming with TD 14.0 SLES11. Additional details on this new foundation will be included in future article aligned with the actual Teradata DB 14.0 SLES11 release. However there are other items of interest in this release. First related to Teradata DB 14.0 release, is the introduction of a significant number of new TASM state matrix events. As a quick review, the state matrix allows automated adjustment of TASM ruleset values associated to a state change, being either planned or unplanned. The new state matrix events are:

  • System CPU Utilization
  • System-wide Node Skew
  • By Workload Definition (WD) Events:
    • CPU Utilization
    • Missed Service Level Goal (SLG)
    • Arrival Rate
    • Concurrent Active Requests
    • Delay Queue Size
    • Delay Queue Depth
    • Message Delay Time
A general feature addition (meaning no dependency on a specific Teradata Database version) worth noting is the new "Skew" tab in Query Monitor and My Queries portlets which displays details about the level of the skew in the query or session. See below for more information. Another administrative change worth mentioning is addition of a "SQL Explain" control for the Sessions data collector. This allows one to stop collection of the SQL and Explain information as part of the Sessions collection. This might be considered for performance or security considerations.

"Skew" tab

The skew tab is a new option in the Query Monitor and My Queries portlets details view that provides CPU and I/O skew information and how it relates to specific AMPs. It lists the high and low impacted AMPs as well as an overall AMP participation count. So drilling down on a skew query provides you the new skew tab which will present information as shown below.

Data Lab Concept

A challenge for any organization with a production data warehouse is how to allow for data proofing and new data value investigations while maintaining the relationships to production data. Bringing this concept data into production often becomes a contention between the need for flexibility and the IT processes necessary for protecting and staging data in the production environment. There is also the obstacle of the DBA feeling that they cannot take on the additional responsibility of managing a development environment and in particular, one that may have negative impact on production operations performance and service levels.

The end result often becomes exporting the production data out of the data warehouse consuming precious resources with very little value to the production environment itself. This data then moves into hidden infrastructure servers and client systems resulting in stale data, conflicting reports, outdated data models, as well as security and privacy adherence concerns.

Teradata Data Lab advocates providing space in the production environment for this effort with automated and distributed management and protected by built-in hooks into Teradata workload management strategies. Email is leveraged for notifications and intuitive Viewpoint portlet interfaces for everything. That's Teradata Data Lab. Continue reading for more details on the available portlets for this initial product release.

Lab Group Setup

The first Data Lab portlet to discuss is the setup and configuration portlet called Lab Group Setup. Upon loading of this portlet, it will ask for Teradata credentials as you will need the necessary Teradata system permissions to define the lab space. Clicking on the "Add Lab Group" gets you started and then leads you through an easy five step process for setting up the lab group. As shown below, the first step allows configuration of the name, available space, default lab size, and a lab prefix that will be an easy integration mechanism with Teradata workload management.

Also notice the email notifications setup for easy automated "hands free" communications to the Data Labs users. Subsequent steps will allow configuration of Viewpoint ownership users and roles as well as Teradata user and roles access. Lastly step #5 will be setup of thresholds and approvers for various requests. This is where you decide on how open or controlled the lab is going to be. The example below is a mix of automation and manual controls.

If you have a plan on how you want the data lab environment to be established, setup through this Viewpoint portlet takes just a few minutes to complete. You can return to this portlet any time you need to view, edit, or delete lab group environments.

Data Labs

The Data Labs portlet will be used by DBAs, lab group owners, and user/consumers of data labs for creation, monitoring, and administration of data labs, in other words the on-going operations. Once connected to the associated Teradata system, the Data Labs portlet offers three main tabs (Monitoring, Approvals, Requests).

The Monitoring tab provides views at the lab group, lab, and table levels through easy point and click operations. Specific information is given at each of the levels for things such as size, ownership, expirations, etc accompanied by cylinder views for space usage. This is a view at the lab level:

The Approvals tab is what you would expect it to be. When a data lab request is made, it is added to a request queue for approval. You can view these unapproved requests within this tab if you are a lab group or lab owner. This is also where approvals or denials of requests are managed.

The third tab, Requests, is also what you might anticipate it is. This portlet is going to be commonly used by the user/consumers of data labs. Requests can be for a variety of data lab operations and necessities including:

  • Add or delete labs
  • Increase or decrease lab size
  • Add or remove users from labs
  • Add or remove owners from labs
  • Extend lab expiration dates
  • Promote or drop tables
  • Change lab details
  • Send other requests

Users can also review their requests within this portlet to understand status. Has it been approved, denied, or still pending? The portlet provides pull downs for easy lab group and lab filtering as well as operations for managing your requests. A simple example is shown below with various requests, in different states, and preparation for deleting one of the older requests.

One last item worth noting. The preferences for both Lab Group Setup and Data Labs portlets allow setting of thresholds for highlighting in the portlet views as well as configuration of optional email notifications.

That's Teradata Data Lab! See the Teradata Data Lab User Guide for more information.

Discussion
geethareddy 104 comments Joined 10/11
19 Dec 2011

Gary,
While we are upgrading from 13.11 to 13.12, first we upgraded from SLES 9 to SLES 10.
So V 14 wont work if we have SLES 9 or 8 apart from SLES 10/11? can you confirm.

Thanks,
Geeta

gryback 132 comments Joined 12/08
19 Dec 2011

I assume you are talking about the OS version of your Teradata system and if so, Viewpoint will handle any supported OS that Teradata DB supports. Viewpoint 13.11, 13.12 and 14.00 support Teradata DB V2R6.2 or newer with one exception. Workload Designer requires Teradata DB 12.0 or newer.

geethareddy 104 comments Joined 10/11
19 Dec 2011

OK let me rephrase my question,
i am talking about the LINUX OS. I want to clarify my self about the point in the above article: "Viewpoint 14.0 is to support the Teradata Database 14.0 releases, both TD 14.0 on SLES10 and TD 14.0 on SLES11.". Let us say our DB is V12 and OS SLES 9, in that case can we use Viewpoint V14 directly OR we need to upgrade it to SLES 10 or 11 to support Viewpoint V14

Thanks,
Geeta

gryback 132 comments Joined 12/08
20 Dec 2011

Yes I get it, Viewpoint 14.0 supports V12 on any operating system version including SLES9. Don't confuse this article as a support policy statement. This is the Viewpoint 14.0 release article stating what is new in the release. Your Teradata CSR should be able to help you with compatibility questions and upgrades so you won't need to worry about that yourself.

geethareddy 104 comments Joined 10/11
20 Dec 2011

Perfect, thank you.

Thanks,
Geeta

kerrg 2 comments Joined 10/10
22 Jan 2012

Gary,

I have now got the data labs portlet up and running. Thanks for the 2 fixes applied to the latest patch. Just an observation in that I think you are missing a level of authority in the process. We would like to setup Lab Groups for each division with a nominated power user as the owner who can manage the space allocation and users within that group but I don't want them to be able to approve extensions of labs. It would be good if you had a Lab Administrator level which could control extensions or have a setting for the maximum lifespan of a lab.

gryback 132 comments Joined 12/08
24 Jan 2012

I would suggest submitting an RFC through the GSC for this request. That way it will be formally documented and tracked as such.

01 Feb 2012

Gary,

Thank you for the insightful reading material - it will most definitely make a difference in the next few months to many people. My question around Data Labs as well as Viewpoint is if there is anything similar to Teradata Express available. I view Teradata Express as my own play area where I can mess around with new features without the risk of hurting any environment (either during training or where I am investigating a specific feature). Is there something similar that exists for both Viewpoint as well as the Data Labs?

gryback 132 comments Joined 12/08
01 Feb 2012

You are welcome, thanks for acknowledging. Teradata Express 13.10 version has a Viewpoint Express built in but disabled by default. So you have access to that now on the download center. For Data Lab, you are going to need to wait for a Teradata Express 14.0 version. I'm just not sure where that will be posted although I know it is planned. Stay tuned.

MarkVYoung 20 comments Joined 03/12
12 Jul 2012

How do we get the Data Labs portlet?

12 Jul 2012

Hi, its been a while since posting and my respect for viewpoint has grown in leaps and bounds with almost every release. Yesterday was a blend of rewind, heatmaps and good old fashioned investigation whereas today is all about portlets and uncovering some brilliant ways of expressing things worthwhile mentioning... If you download Teradata Express 14, dont forget to read the configuration manual. The first section is dedicated to configuring Viewpoint 14 which would include the portlet you are looking for :)

gryback 132 comments Joined 12/08
12 Jul 2012

Teradata Data Lab is included in the Teradata DB 14.0 Express VMware player edition. You will need to enable Viewpoint and configure Data Lab. Reference the Data Lab User Guide for information on the "Lab Group Setup" and "Data Labs" portlets.

MarkVYoung 20 comments Joined 03/12
12 Jul 2012

What I meant was, how to I get the Data Labs portlet for our production viewpoint? We are running with Teradata Viewpoint V14.00.00.00-b9, but there is no Data Labs portlet included.

gryback 132 comments Joined 12/08
12 Jul 2012

Teradata Data Lab is a separately priced product offering so you will need to discuss with your Teradata account representative.

bs520147 12 comments Joined 04/12
20 Dec 2012

Hello. I have a problem with permissions. When I'm trying to add a new Lab group and I write a 'Parent database', I get the folowing message: 'You do not have permissions to create a lab group'. What's the problem? Thanks

gryback 132 comments Joined 12/08
20 Dec 2012

Most likely your issue is that your associated Teradata login does not have the proper permissions for creating the necessary Database objects on the Teradata system. Data Lab has dependencies on your Viewpoint login as well as your Teradata login.

bs520147 12 comments Joined 04/12
20 Dec 2012

Thank you. I solve the problem. I've read in 'Teradata Data Lab User Guide' that the Teradata user that I use when I log into the 'Lab group Portlet' must have the following privileges: 'Create/Drop User and Table' and 'Create/Drop Roles with Grant'.

Ashwin4tera 17 comments Joined 11/11
22 Jul 2013

Hi gryback,
Very good article.
We have recently bought datalab on our site
view point version 14.01 on 13.10.
I have created a lab in a lab group and added couple users in Default Users Tab but usres are still not able to access the lab.
Does this required a role with all rights to full access the lab or just adding user to the lab is enough to gaet full access to the lab?
Please help me on this.
Thanks 
 
 

gryback 132 comments Joined 12/08
22 Jul 2013

There has been user access fixes in both Data Lab 14.01.00,04 patch as well as the latest Data Lab 14,10 patch release. To determine which of the patch levels will solve your problem, you should work with your account team to submit a support incident to review the issue to ensure the right patch level will solve your issue.

Ashwin4tera 17 comments Joined 11/11
23 Jul 2013

@gryback
OK, I will create a incident.
Thank you..!

20 Feb 2014

Hi,
 
Can someone please let me guide from where can I download the Teradata vierw point?
 
Regards,
Nishit

gryback 132 comments Joined 12/08
20 Feb 2014

There is no download solely for Viewpoint. Teradata Express versions have an embedded Viewpoint but it can only manage the associated Teradata DB Express version. 

28 May 2014

Hi,
I have TD Express 14.10.01 SLES10 for VMware setup. I am able to login to Viewpoint. However, I cannot see the DataLab or Lab Group Setup portlet from the portlet library. Do I need to download/install something specific to have the DataLab portlets available in Viewpoint?
Kind regards,
Joy

gryback 132 comments Joined 12/08
28 May 2014

Sorry but Data Lab was not included with the Express version of Viewpoint. We will consider adding it to a future Express release. 

stofeben 1 comment Joined 05/13
11 Jun 2014

Hi,
I use TD SQL assistant 14, could you tell me how can i get viewpoint??
Thanks for help.

gryback 132 comments Joined 12/08
11 Jun 2014

I believe you received your answer in the Viewpoint forum from Dieter.
http://forums.teradata.com/forum/viewpoint/viewpoint-software
 

lohtera 1 comment Joined 06/14
2 months ago

I am new to Datalabs. After pre- creating a parent database of say 200GB. I move to viewpoint to create the lab group.  When populating the "Parent" database field the available space states 3.37GB. My initial viewpoint login is my lan account that has the Administrator role.  The account used in the Lab Group Setup is sysdba. So I do not think I have a permissions issue.
Any assistance would be appreciated.
 

gryback 132 comments Joined 12/08
2 months ago

This honestly makes no sense that the "available space" in the Lab Group Setup portlet is different (and vastly) than what you allocated on the parent DB. I'm assuming you verified that there actually is 200GB free on this parent database directly and not that something was broken in the allocation or some other usage of the space? If so, please submit a support incident because we have not encountered an issue like this before.

Rajeshkollu 4 comments Joined 10/11
2 months ago

Gary,
Does any of the dbc dictionary tables store Data Labs name, Original Expiry date and new expiry date?
I am looking at one of Data Lab Lab_ABC
1) Lab_ABC was created on 2/4/2014 and expiration date as 4/5/2014.
2) Lab_ABC was extended till 7/4/2014 on 4/1/2014.
3) Lab_ABC was extended till 8/4/2014 on 7/1/2014.
My Labs portlet shows Lab_ABC expiration date as 7/4/2014 and when click on the date it shows expiry data as 8/4/2014.
This is causing confusion as some of the Lab owners are thinking their Labs are expired though it was extended.
Any insight on this will be very helpful.
 
Thanks!
Raj

gryback 132 comments Joined 12/08
2 months ago

That information is stored in Viewpoint not DBC tables. However, this appears to be a possible bug. I would suggest a Teradata support incident be submitted for analysis of the issue.

Rajeshkollu 4 comments Joined 10/11
2 months ago

Gary,
Thank you and we are going to open Incident with Teradata.
I have another question:
1) We have created one Data Lab today (7/13/2014)with expiry of 6 months (1/12/2015) . Now I want to change Data Lab expiry date to 10/12/2014).
 
How can i change the date from 1/12/2015 to 10/12/2014?
 
Thanks!
Raj

gryback 132 comments Joined 12/08
2 months ago

Raj,
Interesting use case and not one we can easily address currently. Your option is to create a new Data Lab with the desired expiration timeframe with the same user information and move the table(s) over into it.
 
This gets somewhat easier with the next release of Data Lab as we will offer custom date ranges for expirations, allowing any x number of days. So would allow you to set an exact date.
 
I've also created a new requirement for future consideration for a "change expiration date" option to easily allow for reduction of an extension.
Gary

LUCAS 9 comments Joined 06/09
2 months ago

Gary,
i'm discovering Labgroups (V14.10) : it looks like a standard set of rights were prepared at Labgroup level, except DELETE (?), and available at the Labgroup creation time.
I can't find any comment in Viewpoint User guide on "automatic rights" : can a Labgroup user (owner) access those definitions,
remove some rights, add other rights (DELETE) ?
Thanks,
Pierre

gryback 132 comments Joined 12/08
2 months ago

I believe the DELETE omission issue was fixed but I would suggest submitting a support incident for confirmation.
One should not be modifying the rights of a Lab Group as it may cause havoc with Data Lab operations.

LUCAS 9 comments Joined 06/09
1 month ago

Thanks Gary,
I do agree with you about modifying rights.
this being said, all of those rights in place are available for users in datalabs belonging to Labgroups:
how to deal to afford some users to read data, and give create objet rights to others ...
I found nothing in documentation,
Pierre

gryback 132 comments Joined 12/08
1 month ago

When adding users through the Lab Group Setup portlet or through Data Labs portlet requests, one has the option to choose read only.

GDHAR 4 comments Joined 08/14
1 month ago

Hello Gary,
I have created a lab group named "Test_lab_grp" successfully and deleted the same after few days. When i tried to create another lab group with the same name ("Test_lab_grp" which was deleted), it is showing the data lab group name already exist. Cann't we use the same name which was used earlier though it was deleted successfully?
Thanks in advance.
GDHAR.

gryback 132 comments Joined 12/08
1 month ago

GDHAR,
Did you delete the Lab Group through the Lab Group Setup portlet? What version of Data Lab are you running? 

GDHAR 4 comments Joined 08/14
4 weeks ago

Hi Gary,
Thanks for the quick responce. Yes, i have deleted the Lab Group through the Lab Group Setup portlet only. Presently we are useing Data Lab 14.10 and TD 13.10.07 version.
Thanks in advance.
GD.

gryback 132 comments Joined 12/08
4 weeks ago

I don't see anything related to this in any patch descriptions. As such, I'd recommend filing a Teradata services support incident for further analysis and resolution.

GDHAR 4 comments Joined 08/14
4 weeks ago

Thanks Gary!

GDHAR 4 comments Joined 08/14
5 days ago

Hello Gary,
We have an issue in viewpoint Data Lab. When we tried to add a user to an existing Lab, we got an error message saying, "Password has expired, please use MODIFY USER statement to generate a new password. So we have reset the lab user password in SQL Assistant and tried to add user again, but it is not working even. Any assistance would be appriciated.
 
Thanks in advance.
GD.

gryback 132 comments Joined 12/08
5 days ago

GD,
Please submit a support services incident for analysis and resolution.
Gary

You must sign in to leave a comment.