Purpose
Returns the collection rate, number of nodes with at least one online AMP, and number of nodes with at least one online PE.
Definition
REPLACE FUNCTION SYSLIB.MonitorWDRate() RETURNS TABLE (SampleRate SMALLINT, AMPNodes SMALLINT, PENodes SMALLINT ) . . . ;
Result Rows
| Column Name | Description |
|---|---|
| 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