Maximum Teradata data base size

UDA

Maximum Teradata data base size

Hi,
what is the maximum TD DB size for single node or SMP and what is the maximum TD DB size in production currently
By vedamurthy
1 REPLY
N/A

Re: Maximum Teradata data base size

Try it!!!!!

SELECT
SUM ((((MaxPerm) / 1024) /1024) / 1024) AS Maximum_Space ,
SUM ((((CurrentPerm) / 1024) /1024) / 1024) AS Current_Space_Used,
Max ((((MaxSpool) / 1024) /1024) / 1024) AS Max_Spool,
((Current_Space_Used + Max_Spool) / NULLIFZERO (Maximum_Space) * 100 )
(FORMAT 'zz9.99 %' , TITLE 'Percent // Used') AS Percent_Used
FROM DBC.diskspace ;
;