Returns the collection rate, number of nodes with at least one online AMP, and number of nodes with at least one online PE.
Syntax
REPLACE FUNCTION SYSLIB.MonitorWDRate (
) RETURNS TABLE (
SampleRate SMALLINT,
AMPNodes SMALLINT,
PENodes SMALLINT
)
...
;
Syntax Elements
- SampleRate
- Number of seconds of the collection period.
- AMPNodes
- Number of nodes with at least one online AMP.
- PENodes
- Number of nodes with at least one online PE.
Example: Using MonitorWDRate
SELECT * FROM TABLE (MonitorWDRate()) AS t2;
Result:
*** Query completed. One row found. 3 columns returned. *** Total elapsed time was 1 second. SampleRate 600 AMPNodes 1 PENodes 1