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