Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 01 Jan 2002 @ 12:33:14 GMT

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

Subj:   Re: Max Spool Usage
From:   Dennis Calkins


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

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.

  <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: 28 Jun 2020