ComputeProfileHistoryEventsV[X] | VantageCloud Lake - ComputeProfileHistoryEventsV[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 duration during which compute resources are in a given state, use this view to:

  • Compute the amount of time during a month when compute clusters were available.
  • Identify time periods when compute clusters were hibernated.
View Column Data Type Format Comment
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.
ComputeID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the ID of the compute cluster.
ComputeGroupID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the ID of the compute group.
SystemID VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Returns the internal ID of the customer System.
StartTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns the timestamp for the compute cluster event online.
EndTime TIMESTAMP(6) YYYY-MM-DDBHH:MI:SS.S(6) Returns the timestamp for the compute cluster event offline/dropped.
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.