15.10 - MonitorWDRate - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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
     ) 
            .
            .
            .
;
 

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.

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