Re: to many logical logs: cannot restart database

: I have a similar problem where one transaction results in a long transaction : situation where one transactions spans all the logs. Once this occured the only : way to recover is to restore from backup. (Hopefully resent) If you ask Informix nicely, they can re-set the Physical logs for you with a utility. Depends how long your tapes take to restore. Make a case, and they will usually dial in if you get stuck.