Kevin As this is AIX (and only on AIX please - as it has it's own memory flush) - set UVSYNC=0 in uvconfig and run "uvregen" (Universe stopped please....)
This stops UniVerse doing its own sync.... There is a small risk with this but not much. Please do *not* change SYNCALLOC. FSEMNUM and GSEMNUM look fine (assuming this was under load). UVTEMP could do with relocating off root onto another volume - ideally on a SAN. I am sure you know that RAID 5 costs disk throughput (parity disk writes - but this is a business call - just be aware). There are a lot of processes in CLR.OM.LOCK - what does this do and is it intensive? Looking at SELECTs in use - we don't see the file sizes information etc - but check out the following: SELECT UNPOSTED.MRE WITH TEMP.LOC EQ "BS2" BY BIN.SORT BY PROD SSELECT CATALOG.DETAIL BY-DSND DATE.TO (seen 3x) SSELECT INVENTORY WITH 67 = "PETSAFE" (seen 2x) SSELECT MAIL.MSG BY-DSND CREATE.DATE BY-DSND CREATE.TIME SSELECT ADJ.CODES SSELECT SMTP WITH 6 EQ "" SSELECT IMPORT.ORDERS Are these SELECTs performed a lot and are the files large? - if so look at indexes and watch the use of NO.NULLS where appropriate. Also watch that you do *not* build index on DICT itmes which translate to data out of the primary file (things like DATE() or a file translate). I have ignored a couple of SELECTS with SAMPLE statements. Would be interested in sar output for file opens - hopefully you are caching these file handles in COMMON (ideally named) - also the run queue (how many CPUs? - the run queue should not (other than very occasionally) exceed more than 2x the number of CPUs on the system (or in the LPAR if you use these). By "heavily utilized disk space" do you mean you use lots of disk ? - if so - and it seems disproportionate to yout data volumes - then are you using lots of dynamic files and if so have you tuned the file split/merge ratios?. Final points - I am sort-of-assuming that MFILES is appropriately set..................? (see "PORT.STATUS ...... MFILE.HIST"). You might also want to check out FILE.USAGE. Email me off-line if you want to go through any reports you already have on this - let's see what was and what was not covered (saves retreading old ground). Regards JayJay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 08 April 2004 20:18 To: 'U2 Users Discussion List' Subject: RE: Performance Thanks for all of the posts...here are some of our 'knowns'... 1.) Application files have all been analyzed and sized correctly. 2.) IBM U2 support analyzed Universe files, locking, swap space and all have been adjusted accordingly or were 'ok'. 3.) We are running RAID 5, with 8G allocated for Universe 4.) We are already running nmon, which is how we identified the paging faults and high disk I/O 4.) Attached you will find the following: smat -s LIST.READU EVERY PORT.STATUS Uvconfig Nmon (verbose and disk) Vmtune I know this is a lot of data, but it is a mix of what each of you have suggested. Thanks again for all of the help. Kevin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: Thursday, April 08, 2004 12:08 PM To: [EMAIL PROTECTED] Subject: Performance We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
