Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2001 @ 12:53:38 GMT

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

Subj:   Re: Number of ACTIVE users
From:   Ruth Fenwick

I'm getting even stranger results...

Any one ever heard of an id having currentspool and NOT BEING signed on? Also, how is it possible to have currentspool and no peakspool? I run the ClearPeakDisk macro nightly

I ran the following:

select count(*)
from ( select databasename, sum(currentspool)
from dbc.diskspace
group by 1
having SUM(CURRENTSPOOL) > 0) t9(c1,c2);

select databasename, sum(currentspool) , sum(peakspool)
from dbc.diskspace group by 1

Users that are not signed on have currentspool values with zero peakspool (which I expect since one user I looked at hasn't signed on in over a week)

Do I have a bug that currentspool isn't being cleared out. Or an I missing something?

Ruth Fenwick
IA&DSS Team Leader
Information Resource Management
Hudson's Bay Company

  <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