Archives of the TeradataForum

Message Posted: Wed, 19 Apr 2006 @ 19:21:12 GMT

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

<-- Anonymously Posted: Wednesday, April 19, 2006 12:34 -->

Try the following:

     Select databasename, sum(maxspool) as assigned_spool
     >From dbc.diskspace
     Where databasename=''
     Group by 1
     ;

Afterward to see what was used -

     Select databasename, sum(peakspool) as max_spool_used
     >From dbc.diskspace
     Where databasename=''
     Group by 1
     ;

You won't see any difference if your current spool usage did not exceed the peak last used. If the peak value was never reset by your DBA then you won't see anything different until you exceed the peak value used.

Hope this helps...

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