Re: [U2] [UV][AIX] System Management and Performance Tools
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 UniVersehttp://www.google.com/url?sa=tsource=webcd=1sqi=2ved=0CBIQFjAAurl=http%3A%2F%2Fwww.mail-archive.com%2Fu2-users%40listserver.u2ug.org%2Fmsg13400.htmlrct=jq=dm-dw-dm-0512baldridge-iei=jMs4TavnI4mYvAOC0uiJCgusg=AFQjCNGTQCWE14j2-XEP6lQSFjTnMi98Zgcad=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
[U2] Masking data in fields
Hi There is a requirement to mask some of the fields across all tables in the database. Can someone help me on how to go about it, programatically, as I am a novice to programming? GG -- View this message in context: http://old.nabble.com/Masking-data-in-fields-tp31235726p31235726.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
[U2] Installing UniVerse the first time on a new server
I have the installation document(the UniVerse manual), for the steps. The OS is AIX 5.3. Can someone please highlight if I have to make note of anything/something which I have to be aware of before performing the install? G -- View this message in context: http://old.nabble.com/Installing-UniVerse-the-first-time-on-a-new-server-tp29922008p29922008.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
Re: [U2] Help in removing erroneous character from data file
Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? ___ 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/Help-in-removing-erroneous-character-from-data-file-tp29735223p29736257.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
[U2] Help in removing erroneous character from data file
I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp29735223p29735223.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
Re: [U2] Another probably simple SB+ issue.
Jeff, What I did was while exiting from the session, there is a small SB+ dialog box that appears with 3 options, Close,New Session and Re-connect. Above those buttons, there is a check box which asks - Save session? I clicked that, and exited. When I logged back in, I found the check against Use Windows Print Drivers option chosen(whatever change I made). Can you please try and see if that works. G -Original Message- From: Jeff Ritchie jritc...@lawsocnsw.asn.au To: u2-users@listserver.u2ug.org Sent: Thu, 7 May 2009 9:52 am Subject: RE: [U2] Another probably simple SB+ issue. G, Advice at this stage would be not to replicate as there appears to be a bug in SBClient, i.e. once you get the issue happening there's no way to reverse it that I know of. 1. Double click an SB+ item to bring up the oonnect screen, the one with the telephone, computers, satelite et al images. 2. From the top window menu select File. 3. From the drop down menu select Print Options. 4. Tick Use Windows Print Drivers 5. Click the OK button. Note even after leaving and returning to the Print Options window the Use Windows Print Drivers appears unclicked, that's a bug. 6. Connect to an SB+ session, selecting GUI mode. 7. Once in SB+ select a menu to go one down from the first menu you see. 8. You should now be seeing an icon bar below the top drop down menu, think this may have to be setup. 9. Click on the printer icon to do a page dump and it no longer goes direct to the printer. We have managed to reproduce on three machines but no one can work out how to fix it. Thinking if we canned the whole SB+ thing and went with a web interface this would be a whole bunch easier in the long run. Of course the goal here, according to management, is to migrate to Oracle so that's probably a moot point :( Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of apogee79 Sent: Thursday, 7 May 2009 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Another probably simple SB+ issue. Hi, I am not able to duplicate the problem. Can you please outline the exact steps. I am not able to find the small printer icon on the top. Is it application related or SB+ client window related? G -- View this message in context: http://www.nabble.com/Another-probably-simple-SB%2B-issue.-tp23399884p2341973 0.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ You are invited to Get a Free AOL Email ID. - http://webmail.aol.in --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Any limitation in UniVerse decimal places
In short, problem can be described as it is caused by? the fact that on certain condition represented by combination of large number of invoices and over 9 digits totals Universe engine creates a small fractional addition to total number. Has anyone heard of this? G -Original Message- From: Rex Gozar rgo...@autopower.com To: u2-users@listserver.u2ug.org Sent: Thu, 7 May 2009 5:49 pm Subject: Re: [U2] Any limitation in UniVerse decimal places (This response assumes that your upstream UniVerse billing application is totalling decimal amounts.)? ? I don't know of specific limitations concerning decimal places, but I do know that precision differences in floating point math cause unexpected behavior.? ? If you're trying to total dollar amounts in a program, it's a best practice to ICONV them into integers before any math operations -- this eliminates all floating point problems.? ? AFAIK the query language RETRIEVE (i.e. LIST, SORT) performs math operations on the data as-stored in the record, then applies the OCONV before displaying the total (also avoiding floating point problems).? ? rex? ? apogee79 wrote:? I shall explain the problem that I am encountering in the best detailed way? that I can. I am working on a billing application (running on UniVerse),? which sends details to a downstream application for invoicing. If several? invoice groups are sent in one shot, where the total is approximately more? that $20 million, an error occurs, due to rounding off. But when those? invoice groups are sent one at a time, this condition does not occur. Is? there any upper limit that is set in the configuration parameters? Can? anyone please throw some light on this?? G? ---? u2-users mailing list? u2-us...@listserver.u2ug.org? To unsubscribe please visit http://listserver.u2ug.org/? You are invited to Get a Free AOL Email ID. - http://webmail.aol.in --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/