Long transaction

Gordon wrote: >Hi Erwin, > >It depends on whether the logs were filled due to a long transaction >that spanned all logs, or you just have not backed up your logs. >In the second case all you need to do is go to screen and back up the >logs. In the first case it basically restore from archive. If anyone >out there knows a another way to recover from a long transaction that >fills log I would love to hear from you. Gordon, 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)