Re: 7.23 UC4 vs. 7.30 UC3

In article <wrhfygmlfr.fsf@tglobe3.tollpost.no>, 'yvind Gjerstad <ogj@tglobe3.tollpost.no> writes >icc@injersey.com writes: > >> I've talked to an Informix software engineer today, who has been assigned to >> our problem since we've become a squeeky wheel. She indicated that in 7.30 if >> there is a thread problem then the thread will be pulled down and *not* the >> engine. Also, she indicates that more detailed diagnostic information will be >> available. >> >> QUESTION: does this sound bogus? > >I don't know. > >> Also, Oyvind, we have experienced the wrong query path being selected by the >> optimizer is 7.x for some time. We understand that 7.30 allows the user (us) >> to control the query optimizer more directly. > >Yes, we have used this feature to verify that the optimizer chose the >wrong query path. The cost was _much_, _much_ lower when we suggested the >correct index. However this is something I would hesitate to use in a >production environment. It is extremly painful to maintain. > >> Also, have you submitted the af >> files from the two 7.30 panics you has to Informix, and if so, what did you >> say about them? One more thing. > >Alas, we did not have enough free space on /var/tmp. I think you can alter the directory used by Informix for af files etc. in the variable 'DUMPDIR'. <snip> -- Surfer! http://www.nevis-vieww.demon.co.uk http://www.nevis-vieww.demon.co.uk/flash Hopeful anti-spam: alter double 'w' to single 'w' to view site & send Email.