Returns the collection rate, number of nodes with at least one online AMP, and number of nodes with at least one online PE.
REPLACE FUNCTION SYSLIB.MonitorWDRate() RETURNS TABLE (SampleRate SMALLINT, AMPNodes SMALLINT, PENodes SMALLINT ) . . . ;
|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; *** Query completed. One row found. 3 columns returned. *** Total elapsed time was 1 second. SampleRate 600 AMPNodes 1 PENodes 1