Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Jun 2004 @ 12:12:37 GMT


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


Subj:   Re: How do I calculate Spool Usage
 
From:   Coffing Christopher L

This becomes a simple process to capture User SpoolSpace on a Daily Basis...

To Capture User SpoolSpace Information.

     select
     DatabaseName as "Database Name",
     sum(maxSPOOL) as "Max SPOOL",
     sum(peakSPOOL) as "Peak SPOOL"
     from dbc.diskspace
     where maxSPOOL > 0
     Group By 1
     order by 3 desc;

Once you have captured the PeakSpool you need to exec the Macro DBC.ClearPeakDisk. This resets DBC.DiskSpace.Peak(Perm, Spool and Temp) columns to 0.

     Exec dbc.ClearPeakSpool;

You could write a BTEQ Script to insert this information into another table and schedule this to run on a daily basis.


Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master



     
  <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