Archives of the TeradataForum

Message Posted: Thu, 09 Nov 2006 @ 16:45:39 GMT

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

There is a knowledge article about this. You can run UPDATESPACE utility and reset the spool accounting numbers for the user to clear up the problem.

Here is a simple query to detect spool bytes for a user that is not currently logged-on.

     locking row for access
     select databasename, sum(currentspool) as spoolbytes
     from dbc.diskspace ds
          left outer join dbc.sessioninfo s
             on ds.databasename = s.username
     where s.username is null
     group by 1
     having spoolbytes > 0;

Kyle Prescott
UnumProvident, IODS

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