17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

AllGlobalSpaceV returns the space limits for a given database or user at the system level. It returns the databases and tables along with the actual current space usage and maximum permissible space usage. The difference between this view and the corresponding AllSpaceV[X] is that this view returns global level information on space usages while AllSpaceV[X] provides space usage information at the AMP level.

You can use the DBC.ClearPeakDisk macro to reset PeakPerm, PeakSpool, PeakPersistentSpool, and PeakTemp.

AppProxyUser and TrustUserName

These columns are not returned in the X or VX views.