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


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: 23 Jun 2019