Re: Informix issues -- ouch!

Unlike your situation we had no upgrades. All upgrades (if you can call them) were essentially patches, bug fixes to the application. We had similar assert failures about a month ago. We gave the tech support people all the outputs they requested. Came down to the issue of indexes. We were missing an index. Technically would boil down to a slow processing issue. I have never seen informix engine come down that frequently. May be you might want to check the indexes related to the SQL that you have posted on another thread. We are also on a freeze and could not upgrade to a full tech support release until Jan 15. We had to convince the users for the index build. Platform HP UX 10.20. Informix Universal Server 9.13 UC3 Hope this helps Thanks Ram S In article <383329F6.8C7CB5C7@bellsouth.net>, "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > IDS 7.30.uc10 > HPUX 10.20 > > Just upgraded (over the weekend) to 7.30.uc10. One of my users ran a > very basic report, and brought the Informix down. The system ended up > with six assert failures within a four hour period. Called the down > system group; they've analyzing the situation. I ended up regressing to > 7.30.uc7. > > I reinstalled uc10 on my test system and cut my production data over. > Since then I've been able to either hang the engine up or crash it using > the same report. BTW, this report ran well under uc7. > > Are there any outstanding issues with uc10? Are there any gotchas that > I may have missed? (It's the first time I've had to regress to an older > version . . . hence the 'ouch'.) > > Thanks in advance! > > John Carlson > Informix DBA > WHSmith USA > Sent via Deja.com http://www.deja.com/ Before you buy.