TDWM SUMMARY Request | Application Programming Reference | Teradata Vantage - TDWM SUMMARY - Advanced SQL Engine - Teradata Database

Purpose

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

Input Data

Monitor Privileges

To use this request, you must have the ABORTSESSION and MONSESSION privileges as part of your default role or both privileges must be granted directly to you.

Usage Notes

There is one record per WD active in the system. The record contains counts of the number of queries that were classified into the WD in the collection period and the number of queries that completed in the collection period along with query statistics.

The TDWM Summary request returns information for all queries completed in the dashboard interval for the WDs.

If TASM Workloads are not enabled, only the first statement is returned.

CLIv2 Response Parcels

The TDWM SUMMARY request is treated internally as a two statement request, with each statement generating a response. The two statement response returned from the database contains the following sequence of parcel types:

Response

Statement 1

The response to the first statement results in a Record parcel containing the SampleSec field.

Statement 2

The response to the second statement results in a Record parcel that consists of summary information for an active WD in the system collected in the last collection period. There is one record for each WD.

The following table describes the format of the Summary Data Record parcel.

Sample Input - CLIv2 Request

The following example shows how the parcels for a TDWM SUMMARY request, built by CLIv2, appear when sent to the database server.

Sample Input - Teradata JDBC Driver Request

For an example of how the PM/API request, built in Java, appears when sent to the database server, see Teradata JDBC Driver Reference, available at https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/frameset.html .

Sample Output

The following example shows the data returned by the TDWM SUMMARY request. Your application program may return this data in a different format or display.

The TDWM SUMMARY request reports WD statistics over a given period. As shown in this example of WD activity returned from the API call, queries are classified into WDs 1 and 3 and not WDs 2, 4, and 5.

SUCCESS parcel:
StatementNo=1,    ActivityCount=1,
ActivityType=156, FieldCount=1
TDWM Summary Request successful.
         Sample Seconds: 120
SUCCESS parcel:
StatementNo=2,    ActivityCount=5,
ActivityType=156, FieldCount=43
TDWM Summary - # of WDIds: 5
  WLC   Arrivals  Complete  WereDlyd  Exceptns  Met SLG  CurrActv  CurrDlyd  Abt Cnt   Othr Cnt
   ID   Min Resp  Max Resp  Avg Resp  Min CPU   Max CPU   Avg CPU  AvgDelay  Err Cnt
        Collection Date/Time
-----   --------  --------  --------  --------  --------  --------  --------  --------  --------
   12          0         0         0         0         0         1         0
    0          0
             0.0       0.0       0.0       0.0       0.0       0.0       0.0
    0
         2011/06/15 18:33:49.00
   13          0         0         0         0         0         0         0
    0          0
             0.0       0.0       0.0       0.0       0.0       0.0       0.0
    0
         2011/06/15 18:33:49.00
   14          0         0         0         0         0         0         0
    0          0
             0.0       0.0       0.0       0.0       0.0       0.0       0.0
    0
         2011/06/15 18:33:49.00
   15          0         0         0         0         0         0         0
    0          0
             0.0       0.0       0.0       0.0       0.0       0.0       0.0
    0
         2011/06/15 18:33:49.00
   16          0         0         0         0         0         0         0
    0          0
             0.0       0.0       0.0       0.0       0.0       0.0       0.0
    0
         2011/06/15 18:33:49.00