Archives of the TeradataForum

Message Posted: Fri, 23 Nov 2001 @ 15:59:15 GMT

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

Hi everyone,

I look to the currentspool by user to determine the way the spoll are use on my system. I'm using the DBC.ALLSPACE view. I'm suprising to see the logon DBC with 22 gig. of currentspool. This currentspool always growing up and don't seem to decrease. I look with taradata manager but i couldn't see the logon DBC.

Does anybody have a idea of what is this currentspace?

Thank's

SELECT DATABASENAME,
       SUM(CURRENTSPOOL)
FROM DBC.ALLSPACE
WHERE CURRENTSPOOL > 0
GROUP BY 1;

DatabaseName            Sum(CurrentSpool)
X8948                           28 516 864
L7299                           891 392
U2118                           7 656 960
DCLS1                           10 411 008
DBC                             22 266 668 032
L8011                           1 536
U2896                           54 406 656

Rudel Simard
R�gie de l'assurance-maladie du Qu�bec
DBA de l'environnement informationnel

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