Archives of the TeradataForum

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

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

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