Re: to many logical logs: cannot restart database

> -- > on informix online v5.05.uc2, > when I try to restart the database in quiescent mode, the database is in > recovery mode and stop. It seems there is too many logical logs. > Previously, a process has last very long and was killed (kill -9) > How can I erase these logs ?? > > please send me the answer by mail fred@toplog.fr, thanks > ------------------------------------------------------------------------------ > Fred BON - Top Log Technologies > Mail: fred@toplog.fr - URL:<http://www.toplog.fr>; > ------------------------------------------------------------------------------ Hi Fred 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 have to perform the transaction ,but the transaction causes a long transaction , try removing the logging from the database (you first have to perform a level 0 archive) . Excute the transaction and then restore the logging. You could also increase the number of logical logs but this requires the database to be reinitialized and restored before you can execute the transaction. I hope this helps you. Cheers Paul ---- Paul Schreuder Electromatic (Pty) Ltd TEL (0331) 425945 Fax (0331) 425947 email : ematic@iafrica.com