Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 12:26:04 GMT


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


Subj:   Re: How do I calculate Spool Usage
 
From:   Sangra, Chander

Hi Siva,

Use DBC.DiskSpace views but as far as date-wise report is concerned, I don't think there is any system view/table available on this.

# Alternative to this is:

Collect the peakspool information with current date in some table and clear the Peak values using "ClearPeakDisk" macro on daily basis (either manually or through some automated job).


Regards

Chander Sangra



     
  <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: 15 Jun 2023