Re: Logging error: Assert failed !!!

To mee it looks more like a problem with the logs than a problem with runing out of locks. May be it's the dreaded long transaction problem. Douglas Wilson <dougw@amgen.com> wrote: :Matteo Prinetti wrote: :> :> I'm plagued with following problem: :> :> (DEC OSF 3.2A , Informix 7.1.2UC1 Online Dynamic Server) :> :> I have 200.000 locks defined. When i try a transcation that :> takes all the locks (example: delete from x - x contains :> more than 200.000 records) the db shut down and cannot :> recover anymore (olnly using the tbzero utility i can :> restore the db). :> Matteo Prinetti :Can you lock the table?: :LOCK TABLE tbl_name IN EXCLUSIVE MODE :although when I have run out of system locks, the program crashed :more gracefully than you've described and did not bring down the :system. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org