All Forums Viewpoint
janetmbeard 1 post Joined 10/13
09 Oct 2013
Identifying Data Lab expiration dates on the system tables

I am looking to identify the expiration date for Data Labs on the system tables, but so far have not been able to find this information.
The reason we require this is for MI and monitoring purposes.

gryback 271 posts Joined 12/08
04 Nov 2013

Not sure what you mean by "system tables" but Data Lab expirations are executed at the data labs level, not for individual tables. You can view a particular data lab expiration date within the "Data Labs" portlet by drilling down into the Lab Group and then the specific data lab. In the details display, there is an "Expries" listing that will have the expration date for this particular data lab.

Sandeepyadav 52 posts Joined 09/13
13 Sep 2015

Hi gryback,
is there any table in teradata so that we can find expiry date in there. Otherwise we have to go one by one lab to find the expiry date.

Thanks, -Sandeep.

gryback 271 posts Joined 12/08
17 Sep 2015

The data lab expirations are not stored anywhere in Teradata, however that doesn't mean you have to view them one by one for each data lab. Check the Data Lab 15.10 release article which shows that all data labs will be presented at the lab group level which can include the "Expires" column where you can view all the data lab expirations at one time. Refer to the link below and the screeen shot under the "The New Data Labs Portlet" header.

You must sign in to leave a comment.