16.20 - Usage Notes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata Database (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.