Archives of the TeradataForum
Message Posted: Wed, 30 Jun 2004 @ 12:12:37 GMT
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.
You could write a BTEQ Script to insert this information into another table and schedule this to run on a daily basis.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|