Re: Is Informix v7.23 good?

We upgraded from 6.0 to 7.23. Compared to the 6.0 release I'd say it is more unstable. The first problem we had, was an assertion failure, when a certain select wasissued. The synonyms to a view in a different database seems to confuse the optimizer and the instance panics. Setting OPTCOMPIND to 0 solved the problem. The second problem we have, is that one of our instances refuses to accept net calls and fills the message log with 'can't allocate call structure'. Restarting the engine solves the problem. We're just checking, if this problem is connected with the tunable kernel parameters. Performance is another matter. If you don't update statistics regularly, the performance is bad, if you do it's really fast. Concluding, I'd like to add, that there are no major constraints for updating to 7.23. All problems can be solved or worked around. Regards, Roland schung@edd.ca.gov schrieb: > We want to check with the "real world" users of Informix before moving > to > v7.23. Since v7.23 is fairly new, we are not sure if the version is > stable. We do not want to add any unnecessary risk to our system. > For > any of you out there who have implemented v7.23, > > 1. Any problems you encountered with v7.23? > 2. Has the performance changed? > 3. Anything particular we should know about v7.23? > >