MonitorAMPLoadSV - 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

This single operational view API aggregates AMP load data across VantageCloud Lake clusters.

Syntax

REPLACE FUNCTION SYSLIB.MonitorAMPLoadSV (
) RETURNS TABLE (
    VprocNo SMALLINT,
    AvailableAWTs INTEGER,
    InUseAWTs INTEGER,
    MsgCount INTEGER,
    DQMsgCount INTEGER
    AvailableAWTsForAll INTEGER,
    Type VARCHAR,
    Id VARCHAR,
    Name VARCHAR,
    Group VARCHAR
  )
  ...
;

Syntax Elements

VprocNo: AMP vproc number.; This value is incremented by 10000 for each compute cluster for the single view. For example, the first AMP of the primary cluster starts at 1, the first AMP of the first online compute cluster starts at 10001, and the first AMP of the second online compute cluster starts with 20001, and so on.
AvailableAWTs: Number of AMP worker tasks in each AMP available to support new work.
InUseAWTs: Number of active AMP worker tasks in each AMP.
MsgCount: Number of messages queued for delivery to each AMP.
DQMsgCount: Number of messages processed by each AMP.
AvailableAWTsForAll: The number of available AMP worker tasks in the unreserved pool in each AMP.

Type: Only available in the detailed view. Identifies the group type (compute cluster or primary cluster).

Id: Only available in the detailed view. Provides the TOS identifier the of the group (useful to identify compute clusters).
Name: Only available in the detailed view. Provides the name of the compute cluster.

Group: Only available in the detailed view. Provides the name of the compute group.