General Macro Input Format | Resource Usage Macros/Tables | Teradata Vantage - 17.05 - General Macro Input Format - 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
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