16.20 - Example: Using AllSpaceV - 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

The following SELECT statement displays how the space currently used by the data table named Department is distributed on each AMP:

SELECT DatabaseName,TableName,AMP,CurrentPerm FROM DBC.AllSpaceV
WHERE TableName=’Department’ ORDER BY 1,2,3 ;

Result:

DatabaseName    TableName       AMP        CurrentPerm
------------    ----------      ----       ------------  
Test            DEPARTMENT      1-0        1,024
Test            DEPARTMENT      1-1          512
Test            DEPARTMENT      1-2        1,024
Test            DEPARTMENT      1-3          512
PERSONNEL       department      1-0        2,048
PERSONNEL       department      1-1        1,536
PERSONNEL       department      1-2        1,536
PERSONNEL       department      1-3        1,536
User1           department      1-0        2,048
User1           department      1-1        1,536
User1           department      1-2        1,536
User1           department      1-3        1,536