Performance problems in SAP R/3 with informix 7.3

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

Christian: Check your onconfig OPTCOMPIND, it should be 0. Rgds Christian Kondo 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

Can you, please send us your ONCONFIG and onstat -p, -P, -F, -l outputs ? We need some more information. ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > 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

Christian Kondo schrieb: > > 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. Hi Christian, We are also having major performance problems since we are using 7.30. Our Database has 120GB, about 300 Users are working in our 40B System. The hardware is a SNI RM600-E30 (8CPU,8GB). First we had the well known problems concerning the buffer management (OSS Note 167846) But even after grading up to 7.30UC7XK and setting all parameters listed in OSS Notes (e.g. 175700) the performance remains poor. In our development system performance is still worse, but the hardware is 80% idle! A second productive system (50GB / 31H) has similar problems, only the HR-System (12GB / 31H) is running fine. If you get any solution to your Problem, please post it here or send me a mail. Thanks! Markus Reiter R/3 Basisbetreuung Océ Printing Systems

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 > How are you updating statistics on the table? -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.