Returns the data from the third statement of the MONITOR AWT RESOURCE request response.
Syntax
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 currently 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.
Usage Notes
For information on the third statement returned from the MONITOR AWT RESOURCE request response, see Statement 3 - MONITOR AWT RESOURCE.
Example: Data Reported in Statement 3 of MONITOR AWT RESOURCE
This example shows the data reported in statement 3 of MONITOR AWT RESOURCE.
SELECT * FROM TABLE (MonitorAMPLoad()) AS t1;
Result:
*** Query completed. 4 rows found. 6 columns returned.
*** Total elapsed time was 1 second.
VprocNo 0
AvailableAWTs 49
InUseAWTs 2
MsgCount 0
DQMsgCount 737
AvailableAWTsForAll 55
VprocNo 1
AvailableAWTs 49
InUseAWTs 1
MsgCount 0
DQMsgCount 765
AvailableAWTsForAll 56
VprocNo 2
AvailableAWTs 49
InUseAWTs 1
MsgCount 0
DQMsgCount 695
AvailableAWTsForAll 56
VprocNo 3
AvailableAWTs 48
InUseAWTs 2
MsgCount 0
DQMsgCount 863
AvailableAWTsForAll 56