Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Max Spool Usage
From:   Dennis Calkins


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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020