MonitorAWTResource Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
REPLACE FUNCTION SYSLIB.MonitorAWTResource (
  Threshold1 INTEGER,
  Threshold2 INTEGER,
  Threshold3 INTEGER,
  Threshold4 INTEGER
) RETURNS TABLE (
    IntervalCount1 INTEGER,
    IntervalCount2 INTEGER,
    IntervalCount3 INTEGER,
    IntervalCount4 INTEGER,
    FlowControl INTEGER,
    HighAMP1VprocId INTEGER,
    HighAMP1InUseCount INTEGER,
    HighAMP2VprocId INTEGER,
    HighAMP2InUseCount INTEGER,
    HighAMP3VprocId INTEGER,
    HighAMP3InUseCount INTEGER,
    HighAMP4VprocId INTEGER,
    HighAMP4InUseCount INTEGER,
    HighAMP5VprocId INTEGER,
    HighAMP5InUseCount INTEGER,
    LowAMP1VprocId INTEGER,
    LowAMP1InUseCount INTEGER,
    LowAMP2VprocId INTEGER,
    LowAMP2InUseCount INTEGER,
    LowAMP3VprocId INTEGER,
    LowAMP3InUseCount INTEGER,
    LowAMP4VprocId INTEGER,
    LowAMP4InUseCount INTEGER,
    LowAMP5VprocId INTEGER,
    LowAMP5InUseCount INTEGER,
    FCVprocId1 INTEGER,
    FCVprocId2 INTEGER,
    FCVprocId3 INTEGER,
    FCVprocId4 INTEGER,
    FCVprocId5 INTEGER
  )
  ...
;

Syntax Elements

Threshold1
Minimum value for in-use AWTs to qualify an AMP for inclusion into this interval.
Threshold2
Threshold3
Threshold4
Start value for in-use AWTs to qualify an AMP for inclusion into this interval.
IntervalCountn
Where n in [1, 4]: Number of AMPs in the system whose in-use AWT counts fall at, or above, the Thresholdn value and do not qualify for the higher thresholds.
FlowControl
Number of AMPs in a form of Flow Control.
HighAMPnVprocId
Where n in [1, 5]: Vproc ID of the AMP with the nth highest in-use count in the system. A value of -1 indicates this field is not defined.
HighAMPnInUseCount
Where n in [1, 5]: In-use count associated with HighAMPnVprocId. Applicable only if HighAMPnVprocId is defined.
LowAMPnVprocId
Where n in [1, 5]: Vproc ID of the AMP with the nth lowest in-use count in the system. A value of -1 indicates this field is not defined.
LowAMPnInUseCount
Where n in [1, 5]: In-use count associated with LowAMPnVprocId. Applicable only if LowAMPnVprocId is defined.
FCVprocIdn
Where n in [1, 5]: The vproc ID of the AMP in flow control. A value of -1 indicates this field is not defined.