REPLACE FUNCTION SYSLIB.MonitorAMPLoad (
) RETURNS TABLE (
VprocNo SMALLINT,
AvailableAWTs INTEGER,
InUseAWTs INTEGER,
MsgCount INTEGER,
DQMsgCount INTEGER
AvailableAWTsForAll INTEGER
)
...
;
Syntax Elements
- 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 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.