Archives of the TeradataForum

Message Posted: Thu, 09 Nov 2006 @ 12:54:01 GMT

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

I seem to be having a weird situation. Queries that normally used to run fine now complain of an out of spool space error. Further investigation discovered that the spool space on 1 of the 30 vprocs has is 50% utilized irrelevant of whether I am running a query or not. It doesnt matter if I log off or on. The currentspool for vproc 1 in the dbc.diskspace for my user shows up as 50% utilized always. This is effectively cutting my total spool space in half and preventing running of queries. Any ideas or utilities that can be used to reclaim this frozen spool?

Haris

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