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:
|
MacroNameAllNode | Name of an all-node resource usage macro:
The ResHostByLink and ResNode macros do not use the FromNode and ToNode parameters. |
MacroNameByGroup | Name of a ByGroup resource usage macro:
|
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'. |