15.10 - Input Format Examples - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

The input forms of the macros are described below.

EXEC ResPsByNode
(FromDate,ToDate,FromTime,ToTime,FromNode,ToNode);

EXEC ResPsByGroup
(FromDate,ToDate,FromTime,ToTime);

See Macro Execution for a description of the FromDate, ToDate, FromTime, ToTime, FromNode, ToNode, and Node parameters.

Coexistence support can be accomplished using the NodeType column to do a group by in SQL directly. Therefore, the GroupId column is not needed and the ResUsageSps table view is not provided.