Re: Informix and isolation modes

mserafino@ameritrade.com wrote: > > We have an application that runs with the isolation set to committed read. > Sometimes the application locks up when we enter dbaccess and do selects > against a table the application uses. This is very infrequent but can > occur even when we set our isolation mode to dirty read while in dbaccess. > > Are their any Informix Guru's who can restore :-) my faith in Informix by > helping with the following questions? > > 1) Have you ever heard of anything like this before? > 2) Do readers affect writers in Informix??? (yuck) > 3) What are we doing wrong? > > 4) If the answers to 1,2,3 are yes, yes, and nothing then is SQL Server > any good or is it just a toy? :-) > > thanks for the help! > Mike Serafino > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet What I have been told is dbaccess (OnLine 7.2) has a bug that will prevent it from logging out. Hence it will not release the resource. I bet your problem does not occur during the first dbaccess after booting up your server. I was also told that Informix is aware of the problem and has a bug number. Sorry, I don't know the bug number. Chao Y. Din