Physical Table Naming Conventions - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

Each physical table name follows this general naming convention:

ResUsage Information_type Table_name

Information_type
  • S = system-wide information
  • I = internal SQL Engine information
Table_name
  • awt = AMP worker task statistics
  • cpu = CPU-specific information
  • hst = mainframe and workstation host information
  • ldv = logical device statistics
  • mhm = reserved for future use
  • pma = node information
  • pdsk = pdisk device statistics
  • ps = WD resolution statistics
  • vdsk = vdisk device statistics
  • vpr = vproc information