Archives of the TeradataForum

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

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

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
having SUM(CURRENTSPOOL) > 0

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>>