COMPUTE GROUP and COMPUTE PROFILE Status Views | VantageCloud Lake - COMPUTE GROUP and COMPUTE PROFILE Status Views - 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

The CLOUDSTATUS table operator generates the outputs for compute groups and compute cluster views.

COMPUTE GROUP View Example

select * from dbc.computestatusvx;
*** Query completed. 5 rows found. 10 columns returned.
*** Total elapsed time was 1 second.

ComputeProfileName  SCALING_RESOURCE
  InstanceName  9c6q05
  ComputeGroupName  SCALING
    ComputeMapName  TD_COMPUTE_TINY
      PdeState
      DbsState
  CurrentState  Terminated
  LastReqState  ACTIVE
LastStartTime  2021-12-02 17:12:12 +0000 UTC
   LastEndTime  2021-12-02 17:22:49 +0000 UTC
ComputeProfileName  SCALING_RESOURCE
  InstanceName  axsycp
  ComputeGroupName  SCALING
    ComputeMapName  TD_COMPUTE_TINY
      PdeState
      DbsState
  CurrentState  Deploying
  LastReqState  ACTIVE
LastStartTime  2021-12-02 21:51:48 +0000 UTC
   LastEndTime
ComputeProfileName  SCALING_RESOURCE
  InstanceName  qrzl0r
  ComputeGroupName  SCALING
    ComputeMapName  TD_COMPUTE_TINY
      PdeState
      DbsState
  CurrentState  Terminated
  LastReqState  ACTIVE
LastStartTime  2021-12-02 17:12:15 +0000 UTC
   LastEndTime  2021-12-02 17:27:23 +0000 UTC
ComputeProfileName  SCALING_RESOURCE
  InstanceName  ucpygx
  ComputeGroupName  SCALING
    ComputeMapName  TD_COMPUTE_TINY
      PdeState
      DbsState
  CurrentState  Deploying
  LastReqState  ACTIVE
LastStartTime  2021-12-02 21:51:49 +0000 UTC
   LastEndTime
ComputeProfileName  SCALING_RESOURCE
  InstanceName  akv7d0
  ComputeGroupName  SCALING
    ComputeMapName  TD_COMPUTE_TINY
  CurrentState  Active
  LastReqState  ACTIVE
LastStartTime  2021-12-02 17:12:18 +0000 UTC
   LastEndTime

COMPUTE PROFILE View Example

select * from dbc.computestatusvx;
*** Query completed. 3 rows found. 9 columns returned.
*** Total elapsed time was 1 second.

ComputeProfileName SHIPPINGCG02
       InstanceName cjc84k
   ComputeGroupName SHIPPING
     ComputeMapName TD_COMPUTE_XSMALL
ComputeInstanceType STANDARD
       CurrentState Active
       LastReqState ACTIVE
      LastStartTime 2022-12-06 18:16:35 +0000 UTC
        LastEndTime
ComputeProfileName SHIPPINGCG02
       InstanceName b3rq1h
   ComputeGroupName SHIPPING
     ComputeMapName TD_COMPUTE_XSMALL
ComputeInstanceType STANDARD
       CurrentState Hibernated
       LastReqState ACTIVE
      LastStartTime 2022-12-06 18:16:36 +0000 UTC
        LastEndTime 2022-12-06 18:27:55 +0000 UTC
ComputeProfileName SHIPPINGCG02
       InstanceName hm4sbk
   ComputeGroupName SHIPPING
     ComputeMapName TD_COMPUTE_XSMALL
ComputeInstanceType STANDARD
       CurrentState Hibernated
       LastReqState ACTIVE
      LastStartTime 2022-12-06 18:16:35 +0000 UTC
        LastEndTime 2022-12-06 18:33:23 +0000 UTC