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
Not applicable

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 ;
;