Summary Mode in Resource Usage Tables | Teradata Vantage - Summary Mode in Resource Usage Tables - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
Product Category
Teradata Vantage™

Summary Mode combines data from the multiple data rows normally generated into one or more rows. When multiple rows are condensed into a single row, the data is combined using the rules in the following table.

For the following Mode … Summary fields are combined by…
Count summing the values from all the contributing rows.
For example, the ResUsageSawt.FlowCtlCnt field provides the total number of times that the system entered flow control state from a non-flow control state.
  • In normal mode, the values are reported per AMP.
  • In Summary Mode, the value needs to be divided by the number of AMPs if you wish to determine the average number per AMP rather than the total.
Max taking the maximum value from all the contributing rows.

In Summary Mode, the reported value for a Max field such as ResUsageSpdsk.ConcurrentWriteMax is the maximum value from all the rows that are combined into a single summary row.

Min taking the minimum value from all the contributing rows.

In Summary Mode, the reported value for a Min field, such as AvailableMin is the minimum value from all the rows that are combined into a single summary row.

Track summing the values from all the contributing rows.

In Summary Mode, the Track values from each row to be combined are summed together. For example, ResUsageSawt.FlowControlled is a track field so that in Summary Mode, all the AMP vproc rows are combined into a single row and the FlowControlled field will report the summed value from each of the AMP vproc rows.

Summary Mode is applicable to all tables except ResUsageSpma and ResUsageSps. If the information for a row of a table is in Summary Mode, the SummaryFlag value is set to 'S'. If the row is being logged normally, the SummaryFlag value is set to 'N'.