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 ResUsageSvpr table, one row is written to the database for each type of vproc on each node in the system, summarizing the vprocs of that type on that node, for each log interval.

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.