Re: 7.23 UC4 vs. 7.30 UC3

In article <gO2d5HAJ1k+1Ew5a@nevis-view.demon.co.uk>, Surfer <surfer@nevis-vieww.demon.co.uk> wrote: > 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. > Surfer dude is right on. We've embellished this: a process (started by cron) polls DUMPDIR looking for af files. If one is found the on call person is automatically beeped, the shm file is removed and the af file is moved to an archive (so that beeping does not continue). The shm file is generally not used for analysis, and as they build up in DUMPDIR they prevent future af files from being written when the file system becomes full. It is important to preserve those af files if we gonna do something about these problems! -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum