Re: IDS/BaaN performance issues

Hi , Working at a site running b3 & c3 with two informix instance on the same machine K460 , 4 Pro , 4G Mem. Running under Baan IV c4 you can use the Informix multiplexing entry which can be put in your sqlhosts file. I am not sure what versions of informix cover this. Best to ask informix /Baan. Hope you are running update statistics medium on a regular basis. With the C4 you are using a level 2 driver which I think allows you to use Informix Indexes as aposed to the level 1 driver which added columns called hash1... to hashn on tables. Again ask Baan for more Info on the level 2 driver. Documentation is very rare. Also best check your fragmentation depending on how many companies you have and how long you have been running. Can use following sql in sysmaster DB:- select tabname, trunc( sum(size) * 2 , 0) Total from sysextents where tabname matches "*<companynumber>" group by 1 having count(*) > 4 order by 2 desc ; If this takes too long just unload sysextents table into file and create table , with same columns as , in baan db in a specfic DB space not root with an extent size set. You can then create composite index on tabname,size which should speed up info coming back. This gives you all the tables for a specific company which have more than four extents and well as the size of tables in Kbytes. Hope this is help full. Need and more Info Let me know. Please also note the queries that Fergus Hayne or my self Pankaj Patel have put on this user group. The answers by all the users have been of benefit as well as helping to performance tune your system. Cheers Pankaj russ_kahler@andersonsinc.com wrote in message <7sqhpl$642$1@nnrp1.deja.com>... >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 > >MT global info: >sessions threads vps lngspins >62 95 10 0 > > sched calls thread switches yield 0 yield n yield >forever >total: 30482118 28283418 2493985 135177 13918422 >per sec: 0 0 0 0 0 > >Virtual processor summary: > class vps usercpu syscpu total > cpu 3 6612.03 1857.59 8469.62 > aio 3 2.15 7.43 9.58 > lio 1 0.76 2.22 2.98 > pio 1 0.71 2.48 3.19 > adm 1 4.06 9.73 13.79 > msc 1 1.58 0.50 2.08 > total 10 6621.29 1879.95 8501.24 > >Individual virtual processors: > vp pid class usercpu syscpu total > 1 2511 cpu 1023.73 410.28 1434.01 > 2 2512 adm 4.06 9.73 13.79 > 3 2513 cpu 3803.59 1070.54 4874.13 > 4 2514 cpu 1784.71 376.77 2161.48 > 5 2515 lio 0.76 2.22 2.98 > 6 2516 pio 0.71 2.48 3.19 > 7 2517 aio 0.79 2.68 3.47 > 8 2518 msc 1.58 0.50 2.08 > 9 2519 aio 0.69 2.57 3.26 > 10 2520 aio 0.67 2.18 2.85 > tot 6621.29 1879.95 8501.24 > >onconfig file > > ># Root Dbspace Configuration > >ROOTNAME rootdbs # Root dbspace name>ROOTPATH /dev/informix/baan/rootdbs > # Path for device containing root >dbspace >ROOTOFFSET 0 # Offset of root dbspace into device >(Kbytes) >ROOTSIZE 500000 # Size of root dbspace (Kbytes)> ># Disk Mirroring Configuration Parameters > >MIRROR 0 # Mirroring flag (Yes = 1, No = 0) >MIRRORPATH # Path for device containing mirrored>root >MIRROROFFSET 0 # Offset into mirrored device (Kbytes)> ># Physical Log Configuration > >PHYSDBS rootdbs # Location (dbspace) of physical log >PHYSFILE 200000 # Physical log file size (Kbytes)> ># Logical Log Configuration > >LOGFILES 30 # Number of logical log files >LOGSIZE 1000 # Logical log size (Kbytes)> ># Diagnostics > >MSGPATH /informix/logs/online_prod.log # System message log file >path >CONSOLE /informix/logs/console_prod.log # System console message >path >ALARMPROGRAM /informix/etc/no_log.sh # Alarm program path >#ALARMPROGRAM /informix/etc/log_full.sh # Alarm program path > ># System Archive Tape Device > >TAPEDEV /dev/rmt/3m # Tape device path >TAPEBLK 2048 # Tape block size (Kbytes) >TAPESIZE 20000000 # Maximum amount of data to put on tape >(Kbytes)> ># Log Archive Tape Device > >LTAPEDEV /dev/rmt/1m # Log tape device path>#LTAPEDEV /dev/null # Log tape device path >LTAPEBLK 2048 # Log tape block size (Kbytes) >LTAPESIZE 4000000 # Max amount