Re: Long transaction

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