Hi Dan, I happened to read an old post of yours. I am in need of some help in performance analysis of UV database running on AIX and tuning it. Can you please help me?
G Dan Fitzgerald wrote: > > > Look at nmon; I run it from cron, then email it to myself after midnight. > I also have bunches of scripts that run - some every 5 seconds, to notify > me if, say, paging space usage on any system exceeds 30%, file systems > exceed 85% full, passwords change, sudo is invoked, hosts, hosts.equiv, > cron, etc., changes. > > One useful thing to look at is vmstat -v | grep block. If you see the > values there changing over time, you'll need to do some tweaking. This is > part of the nmon output, so you can track it over time easily, if you use > nmon. Manually, try it an hour apart. if no changes, try 24 hours. keep > the output around, and when you're experiencing a heavy load, look again. > It resets to zero at boot, so big numbers mean something has happened in > the past (or you haven't rebooted in far too long). > > I have Mark's Hitchhiker's guide series (backed up in 6 or 7 places), but > I'd need his permission to send 'em. Mark? I know that when U2 was IBM, > whether or not Mark got to publish such over-the-top useful articles > depended on how many people downloaded them. Reading and understanding > even a few sentences any of Mark's articles makes you an instant SME, and > guarantees that your capability to add value is enhanced. If you come > across them, download them, and ask Rocket for more. More. MORE! With the > exception of Clif Oliver and possibly one or two others, Mark is like Hank > Williams in Leonard Cohen's "Tower of Song" - a hundred floors above us. > > Two other authors I've found useful you may want to search on are Ken > Milberg & Jaqui Lynch; both deal with AIX tuning. Be sure to be looking at > AIX 5.3; there were some major changes to AIX tuning between 5.1 & 5.3, > and some of those changes are a 180 degree change (for example, maxperm, > maxclient, and lru_file_repage). > > You can find a lot of the new settings in /etc/tunables/lastboot. > > I've found the truss command to be amazingly helpful, but you have to have > some understanding of system calls & error messages in order to interpret > it. It captures all of the system calls made by a process (the -f option > follows all of the forks, as well). Even without knowing what each system > call does, you can see if it's hanging, looping, waiting, etc. > > svmon is a good tool; svmon -U will tell you more than you want to know > about each user's memory map. > > FILE.USAGE is a very powerful tool in UV. It has some impact on > performance if you run it for a lot of files. > > Having specialized in tuning U2 on AIX for a while, I have a few docs (How > to look at topas, tuning with ioo, vmo) that I need to update & cleanup, > and perhaps submit to Spectrum. > > Obviously, FAST (no relation) is an excellent tool. > > <AD/> I occasionally moonlight remotely, and as I mentioned, tuning UV on > AIX is my specialty niche. I bring a program that exports ANALYSE.FILE > data & runs some analytics into an .xls file, from which we can target > your most poorly sized hashed files, in addition to 20 years in U2 & 15+ > years in AIX. Usually, with the tools and knowledge transfer I leave > behind, you won't feel the need for outside help again.</AD> > >> From: stuart.boyd...@spotless.com.au >> To: u2-users@listserver.u2ug.org >> Date: Thu, 20 Jan 2011 16:03:36 -0800 >> Subject: [U2] [UV][AIX] System Management and Performance Tools >> >> Hi, >> Just wondering if anyone has any recommendations for systems >> monitoring/management tools for aix5.3/uv10.2.4. I've seen occasional >> discussions on the topic here over the years. >> Ideally, what we would like to do is be able to track down those end of >> month type processes which bog the system down with CPU & IO bottlenecks >> during peak load periods. >> I suppose this could be done with something like topas, truss and >> PORT.STATUS but just wondering what is available. >> There was a tool called "DPMonitor" that looked like it could be suitable >> - does this exist in any form? >> Also, does anyone know if the "Travels with Mark: A Hitchhiker's Guide to >> the >> UniVerse<http://www.google.com/url?sa=t&source=web&cd=1&sqi=2&ved=0CBIQFjAA&url=http%3A%2F%2Fwww.mail-archive.com%2Fu2-users%40listserver.u2ug.org%2Fmsg13400.html&rct=j&q=dm-dw-dm-0512baldridge-i&ei=jMs4TavnI4mYvAOC0uiJCg&usg=AFQjCNGTQCWE14j2-XEP6lQSFjTnMi98Zg&cad=rja>" >> series on performance tuning is available anywhere. It was on the IBM >> developerworks site but, no more. >> >> All suggestions gratefully received. >> Thanks in advance, >> Stuart Boydell >> >> >> >> >> >> _______________________________________________ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/-UV--AIX--System-Management-and-Performance-Tools-tp30724777p32471624.html Sent from the U2 - Users mailing list archive at Nabble.com. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users