17.05 - Summary Mode - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
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 Teradata Database 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.