CPU VPs & logical buffer util. & read ahead util.

Hi All, Hoping someone can give me some pointers regarding my config. Thanks in advance. HP K460 4 CPUS 4Gb Memory 2 instances of Informix OnLine 2 Baan instances 150+ users connecting via 6 client servers (HP K460s) All Baan connections are made via socket connections. We have specified 2 CPU VPs for each instance. Looking at the distribution of CPU time on the onstat -g sch we appear to have one very heavily used VP and one doing very little. Is this a problem, if so what might we change. We also appear to have a problem with the logical buffer utilisation. We are getting an alarm when we run oncockpit that says the utilisation is too low (0.501738). We are also being warned that the read ahead utilisation is too low (0.968807). Any thoughts? ***************************** Instance 1 ***************************** onstat -g sch INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:06:21 -- 850912 Kbytes VP Scheduler Statistics: vp pid class semops busy waits spins/wait 1 1982 cpu 96 97 999 2 1988 adm 0 0 0 3 1998 cpu 51104875 51205087 999 4 1999 lio 559726 0 0 5 2000 pio 33426 0 0 6 2001 aio 6836076 0 0 7 2002 msc 896607 0 0 8 2003 aio 5394246 0 0 9 2004 aio 4157791 0 0 10 2005 aio 3115697 0 0 11 2006 aio 2412099 0 0 12 2007 aio 1859708 0 0 13 2009 soc 5293 8130 694 14 2010 soc 95425 98109 977 onstat -l INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:21:19 -- 850912 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-2 14 32 1031550 33484 30.81 phybegin physize phypos phyused %used 200035 100000 46855 334 0.33 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 32 12077359 1307676 560441 9.2 2.3 address number flags uniqid begin size used %used c264a6f8 1 U-B---- 12942 6092b1 7500 7500 100.00 c264a714 2 U-B---- 12943 60affd 7500 7500 100.00 c264a730 3 U-B---- 12944 60cd49 7500 7500 100.00 c264a74c 4 U---C-L 12945 60ea95 7500 2183 29.11 c264a768 5 U-B---- 12923 6107e1 7500 7500 100.00 c264a784 6 U-B---- 12924 61252d 7500 7500 100.00 c264a7a0 7 U-B---- 12925 600035 7500 7500 100.00 c264a7bc 8 U-B---- 12926 601d81 7500 7500 100.00 c264a7d8 9 U-B---- 12927 603acd 7500 7500 100.00 c264a7f4 10 U-B---- 12928 605819 7500 7500 100.00 c264a810 11 U-B---- 12929 607565 7500 7500 100.00 c264a82c 12 U-B---- 12930 614279 7500 7500 100.00 c264a848 13 U-B---- 12931 615fc5 7500 7500 100.00 c264a864 14 U-B---- 12932 617d11 7500 7500 100.00 c264a880 15 U-B---- 12933 619a5d 7500 7500 100.00 c264a89c 16 U-B---- 12934 61b7a9 7500 7500 100.00 c264a8b8 17 U-B---- 12935 61d4f5 7500 7500 100.00 c264a8d4 18 U-B---- 12936 61f241 7500 7500 100.00 c264a8f0 19 U-B---- 12937 620f8d 7500 7500 100.00 c264a90c 20 U-B---- 12938 622cd9 7500 7500 100.00 c264a928 21 U-B---- 12939 624a25 7500 7500 100.00 c264a944 22 U-B---- 12940 626771 7500 7500 100.00 c264a960 23 U-B---- 12941 6284bd 7500 7500 100.00 onstat -p INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:26:31 -- 850912 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 37056827 115658597 2633455761 0.00 3056065 11662651 16090532 81.01 isamtot open start read write rewrite delete commit rollbk 2346291403 11426660 58408675 1997322899 2298825 969683 849798 607009 214 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 213302.89 96810.26 3069 7856 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 3016676 291 438330561 0 0 1471 176184 441240 ixda-RA idx-RA da-RA RA-pgsused lchwaits 6732412 13959 5342825 11741409 656552 INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:06:28 -- 850912 Kbytes Configuration File: /usr/informix/etc/bbrlgld1 #************************************************************************** # # INFORMIX SOFTWARE, INC. # # Title: onconfig.std # Description: INFORMIX-OnLine Configuration Parameters # #************************************************************************** # Root Dbspace Configuration ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/raw_links/baanroot0 # Path for device containing root dbspace ROOTOFFSET 0 # Offset of root dbspace into device (Kbytes) ROOTSIZE 200000 # 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 plogdbs # Location (dbspace) of physical log PHYSFILE 200000 # Physical log file size (Kbytes) # Logical Log Configuration LOGFILES 23 # Number of logical log files LOGSIZE 15000 # Logical log size (Kbytes) # Diagnostics MSGPATH /usr/informix/logs/online.log # System message log file path CONSOLE /dev/console # System console message path ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path # System Archive Tape Device TAPEDEV /dev/rmt/2m # Tape device path TAPEBLK 128 # Tape block size (Kbytes) TAPESIZE 20000000 # Maximum amount of data to put on tape (Kbytes) # Log Archive Tape Device LTAPEDEV /dev/rmt/0m # Log tape device path LTAPEBLK 128 # Log tape block size (Kbytes) LTAPESIZE 4000000 # Max amount of data to put on log tape (Kbytes) # Optical STAGEBLOB ,1 # INFORMIX-OnLine/Optical staging area # System Configuration SERVERNUM 0 # Unique id corresponding to a OnLineinstance DBSERVERNAME bbrlgld1 # Name of defaul

