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.

     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