EXECUTE MACRO Syntax Elements - 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
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
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