Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 14 Sep 2001 @ 15:58:29 GMT


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


Subj:   Re: Number of ACTIVE users
 
From:   Thomas F. Stanek

Ruth,

We are incurring a similar situation at the client I am currently at. The problem you are seeing sounds like a Teradata DBMS problem we discovered. Specifically, we are seeing some number of user ids that show SUM(CURRENTSPOOL) values greater than zero even though the IDs are not logged on. The good news is that this is an "accounting" issue and not a space issue. In other words, it is only a cleanup problem with Teradata. The spool is not really in use. This can be verified by using the FILER utility.

The problem can be corrected (at least temporarily) by resetting the currentspool for any users not logged on, similar to the ClearPeakDisk process.

Hope this helps.


Regards,

Thomas F. Stanek
TFS Consulting



     
  <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: 27 Dec 2016