ADSM-L

Re: Informix ONBAR logical logs

1999-01-28 12:48:13
Subject: Re: Informix ONBAR logical logs
From: Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
Date: Thu, 28 Jan 1999 09:48:13 -0800
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/
>