15.10 - TDWMSummary - Teradata Database

Teradata Database Application Programming Reference

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

Returns the Teradata dynamic workload management software WD summary data fields.

 
REPLACE FUNCTION TDWM.TDWMSummary()
 RETURNS TABLE
  (WDId INTEGER,
   Arrivals INTEGER,
   Completions INTEGER,
   MinRespTime FLOAT, 
   MaxRespTime FLOAT,
   AvgRespTime FLOAT,
   MinCPUTime FLOAT,
   MaxCPUTime FLOAT,
   AvgCPUTime FLOAT,
   DelayedCnt INTEGER,
   AvgDelayTime FLOAT,
   ExceptionCnt INTEGER,
   MetSLGCnt INTEGER,
   ActiveQueryCnt INTEGER,
   ActiveDelayedCnt INTEGER,
   ErrorCnt INTEGER,
   AbortCnt INTEGER,
   VirtualPartNum INTEGER,
   AvgIOWaitTime FLOAT,
   MaxIOWaitTime FLOAT,
   AvgOtherWaitTime FLOAT,
   MaxOtherWaitTime FLOAT,
   AvgCPURunDelay FLOAT,
   MaxCPURunDelay FLOAT,
   AvgSeqRespTime FLOAT,
   MaxSeqRespTime FLOAT,
   AvgLogicalIO FLOAT,
   MaxLogicalIO FLOAT,
   AvgLogicalKBs FLOAT,
   MaxLogicalKBs FLOAT,
   AvgPhysicalIO FLOAT,
   MaxPhysicalIO FLOAT,
   AvgPhysicalKBs FLOAT,
   MaxPhysicalKBs FLOAT,
   ThrottleBypass INTEGER
  )
          .
          .
          .
;

The TDWMSummary function provides similar functionality to a TDWM Summary request. For more information about this interface, “TDWM SUMMARY” on page 374.

TDWMSummary returns information for all queries completed in the dashboard interval for the WD.

 

Column Name

Description

WDId

WD ID.

Arrivals

Number of queries that were classified into this WD by the Teradata dynamic workload management software.

Completions

Number of queries that completed in this WD in this dashboard or logging interval with:

  • No error code or an error code of 3158
  • No abort flag
  • Either an AMP count of > 0 or a Parser CPU > 0
  • MinRespTime

    Minimum response time in centiseconds of any query.

    MaxRespTime

    Maximum response time in centiseconds of any query.

    AvgRespTime

    Average response time in centiseconds for this workload based on the total response time of all completions divided by number of completions.

    MinCPUTime

    Minimum CPU in milliseconds of all the queries that completed in this workload in this dashboard or logging interval, where CPU is the minimum CPU used by any one AMP of the query plus the Parser CPU time used by that same query.

    MaxCPUTime

    Maximum CPU in milliseconds of all the queries that completed in this workload in this dashboard or logging interval, where CPU is the maximum CPU used by any one AMP of the query plus the Parser CPU time used by that same query.

    AvgCPUTime

    Running total in milliseconds of Parser CPU time plus the total AMP CPU of each query that completed in this workload divided by the number of completions of queries in this workload in this dashboard or logging interval.

    DelayedCnt

    Number of queries that are delayed in this workload.

    AvgDelayTime

    Average delay time in centiseconds of all the queries that are delayed in this workload.

    ExceptionCnt

    Number of queries with exceptions in this workload.

    MetSLGCnt

    Number of queries that met WD Response Time SLG requirements.

    Note: If the WD does not have Response Time SLG requirement, the query is still counted as met.

    ActiveQueryCnt

    Number of active queries in this workload.

    ActiveDelayCnt

    Number of queries currently delayed in this workload.

    ErrorCnt

    Number of queries that finished in this WD in this dashboard or logging interval with an error code > 0 but not 3158 or 3156.

    AbortCnt

    Number of queries that finished in this WD in this dashboard or logging interval with an error code of 0 or 3156 and an abort flag.

    VirtualPartNum

    Virtual Partition number of the WD.

    AvgIOWaitTime

    Average duration of sleeps in milliseconds due to the I/O rate handling over the life of all requests completing in this WD during this interval.

    MaxIOWaitTime

    Maximum duration of sleeps in milliseconds due to the I/O rate handling of a request completing in this WD during this interval.

    AvgOtherWaitTime

    Note: This column is reserved for future use.

    MaxOtherWaitTime

    Note: This column is reserved for future use.

    AvgCPURunDelay

    Average wait time in milliseconds in the run queue of all the requests completing in this WD during this interval.

    MaxCPURunDelay

    Maximum wait time in milliseconds in the run queue of a request completing in this WD during this interval.

    AvgSeqRespTime

    Average of the sum of the response times of the steps (as if all the steps had been executed sequentially) of all the requests completing in this WD during this interval, in milliseconds.

    MaxSeqRespTime

    Maximum sum of the response times of the steps (as if all steps had been executed sequentially) of a request completing in this WD during this interval, in milliseconds

    AvgLogicalIO

    Average count of logical I/Os for a request completing in this WD during this interval.

    MaxLogicalIO

    Maximum count of logical I/Os for a request completing in this WD during this interval.

    AvgLogicalKBs

    Average logical I/O usage in KB of all requests completing in this WD during this interval.

    MaxLogicalKBs

    Maximum logical I/O usage in KB for a request completing in this WD during this interval.

    AvgPhysicalIO

    Average count of physical I/Os of all requests completing in this WD during this interval.

    MaxPhysicalIO

    Maximum physical I/O usage of all requests completing in this WD during this interval.

    AvgPhysicalKBs

    Average physical I/O usage in KB of all requests completing in this WD during this interval.

    MaxPhysicalKBs

    Maximum physical I/O usage in KB for a request completing in this WD during this interval.

    ThrottleBypass

    The number of queries reported in the Completions column that were allowed to run due to the ThrottleBypass ruleset attribute.

    SELECT WDId, Arrivals, MetSLGCnt, ActiveReqs FROM TABLE (TDWM.TDWMSummary()) AS t2 
     WHERE arrivals <>0;
     
     *** Query completed. 13 rows found. 4 columns returned.
     *** Total elapsed time was 1 second.
     
           WDId     Arrivals    MetSLGCnt   ActiveReqs
    -----------  -----------  -----------  -----------
            213            8            8            0
            217            1            0            0
            221            3            3            0
            240          109           91            1