Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 19:44:27 GMT

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

It looks like you have a case of either leftover spool or bogus spool.

Leftover spool is a spool file that was not dropped after its last use (as it should have been). The only way to get rid of it is to restart the system.

Bogus spool is caused by corruption of DBC.DatabaseSpace. (There is really no spool used, but some rows in DBC.DatabaseSpace say there is.) This can be fixed by running updatespace (see the Utilities manual). The command would be:

update spool space for <username>;

You might want to open an incident with the GSC. Leftover spool is rather hard to track down. You have to find the request that's leaving spool behind.

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