Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Spool Usage without Session
From:   Christie, Jon

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019