15.10 - MonitorAMPLoad - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Returns the data from the third statement of the MONITOR AWT RESOURCE request response.

REPLACE FUNCTION SYSLIB.MonitorAMPLoad()
  RETURNS TABLE
   (VprocNo SMALLINT,
    AvailableAWTs INTEGER,
    InUseAWTs INTEGER,
    MsgCount INTEGER,
    DQMsgCount INTEGER
   )
    .
    .
    .
;

For information on the third statement returned from the MONITOR AWT RESOURCE request response, see “Statement 3” on page 81.

 

Column Name

Description

VprocNo

AMP vproc number.

AvailableAWTs

Number of available AMP worker tasks in each AMP.

InUseAWTs

Number of active AMP worker tasks in each AMP.

MsgCount

Number of messages currently queued for delivery to each AMP.

DQMsgCount

Number of messages processed by each AMP.

This example shows the data reported in statement 3 of MONITOR AWT RESOURCE.

SELECT * FROM TABLE (MonitorAMPLoad()) AS t1;
RESULTS SIDETITLES
 
VprocNo       :      0
AvailableAWTs :          48
InUseAWTs     :           3
MsgCount      :           0
DQMsgCount    :        1026
 
VprocNo       :      1
AvailableAWTs :          49
InUseAWTs     :           1
MsgCount      :           0
DQMsgCount    :        1080