Re: 7.3 and statistics problems on AIX

In article <35FFFB56.14EB9AC7@ix.netcom.com>, Mickey Mestel <mickm@ix.netcom.com> writes >hi, > > interesting situation at a customer site. bring the engine up, run >update statistics and things run pretty good. within a couple of days,>performance decreases further and further, until the only answer they ^^^^^^^^^^^ >have found so far is to bounce the engine and run update stats again. ^^^^^^^^^^^^^^^^^^^^^^^ > > the only thing that seems to keep them up and going is to run update >stats low on all the tables, having dropped distribuitions from the >previous runs. sounds odd, but it is the best they can do so far. i am >a little lacking on other info as i haven't been in there yet, but that >is what i have so far. sounds pretty strange, and informix hasn't been >much help to them so far. > > anyone seen anything similar? i'd like to gather as much info as >possible before i go in. > Check that NOAGE=1 in your ONCONFIG file!! > thanks, > > mickm -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care