EXECUTE MACRO Syntax | Resource Usage Macros/Tables | Teradata Vantage - 17.05 - EXECUTE MACRO Syntax - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

The execution of each resource usage macro has the following form.

{ EXECUTE | EXEC } {

  MacroNameMultiNode (
    [ FromDate ] , [ ToDate ] ,
    [ FromTime ] , [ ToTime ] ,
    [ FromNode ] , [ ToNode ]
  ) |

  MacroNameAllNode (
    [ FromDate ] , [ ToDate ] ,
    [ FromTime ] , [ ToTime ]
  ) |

  MacroNameOneNode (
    [ FromDate ] , [ ToDate ] ,
    [ FromTime ] , [ ToTime ] ,
    [ Node ]
  ) |

  MacroNameByGroup (
    [ FromDate ] , [ ToDate ] ,
    [ FromTime ] , [ ToTime ]
  )
}

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