Database size, used space and free space in a Teradata database

Purpose : find space used by Teradata database:

Solution:

SELECT 
DATABASENAME,
CAST(SUM(MAXPERM)/(1024*1024*1024) AS DECIMAL(7,2)) MAX_PERM,
CAST(SUM(CURRENTPERM)/(1024*1024*1024) AS DECIMAL(7,2)) CURRENT_PERM,
CAST(SUM(MAXSPOOL)/(1024*1024*1024) AS DECIMAL(7,2)) MAX_SPOOL,
CAST(SUM(CURRENTSPOOL)/(1024*1024*1024) AS DECIMAL(7,2)) CURRENT_SPOOL 
FROM 
DBC.DISKSPACE 
WHERE DATABASENAME = 'YOURDATABASE' 
GROUP BY 
DATABASENAME ORDER BY MAX_PERM DESC;

victor

posted on 26 Jul 18