Re: Long transaction

Posted in 1995

Michel Behna — Mon, 1 May 1995 13:03:31 — source: Informix-list mailing list archive (1991-1998)

In article <3nqf0h$srl@dingo.cc.uq.oz.au> gordonh@acslink.net.au (Gordon Hooker) writes: >From: gordonh@acslink.net.au (Gordon Hooker) >Subject: Re: Long transaction >Date: Fri, 28 Apr 1995 09:03:50 GMT >Jason wrote >>There is a way. There is a utility that Informix has called tbzero. What >>this will do is basically commit your long transaction and free up the >>logical logs. You then have to decide what you want to do about the >>transaction that has just been committed but you are still online and there >>is no need to restore from archive. Usually I just delete the data that >>was being inserted and start again on a smaller set of data. >>I dont know if this utility is generally available. A few of the sites I have >>worked at have had it but I did not ask how they got it. >>Jason Harris (RSWA) >Thanks Jason, >Can anyone out there tell me where I can get this thing called tbzero, >as a post sales support guy. This would help me no end. >gordonh@acslink.net.au >RIPLEY, Queensland, Australia You cannot get tbzero except from Informix directly and they don't give it out usually. It's an internally developed tool and proprietary.