Archives of the TeradataForum
Message Posted: Thu, 06 May 2004 @ 19:44:27 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|