#!/usr/local/bin/perl5 # -*- mode: Perl -*- ################################################################## # Remove old data from OV_DB files ################################################################## # Created by Laurie Gellatly # This reads an OV_DB file for the cut off and interface # and calculates how many lines can be removed ################################################################# # # Distributed under the GNU copyleft # # $Id: ovcullfile,v 1.1.1.1 2002/02/26 10:16:36 oetiker Exp $ # use strict; use vars '$DEBUG'; my $ov_db = "/var/opt/OV/share/databases"; my $ovdb= $ov_db."/snmpCollect/"; my $DEBUG = 0; my($days2keep, $interface, $io , $cutoff) ; my($cnt, $data, $recno, $junk); my @names = ( "IfInErrors", "IfOutErrors", "IfInOctets", "IfOutOctets", "avgBusy5"); my @namext = (".err", "", ".cpu"); my ($val); my $recsz = 24; my $fsize = -1; my $p = "',\$p'"; my $parms = '-F\\t \'{printf("%d\\t%d\\t%s\\t%lg\\n", $4, $5, $6, $3)}\''; my @resu; sub main { my($extn) = ""; $days2keep = $ARGV[0]; $interface = $ARGV[1]; $io = $ARGV[2]; die < -1; if (($fsize == $cfsize) && ($recno > 1)){ seek(RAWIN,($recno - 2) * $recsz, 0); $notfound = ($recsz == read(RAWIN, $data, $recsz)); ($starttime, $entime, $IPAdd1, $IPAdd2, $IPAdd3, $IPAdd4, $cnt, $val) = unpack("LLCCCCLd",$data); if ($cutoff < $entime) { seek(RAWIN, 0, 0); $recno = 1; } } else { $fsize = $cfsize; $recno = 1; } while ($notfound){ # Read from the beginning of file $notfound = ($recsz == read(RAWIN, $data, $recsz)); ($starttime, $entime, $IPAdd1, $IPAdd2, $IPAdd3, $IPAdd4, $cnt, $val) = unpack("LLCCCCLd",$data); if ($cutoff < $entime) { $notfound = 0; } else { $recno++; } } close (RAWIN); if ($recno > 1){ @resu = `snmpColDump -tTI $file | sed -n $recno$p | awk $parms | snmpColDump -r - $file` # wc -l` } return ($recno); }