EXECUTE MACRO Syntax Elements - 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™
MacroNameMultiNode
Name of a multinode resource usage macro:
  • ResAwtByNode
  • ResCPUByAMP
  • ResCPUByPE
  • ResCPUByNode
  • ResLdvByNode
  • ResMemMgmtByNode
  • ResNetByNode
  • ResNodeByNode
  • ResPdskByNode
  • ResPsByNode
  • ResVdskByNode
FromDate
Start date to report resource usage data.
The date may be entered either as a character string (for example, character format for May 31, 2007 would appear as '2007-05-31') or as a numeric value (for the same date in numeric format, 1070531). The character string is the recommended format. The default is the current system date.
For more information on using numeric dates with macros, see Teradata Vantage™ - Data Types and Literals, B035-1143.
The character string date format is changed from yymmdd to 'yyyy-mm-dd' to accommodate dates in the 21st century.
ToDate
End date to report resource usage data.
See the FromDate syntax element column for a further explanation of date formats.
The character string is the recommended format.
FromTime
Start time to report resource usage data. The format is hhmmss. The default is 000000.
ToTime
End time to report resource usage data. The format is hhmmss. The default is 999999.
FromNode
Starting range of nodes to report resource usage data. The format is 'nnn-nn'. A hyphen must be included in the fourth character position. The default is '000-00'.
To identify the node ID numbers for your system, type get config in the DBW Supervisor Window (Supvr).
ToNode
Ending range of nodes to report resource usage data. The format is 'nnn-nn'. A hyphen must be included in the fourth character position. The default is '999-99'.
To identify the node ID numbers for your system, type get config in the DBW Supervisor Window (Supvr).
MacroNameAllNode
Name of an all-node resource usage macro:
  • ResNode
  • ResHostByLink
The ResHostByLink and ResNode macros do not use the FromNode and ToNode parameters.
MacroNameOneNode
Single-node ID to report resource usage data. The format is 'nnn-nn', and hyphen must be included in the forth character position. For example,1-01 should be typed out as '001-01'. The default is '001-01'.
MacroNameByGroup
Name of a ByGroup resource usage macro:
  • ResAmpCpuByGroup
  • ResCPUByGroup
  • ResHostByGroup
  • ResLdvByGroup
  • ResMemByGroup
  • ResNetByGroup
  • ResNodeByGroup
  • ResPeCpuByGroup
  • ResPdskByGroup
  • ResPsByGroup
  • ResVdskByGroup