Re: DSA 7.12 Performance Problems

Keith Howard wrote: > We too, had many problems with 7.12 on an HP-K410. We had MANY > Assert Failures and after Informix Support wanted us to help them debug > the failures on our production system which we were not inclined to do. > We switched back to 7.11 and all was well. We have just upgraded to > 7.13 without any problems so far. The difficulties with 7.12 began > almost > immediately and would fail several times daily. The new 7.13 has > been in > production on 4 boxes for about 2 weeks and hasn't failed yet (knock on > wood). > IMHO, it's worth waiting until 7.13 has been ported to your > environment. > After several days of painfully slow response times with DSA 7.12 we finally discovered (with wonderful help from Tech Support) that we are hitting bug #49459 which causes the optimizer to pick a sequential scan regardless of OPTCOMPIND settings, or what permutation of update statistics is run. Tech support noted that this bug is not fixed until 7.14 or 7.2 for our platform. So back to 7.11 we go...... :-( -Dave -- ) \\ / ( /|\\ )\\_/( /|\\ / | \\ (/\\|/\\) / | \\ / | \\ \\`|'/ / | \\ /___|___o_____\\|/_____o___|___\\ __________________/_| '|^ V ^|` |_\\__________________ \\ Internet: | David A. Buchholz | / \\ datacop@cfer.com | Database Administrator | Standard / > Voice: | ConferTech International | Disclaimers < / (303) 633-3089 |___________________________| Apply \\ /_____________________)/ \\\\ V // \\ (_____________________\\ | / V )) (( V \\ | |/ // \\\\ \\| V V