Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Currentspool for DBC?
 
From:   Rudel Simard

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016