|
Archives of the TeradataForumMessage Posted: Tue, 01 Jan 2002 @ 12:33:14 GMT
Hi, Could I suggest a CRON job every 10 minutes running SHOWSPACE from ferret? Then you could record the totals in a file. something like.... #! /bin/csh cnsrun -utility ferret -commands \ '{output over /tmp/ferret.out} {showspace} {quit}' set line = "`grep "Totals" /tmp/ferret.out` " set perm = `echo $line | cut -d'|' -f2 | awk 'print $2' set free = `echo $line | cut -d'|' -f3 | awk 'print $2'` set temp = `echo $line | cut -d'|' -f4 | awk 'print $2'` # set bad = `echo $line | cut -d'|' -f5 | awk 'print $2'` set spool = `echo $line | cut -d'|' -f6 | awk 'print $2'` /usr/ucb/echo "`date`\t$perm\t$free\t$temp\t$spool" >>! /home/dc1/spaces I haven't verified the field numbers for CUT and AWK but the idea is sound. (I ignore BAD because it is always '0'. ) Maybe you want to run it every 5 minutes. I guess if you wanted you could make a PERL script out of it and interface directly to a FERRET running in Application window 1 Permanently so we don't have to start ferret every 5 minutes. Then you can just cut -f1,5 /home/dc1/spaces | sort +1nr | head 10 to see the top 10 amount of SPOOL cylinders in use on your system.
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||