Archives of the TeradataForum

Message Posted: Tue, 16 Jan 2002 @ 04:13:17 GMT

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

Hi,

I have updated my script to do this a cronjob. Change the directory name to suit your system. Make sure there aren't any spaces after the

\

or the line continuation of the script won't work.

#! /bin/csh

    cnsrun -utility ferret -commands \
        '{output over /tmp/ferret.out} {showspace} {quit}'

    set line = "`grep "TOTAL" /tmp/ferret.out` "

    set perm = `echo $line | cut -d'|' -f2`
    set spool = `echo $line | cut -d'|' -f3`
    set temp = `echo $line | cut -d'|' -f4`
    set jrnl  = `echo $line | cut -d'|' -f5`
#    set bad  = `echo $line | cut -d'|' -f6`
    set free = `echo $line | cut -d'|' -f7`

  /usr/bin/echo "`date`\t$perm\t$spool\t$temp\t$jrnl\t$free"  \
            >>!  /home/dc1/spaces

Then you can just

cut -f1,3 /home/dc1/spaces | sort +6nr | head -10

to see the top 10 amount of SPOOL cylinders in use on your system.

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