Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

When a database or table is created, the allocated disk space is divided evenly among all AMPs. The TableSize view returns one row of usage information for each AMP in the system (or for all AMPs if the SUM aggregate is used).

Corresponding Tables

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles

CurrentPerm

CurrentPerm returns the permanent space (in bytes) currently used by the database or table. The CurrentPerm column value includes all AMPs unless a specific AMP is requested.

PeakPerm

Use the DBC.ClearPeakDisk macro to reset the PeakPerm column.