General Macro Input Format | Resource Usage Macros/Tables | Teradata Vantage - General Macro Input Format - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
As shown in the table below, there are four kinds of macros:
  • Multiple-node
  • One-node
  • All-node
  • ByGroup

For any given line in the following table, the macros on that line report the same statistics for either multiple nodes, one node, all nodes, or group nodes as indicated.

Description Multinode Macro One-Node Macro All-Node Macro ByGroup Macro
AWTs in use by node ResAWTByAMP ResAWTByNode   ResAWT  
CPU usage by AMP Vprocs ResCPUByAMP ResCPUByAMPOneNode   ResAmpCpuByGroup
CPU usage by PE Vprocs ResCPUByPE ResCPUByPEOneNode   ResPeCpuByGroup
CPU usage by nodes ResCPUByNode ResCPUOneNode   ResCpuByGroup
Host statistics   ResHostOneNode ResHostByLink ResHostByGroup
Ldv disk statistics ResLdvByNode ResLdvOneNode   ResLdvByGroup
Memory management ResMemMgmtByNode ResMemMgmtOneNode   ResMemByGroup
General network statistics ResNetByNode ResNetOneNode   ResNetByGroup
General node-level statistics ResNodeByNode ResOneNode ResNode ResNodeByGroup
pdisk level I/O statistics ResPdskByNode ResPdskOneNode   ResPdskByGroup
Priority Scheduler and TASM Workload statistics ResPsByNode     ResPsByGroup
AMP level I/O statistics ResVdskByNode ResVdskOneNode   ResVdskByGroup