ADSM-L

Re: Informix ONBAR logical logs

1999-01-28 19:12:19
Subject: Re: Informix ONBAR logical logs
From: "Jackson, Sandye" <Sandye.Jackson AT LATIMES DOT COM>
Date: Thu, 28 Jan 1999 16:12:19 -0800
ME TOO!

   Sandye J. Jackson
     sandye.jackson AT latimes DOT com
         Information Technology
     213/237-2132, fax 213/2374500
  Are we having fun yet?

> -----Original Message-----
> From: Joel Fuhrman [SMTP:joelf AT CAC.WASHINGTON DOT EDU]
> Sent: Thursday, January 28, 1999 9:48 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Informix ONBAR logical logs
>
> Please send me a copy. Thanks.
>
> On Wed, 27 Jan 1999, Christoph Martin wrote:
>
> > Triggered from the last message on this topic ( We have the same
> > problems with the logs filling up out ADSM storage ) I finally sat
> > down this night and wrote a small program using the ADSM XOpen API to
> > expire Informix logfiles.
> >
> > I have a working version now, but it needs some more testing. You
> > would execute it somewhat like this:
> >
> >   expire <Filespace> <Path>
> >
> > eg.:
> >
> >   expire /snoopy_online /snoopy_online/40/50
> >
> > In this example /snoopy_online is the name of the informix instance,
> > 40 is the instance number and 50 is the number of the logical log.
> >
> >   show versions snoopy /snoopy_online /snoopy_online/40/50
> >
> > reported that the file is now inactive.
> >
> > There is still some work needed to remove the logentries from the
> > Informix system tables.
> >
> > If people are interested, I can share the code with them.
> >
> > Christoph
> >
> > --
> >
> ==========================================================================
> ==
> > Christoph Martin, Uni-Mainz, Germany
> >  Internet-Mail:  Christoph.Martin AT Uni-Mainz DOT DE
> > --------------export-a-crypto-system-sig
> -RSA-3-lines-PERL------------------
> > #!/usr/bin/perl -sp0777i<X+d*lMLa^*lN%0]dsXx++lMlN/dsM0<j]dsj
> > $/=unpack('H*',$_);$_=`echo 16dio\U$k"SK$/SM$n\EsN0p[lN*1
> > lK[d2%Sa2/d0$^Ixp"|dc`;s/\W//g;$_=pack('H*',/((..)*)$/)
> > #what's this? see http://www.dcs.ex.ac.uk/~aba/rsa/
> >