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


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.


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: 28 Jun 2020