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ā„¢

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.