RE: Performance problems in SAP R/3 with informix 7.3

Well that is quite a story. I'm of the opinion that too many people spend too much time worrying about how long update stats or oncheck takes. Your worries should be more along the lines of what is the performance of the application. But that's just my personal gripes. Back your the problem. Are you using dostats? If not what are you using. Creating your own update stats scripts can have obvious pitfalls. A very large table at 250Gb I presume would be fragmented across many dbspaces. Is this correct ? Is it possible to post the spec of your hardware and a copy of your $ONCONFIG. In general posting your $ONCONFIG tends to get you a few pointers to general performance guidelines. A copy of onstat -p will allow us to judge the performance of your box from an Informix point of view. So we need onstat -p $INFORMIXDIR/etc/$ONCONFIGHardware spec OS info Ta Jo > In article <81euff$lc8$1@news.xmission.com>, > "Christian Kondo" <christian_hk@hotmail.com> wrote: > > Ok Obnoxio, > > Let me tell you my case, > I was very happy with 7.24.uc3 version and I didn't know it ... > My database has almost 250Gb, and my main problem was one > table (ausp) > with > > 25Gb. When I run update statistics in this table, it > becames to use a > wrong > index, can you imagine it ? > There are almost 500 users in this system. > The decision was to do an upgrade to 7.30.UC7.XB (release from SAP), > after > this many queries are very sloooowwww. So, next decision, other > upgrade to > 7.30.UC7.XK. The oncheck -cd (in single user) before XK > took 12 hours > and > now 32 hours ! We tried to change memory parameters, but it didn't > solve the > entire problem... The consultants SAP are in system right > now, but ... > I'd want to know if somebody had any performance problem with 7.3x > with SAP > and if had any solution. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________