Metrics for Monitoring, Approvals, and Requests Tabs - Teradata Data Lab

Teradata Data Lab User Guide

Product
Teradata Data Lab
Release Number
16.00
Published
October 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
stx1467303288290.ditamap
dita:ditavalPath
2212_User_dl_1600.ditaval.ditaval
dita:id
B035-2212
lifecycle
previous
Product Category
Analytical Ecosystem

The metrics that appear in the Monitoring, Approvals, and Requests tabs are listed below.

A 1024 byte kilobyte is used as the base for all memory-related and space-related metrics that display, such as spool space, disk space, memory usage, and so on. A 1000 byte kilobyte is used as the base for all other metrics.
Metric Description Tab Table
% Allocated Percentage of lab group space allocated to labs

The value appears red when the allocated space is within the specified percentage of the lab group size if you set a threshold for Lab Group Size in the Settings view

Monitoring Lab Groups
% Used Percentage of total space in use within all labs in the lab group Monitoring Lab Groups
Percentage of allocated space in use within the lab

The value appears red in the Labs table when the used lab space is within the threshold set for Lab Size in the Settings view

Monitoring Labs
Allocated Space allocated to labs in the lab group

The value appears red when the allocated space is within the specified percentage of the lab group size if you set a threshold for Lab Group Size in the Settings view

Monitoring Lab Groups
Approver Who approved the request, displayed as the Viewpoint user ID Requests Requests
Available Amount of unallocated space for the selected lab group Approvals Approvals
Comments Comment from the requester at the time the request was submitted Approvals Approvals
Created Date the lab group was created Monitoring Lab Groups
Date the Teradata Database table was created Monitoring Tables
Created by Creator of the Teradata Database table, displayed as the Teradata Database user ID Monitoring Tables
Date Date the request was made

The date appears red when a response to an approval has not been received by the specified number of days if you set a threshold for Approvals in the Settings view

Approvals Approvals
Date the request was made Requests Requests
Description Description of the lab group Monitoring Lab Groups
Description of the lab Monitoring Labs
Description of the table Monitoring Tables
Expires Date the lab expires Approvals Approvals
Date the lab expires

The date in the Expires column appears red in the Labs table the specified number of days before the lab expires if you set a threshold for Expiration in the Settings view

Monitoring Labs
Lab Name of the lab Approvals Approvals
Name of the lab Monitoring Labs
Name of the lab Requests Requests
Lab Group Name of the lab group Approvals Approvals
Name of the lab group Monitoring Lab Groups
Name of the lab group Requests Requests
Location Fully qualified location of the table in the Teradata Database for only drop table requests Approvals Approvals
Name of the lab group user in the Teradata Database Monitoring Lab Groups
Name of the lab database in the Teradata Database Monitoring Labs
Fully qualified name of the table in the Teradata Database Monitoring Tables
New Expiration Updated expiration date after an Extend Lab request has been approved Approvals Approvals
Owners Lab group owners, displayed as the Teradata Viewpoint user ID and/or role Monitoring Lab Groups
Lab owners, displayed as the Teradata Viewpoint user ID and/or role Monitoring Labs
Parent DB Name of the parent Teradata Database in which the lab group resides Monitoring Lab Groups
Private A check mark indicates the lab group owner has restricted which Teradata Database users and roles can access the lab group

No check mark indicates users and roles are not restricted from accessing the lab group

Monitoring Lab Groups
Requested Amount of space by which the lab size will be increased or decreased Approvals Approvals
Requester Username of the requester, displayed as the Viewpoint user ID Requests Requests
Schema Changed Date of the most recent table schema change and which Teradata Database user made the change Monitoring Tables
Size Total space allocated to the lab group Monitoring Lab Groups
Total space allocated to the lab Monitoring Labs
Total size of the table Monitoring Tables
Skew If a threshold is set, percentage of table skew that is under the set threshold appears black

The percentage of the table skew that exceeds the set threshold appears red in the Tables table in the Skew column if you set a threshold for Skew in the Settings view

Monitoring Tables
Space Bar chart showing the total space allocated to the lab group in gray, the space allocated to labs in the lab group in dark green, and the space in use within all labs in the lab group in light green Monitoring Lab Groups
Bar chart showing the total space allocated to the lab in gray and the amount of space in use within the lab in dark gray Monitoring Labs
Status Status of the request as one of the following:
  • Approved
  • Successful
  • Pending
  • Denied
  • Failed

Failed requests appear red

Requests Requests
Table Name of the Teradata Database table Monitoring Tables
Name of the Teradata Database table Approvals Approvals
TD User User name of the requester, displayed as the Teradata Database user ID Approvals Approvals
Type Request type Approvals Approvals
Request type Requests Requests
Used Space in use within all labs in the lab group Monitoring Lab Groups
Amount of space in use within the lab

The value appears red in the Labs table when the used lab space is within the threshold set for Lab Size in the Settings view

Monitoring Labs
VP User Viewpoint user ID of the requester Approvals Approvals