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 ResUsageSldv table, the following rows are written to the database for each node in the system for each log interval:
  • One row summarizes the system logical devices
  • One row summarizes Vantage logical devices

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.