Archives of the TeradataForum

Message Posted: Mon, 16 Nov 2015 @ 14:32:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Below query can help you to find the total allocated space and consumed space and free space by database level.

     select databasename,
       sum(maxperm)  totperm,
       sum(currentperm) totused,
       sum(maxperm) - sum(currentperm) available  from dbc.diskspace  group by databasename
     having totperm > 10.0  order by 1;

James

	<Prev	Next>		<<First	<Prev	Next>	Last>>