MonitorAMPLoadSV - Teradata VantageCloud Lake

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.