ComputeProfileHistoryV[X] | VantageCloud Lake - ComputeProfileHistoryV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Database: td_metric_svc

If you need detailed information about the events that determine a change to the state of your compute cluster, use this view to:

  • Determine when a compute cluster autoscaled up or down.
  • Identify events that bring a compute cluster online or offline.
  • Validate the identify overlap between different compute profiles in a compute group.
View Column Data Type Format Comment
Location VARCHAR(2048) UNICODE CASESPECIFIC X(2048) Path to metric data objects.
EventTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns the time that the compute cluster event was recorded.
InstanceName VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the name of the instance.
ComputeGroupName VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the compute group name to which the compute profile is associated to.
ComputeProfileName VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the name of the compute profile.
ComputeGroupID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the ID of the compute group.
ComputeID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the ID of the compute cluster.
SystemID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the internal ID of the customer System.
State VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the status of the compute cluster.
ComputeMapName VARCHAR(512) UNICODE NOT CASESPECIFIC| X(512) Returns the name of the compute map.
Component_ID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the operational group compute cluster ID.
NodeCount SMALLINT -(5)9 Returns the node count of the compute map.
InstanceType VARCHAR(30) LATIN UPPERCASE X(30) Returns the instance type of the compute map.
AMPsPerNode SMALLINT -(5)9 Returns the AMPs per Node of the compute map.