17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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.