Re: Arcane bits

> > > Speaking of arcane bits, for all Informix 4.1 users out there, be very > > careful about exceeding the LOCKS setting in tbconfig. All hell breaks > > loose when you. > > > > Moral: > > Bump up your LOCKS setting to the largest practical number you can. > > (see your local dealer for further information.) > > This sounds much more likely to have been due to filling the current > logical logs than using all the locks. Don't get me wrong it could > also be a problem with locks but in testing here we normally have our > lock value set artificially low so as to trap any programs which are > not locking correctly and we dont get this problem even if we do > use all our locks. Oh, no, it was the indeed the lock table overflowing. We can tell that from looking at the Online logs, and spending many hours on the phone with Informix. After running out of locks, it tried to rollback, but since rollback needs locks, it barfed. And in turn, managed to destroy live production data. It would have made sense to immediately take Online to quiescent when this type of failure occurs. It has been discussed, any may be added as a parameter in tbconfig (whether or not you should go to quiescent when this occurs). > -- Naomi Walker (aka N7FSA) Anasazi Inc. Phoenix, Arizona 602-395-1731 anasaz!qip.naomi@asuvax.eas.asu.edu