Archives of the TeradataForum

Message Posted: Wed, 06 Dec 2006 @ 18:28:37 GMT

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

Actually you can look at currentspool by vproc for a user while the query is running. I usually run:

     select vproc, currentspool, peakspool, maxspool
     from dbc.allspace
     where databasename = ''
         and tablename = 'all'
     order by 2 desc;

Of course once the query is finished or fails you lose currentspool, but while it is running you can see if it is "hot amping". Also, I would look at the profile for the user if you are using profiles (as was stated in an earlier response). The profile spool space overrides the users spool space, that is why we don't use spool space in the profile we do it at the user level, also to keep run away queries from happening.

Kevin R Tewksbury
Sr. Database Administrator
LimitedBrands
Limited Technology Services

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