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
#!/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/