Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 16:50:23 GMT

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

Hi Sravan,

Please run the below query. It will give you the total space on the system.

     select sum(maxperm)/1024/1024/1024  as  MAXallocated ,
            sum(currentperm)/1024/1024/1024  as CurrentOccupied,
            (MAXallocated-CurrentOccupied) free,
            (((CurrentOccupied)/nullifzero(MAXallocated))*100) used_per
     from dbc.diskspace

Thanks,

Mahesh

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