17.05 - Input Format for ByGroup Macros - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

Advanced SQL Engine
Teradata Database
June 2020
User Guide

ByGroup macro versions are used on systems with co-existing nodes. In Teradata Database, co-existing nodes are nodes of different model types in the same configurations. Because of the differences, the nodes may become bottlenecks in the throughput of the system as a whole. Therefore, ByGroup macros were developed to provide the system user with a summary of the performance data based on node groupings.

The Database Administrator must identify the groupings of nodes when the system is first configured.

ByGroup macros are similar to the other macros. The only difference is that they use the GroupId column of the views to report system usage for a specific set of nodes grouped by a GroupId. The input format of the ByGroup macros is the same as the other macros except ByGroup appears as the qualifier in the macro name.

For an example of a ByGroup macro, see ResCPUByAMP Macros Output.