Re: IDS/BaaN performance issues

Russ - keep in mind I can barely spell BaaN, but SAP has gotten bit hard by 7.30 releases prior to 7.30.UC7XK. There's a bug in the new buffer management that eventually leaves you all but unable to keep a data page in memory, producing low buffer hit ratios like you have. The XK release essentially turns it off, reverting to the 7.2x style. Your BUFFERS probably do need to be higher, but as long as you have this bug, it won't help. Actually, it will probably hurt. And UC5 was particularly bad - there were customers who switched within (2) days to another release looking for relief. Greg russ_kahler@andersonsinc.com wrote: > Greetings, > > We are running IDS version 7.30.uc5 on a 4-way HP 9000 K-250 with 2.25 > GB of memory, and HP-UX 10.20. We are also a BaaN installation running > b40c4 with about 20 production users, and 25 test users. > > We have been experiencing performance difficulties with BaaN, and I have > modified our onconfig to try to adjust for this. I recently added memory > to bring it up to 2.25 GB, and also adjusted the SHMVIRTSIZE,BUFFERS,and > CLEANERS to try and make better use of the added memory. What I saw > however in onstat -p was a decline in both read cache % and write cache > %. Are buffers still an issue here? > > Also, where I do an onstat -g glo, it seems as if the virtual processors > are not balancing the loads between them, as one processor seems to be > doing 2X the work of the other two. I am able to confirm this by running > glance- as the oninit processes are using only 20 -40% of the CPU, while > the rest sit idle. Informix technical support says this is normal, but > that just doesn't seem right. > > Thanks for any help you can give. Here is the info: > > onstat -p :> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:20:53 -- > 421160 K > bytes > > Profile > dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached > 7536503 12194535 78503378 90.40 111959 163941 661937 83.09 > > isamtot open start read write rewrite delete commit > rollbk > 36612289 443031 1916363 29251116 68550 113615 19749 51768 > 0 > > gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs > 0 0 0 0 0 0 0 > > ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes > 0 0 0 6499.98 1867.23 69 344 > > bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans > 526588 0 30721288 0 0 15 8138 13609 > > ixda-RA idx-RA da-RA RA-pgsused lchwaits > 4436892 11 1311 4423770 3720 > > onstat -g glo> > Informix Dynamic Server Version 7.30.UC5 -- On-Line -- Up 14:22:21 -- > 421160 K > bytes > >