Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.