In article <938074971.13201.0.nnrp-07.c1ed6ac3@news.demon.co.uk>, Fergus Hayne <fhayne@brand-rex.com> writes >Hi All, > >Hoping someone can give me some pointers regarding my config. > >Thanks in advance. > >HP K460 >4 CPUS >4Gb Memory >2 instances of Informix OnLine >2 Baan instances >150+ users connecting via 6 client servers (HP K460s) >All Baan connections are made via socket connections. > >We have specified 2 CPU VPs for each instance. Looking at the distribution >of CPU time on the onstat -g sch we appear to have one very heavily used VP >and one doing very little. > >Is this a problem, if so what might we change. > >We also appear to have a problem with the logical buffer utilisation. We >are getting an alarm when we run oncockpit that says the utilisation is too >low (0.501738). > >We are also being warned that the read ahead utilisation is too low >(0.968807). Any thoughts? > >***************************** >Instance 1 >***************************** > >onstat -g sch> >INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:06:21 -- >850912 Kbytes > >VP Scheduler Statistics: > > vp pid class semops busy waits spins/wait > 1 1982 cpu 96 97 999 > 2 1988 adm 0 0 0 > 3 1998 cpu 51104875 51205087 999 > 4 1999 lio 559726 0 0 > 5 2000 pio 33426 0 0 > 6 2001 aio 6836076 0 0 > 7 2002 msc 896607 0 0 > 8 2003 aio 5394246 0 0 > 9 2004 aio 4157791 0 0 > 10 2005 aio 3115697 0 0 > 11 2006 aio 2412099 0 0 > 12 2007 aio 1859708 0 0 > 13 2009 soc 5293 8130 694 > 14 2010 soc 95425 98109 977 > >onstat -l> >INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:21:19 -- >850912 Kbytes > >Physical Logging >Buffer bufused bufsize numpages numwrits pages/io > P-2 14 32 1031550 33484 30.81 > phybegin physize phypos phyused %used > 200035 100000 46855 334 0.33 > >Logical Logging >Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io > L-3 0 32 12077359 1307676 560441 9.2 2.3 > >address number flags uniqid begin size used %used >c264a6f8 1 U-B---- 12942 6092b1 7500 7500 100.00 >c264a714 2 U-B---- 12943 60affd 7500 7500 100.00 >c264a730 3 U-B---- 12944 60cd49 7500 7500 100.00 >c264a74c 4 U---C-L 12945 60ea95 7500 2183 29.11 >c264a768 5 U-B---- 12923 6107e1 7500 7500 100.00 >c264a784 6 U-B---- 12924 61252d 7500 7500 100.00 >c264a7a0 7 U-B---- 12925 600035 7500 7500 100.00 >c264a7bc 8 U-B---- 12926 601d81 7500 7500 100.00 >c264a7d8 9 U-B---- 12927 603acd 7500 7500 100.00 >c264a7f4 10 U-B---- 12928 605819 7500 7500 100.00 >c264a810 11 U-B---- 12929 607565 7500 7500 100.00 >c264a82c 12 U-B---- 12930 614279 7500 7500 100.00 >c264a848 13 U-B---- 12931 615fc5 7500 7500 100.00 >c264a864 14 U-B---- 12932 617d11 7500 7500 100.00 >c264a880 15 U-B---- 12933 619a5d 7500 7500 100.00 >c264a89c 16 U-B---- 12934 61b7a9 7500 7500 100.00 >c264a8b8 17 U-B---- 12935 61d4f5 7500 7500 100.00 >c264a8d4 18 U-B---- 12936 61f241 7500 7500 100.00 >c264a8f0 19 U-B---- 12937 620f8d 7500 7500 100.00 >c264a90c 20 U-B---- 12938 622cd9 7500 7500 100.00 >c264a928 21 U-B---- 12939 624a25 7500 7500 100.00 >c264a944 22 U-B---- 12940 626771 7500 7500 100.00 >c264a960 23 U-B---- 12941 6284bd 7500 7500 100.00 > >onstat -p> >INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:26:31 -- >850912 Kbytes > >Profile >dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached >37056827 115658597 2633455761 0.00 3056065 11662651 16090532 81.01 > >isamtot open start read write rewrite delete commit >rollbk >2346291403 11426660 58408675 1997322899 2298825 969683 849798 607009 >214 > >ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes >0 0 0 213302.89 96810.26 3069 7856 > >bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans >3016676 291 438330561 0 0 1471 176184 441240 > >ixda-RA idx-RA da-RA RA-pgsused lchwaits >6732412 13959 5342825 11741409 656552 > > > >INFORMIX-OnLine Version 7.22.UC3 -- On-Line -- Up 13 days 13:06:28 -- >850912 Kbytes > >Configuration File: /usr/informix/etc/bbrlgld1 >#************************************************************************** ># ># INFORMIX SOFTWARE, INC. ># ># Title: onconfig.std ># Description: INFORMIX-OnLine Configuration Parameters ># >#************************************************************************** > ># Root Dbspace Configuration > >ROOTNAME rootdbs # Root dbspace name >ROOTPATH /dev/raw_links/baanroot0> # Path for device containing root dbspace >ROOTOFFSET 0 # Offset of root dbspace into device >(Kbytes) >ROOTSIZE 200000 # 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 plogdbs # Location (dbspace) of physical log >PHYSFILE 200000 # Physical log file size (Kbytes)> ># Logical Log Configuration > >LOGFILES 23 # Number of logical log files >LOGSIZE 15000 # Logical log size (Kbytes)> ># Diagnostics > >MSGPATH /usr/informix/logs/online.log # System message log file path >CONSOLE /dev/console # System console message path >ALARMPROGRAM /usr/informix/etc/log_full.sh # Alarm program path> ># System Archive Tape Device > >TAPEDEV /dev/rmt/2m # Tape device path >TAPEBLK 128 # Tape block size (Kbytes) >TAPESIZE 20000000 # Maximum amount of data to put on tape >(Kbytes)> ># Log Archive Tape Device > >LTAPEDEV /dev/rmt/0m # Log tape device path >LTAPEBLK 128 # Log tape block size (Kbytes) >LTAPESIZE 4000000 # Max amount of data to put on lo