Physical Table Naming Conventions - Analytics Database - Teradata Vantage

Resource Usage Macros and Tables

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
efj1628112349534.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
wqp1472240716284
lifecycle
latest
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 Analytics Database 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
  • resusagesmhm is reserved for future.
  • resusagelpma and resusagelvpr are only used by Teradata personnel.