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

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