15.10 - General Macro Input Format - 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

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