15.10 - EXECUTE MACRO Syntax - 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 execution of each resource usage macro has the following form. For information on interpreting the syntax diagrams, see Syntax Diagram Conventions.

where:

Syntax element Description
MacroNameMultiNode Name of a multinode resource usage macro:
  • ResAwtByNode
  • ResCPUByAMP
  • ResCPUByPE
  • ResCPUByNode
  • ResLdvByNode
  • ResMemMgmtByNode
  • ResNetByNode
  • ResNodeByNode
  • ResPdskByNode
  • ResPsByNode
  • ResVdskByNode
MacroNameAllNode Name of an all-node resource usage macro:
  • ResNode
  • ResHostByLink

The ResHostByLink and ResNode macros do not use the FromNode and ToNode parameters.

MacroNameByGroup Name of a ByGroup resource usage macro:
  • ResAmpCpuByGroup
  • ResCPUByGroup
  • ResHostByGroup
  • ResLdvByGroup
  • ResMemByGroup
  • ResNetByGroup
  • ResNodeByGroup
  • ResPeCpuByGroup
  • ResPdskByGroup
  • ResPsByGroup
  • ResVdskByGroup
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 SQL Data Types and Literals.

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).
Node 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'.