Summary Mode - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantage™

When Summary Mode is active for the ResUsageSawt table, one row is written to the database for each node in the system for each log interval. The AMP Worker Task data will be combined for all the AMP vprocs on the node.

You can determine if a row is in Summary Mode by checking the SummaryFlag column for that row.

IF the SummaryFlag column value is… THEN the data for that row is being logged…
'S' in Summary Mode.
'N' normally.