[U2] Performance monitoring
We run an IBM P570 with 12 processors running Universe 10.2.4, average of 400 users against at EMC DMX4500 disk array. 20 file systems with each about 45gb, 60-80% utilized striped across 94 disks. We do tons of batch processing at night and our rate of data change is about 175GB an hour at night. We're running into some performance issues, jobs taking much longer, keyboard response slow, editing single records taking a long time, etc. and want to really dive in to see what's going on. We've looked at file sizing and have done a fair amount of resizing, but to little avail. Does anyone have any tools, or know of any tools, similar to Oracle, that can really give me insight into what's happening with a given user session at any time? I know I can do port.status and find the address in the code and see what's being executed at that time, but I want something more that will show memory utilization and other stats like that. Any help would be appreciated. -- View this message in context: http://www.nabble.com/Performance-monitoring-tp22336819p22336819.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/
RE: [U2] Performance monitoring
We use topas, but do you have any techniques for analyzing individual user sessions to understand what's going on within Universe/the OS/the disk? Thanks. Drew Henderson-2 wrote: > > If you haven't already, you might want to take a look at the "topas" > command. It'll give you an overall view of what's going on with the > system, including per/processor utilization, per/process information, and > disk utilization information. The "h" key while in the program provides a > bit more useful information on toggling between screens and what it'll do > than does the man page. > > HTH > Drew > > -Original Message- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro > Sent: Wednesday, March 04, 2009 1:59 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Performance monitoring > > We run an IBM P570 with 12 processors running Universe 10.2.4, average of > 400 > users against at EMC DMX4500 disk array. 20 file systems with each about > 45gb, 60-80% utilized striped across 94 disks. > > We do tons of batch processing at night and our rate of data change is > about > 175GB an hour at night. We're running into some performance issues, jobs > taking much longer, keyboard response slow, editing single records taking > a > long time, etc. and want to really dive in to see what's going on. We've > looked at file sizing and have done a fair amount of resizing, but to > little > avail. > > Does anyone have any tools, or know of any tools, similar to Oracle, that > can really give me insight into what's happening with a given user session > at any time? I know I can do port.status and find the address in the code > and see what's being executed at that time, but I want something more that > will show memory utilization and other stats like that. > > Any help would be appreciated. > -- > View this message in context: > http://www.nabble.com/Performance-monitoring-tp22336819p22336819.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/ > > -- View this message in context: http://www.nabble.com/Performance-monitoring-tp22336819p22338770.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/
RE: [U2] Performance monitoring
Sounds like a good start. I'm also wondering how the Universe config is playing into things. There are some parameters we've never changed, i.e. the scratch buffer stuff, and others we have such as the lock parameters. We haven't changed any of these in some time, but I'm wondering if we're hitting some thresholds. How would I know? Dan Fitzgerald wrote: > > Of course, there are a lot of things to look at. > > I think what you're looking for is svmon -U username. This will show you > the > user's memory map. Svmon with no arguments shows you overall stats; one > thing to look for there is that there should be no pinned memory for UV; > Oracle needs pinned memory, it's wasted with (and unusable to) UV. > > Further, there are three AIX commands that will display environment > variables (as of 5.2) are vmo, ioo, and schedo. Vmo -l, for example, will > give you virtual memory settings. These are stored in > /etc/tunables/lastboot, but - similar to looking at uvconfig rather than > analyze.shm - what's in lastboot may not be the current values. > > Now, one of the first things to look at is in vmstat -v. This is output in > nmon, if you're running that daily (recommended); if not, you can run it > at > the command line. Look for these lines: > > vmstat -v 0 pending disk I/Os blocked with no pbuf > vmstat -v 0 paging space I/Os blocked with no psbuf > vmstat -v 9877 filesystem I/Os blocked with no fsbuf > vmstat -v 0 client filesystem I/Os blocked with no fsbuf > vmstat -v 0 external pager filesystem I/Os blocked with no > fsbuf > > If, over time, these are growing, you'll need to increase the number of > the > various file buffers. If you see growth over, say, an hour, you'll want to > increase significantly. > > > > > > -Original Message- > From: owner-u2-us...@listserver.u2ug.org > [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of ericro > Sent: Wednesday, March 04, 2009 1:59 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Performance monitoring > > We run an IBM P570 with 12 processors running Universe 10.2.4, average of > 400 > users against at EMC DMX4500 disk array. 20 file systems with each about > 45gb, 60-80% utilized striped across 94 disks. > > We do tons of batch processing at night and our rate of data change is > about > 175GB an hour at night. We're running into some performance issues, jobs > taking much longer, keyboard response slow, editing single records taking > a > long time, etc. and want to really dive in to see what's going on. We've > looked at file sizing and have done a fair amount of resizing, but to > little > avail. > > Does anyone have any tools, or know of any tools, similar to Oracle, that > can really give me insight into what's happening with a given user session > at any time? I know I can do port.status and find the address in the code > and see what's being executed at that time, but I want something more that > will show memory utilization and other stats like that. > > Any help would be appreciated. > -- > View this message in context: > http://www.nabble.com/Performance-monitoring-tp22336819p22336819.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/ > > -- View this message in context: http://www.nabble.com/Performance-monitoring-tp22336819p22342848.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] filepeek documentation
Looking for some documentation on filepeek. In particular not just the commands, but any example of usage. In particular usage with dynamic files and 64bit files. Of course, if somone's just got the commands that would be a great start. Thanks in advance. -- View this message in context: http://www.nabble.com/filepeek-documentation-tp16399128p16399128.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/
Re: [U2] filepeek documentation
I'm just looking to do some playing around with files, in a test scenario, of course. Thanks for the feedback. Ray Wurlod wrote: > > There are some examples in the IBM training class (I think it's called > UniVerse Theory and Practice - anyway, the old "internals" class). > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > > -- View this message in context: http://www.nabble.com/filepeek-documentation-tp16399128p16447665.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] index integrity
Does anyone know of a way to validate the file level integrity of an index file? fixtool will process an index data file, however, it comes back telling you that everything is okay, but that it processed 0 records which is not the case. My goal is to find a way to tell if indices are corrupt after coming up after a system crash. Thanks in advance. -- View this message in context: http://www.nabble.com/index-integrity-tp16596610p16596610.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] phantom checking - Universe
Is there a system variable that can be used within a Basic program that tells you how many phantoms you have running from your session. I know the JOBS command will return this, however, Ibd like to find this out without the user seeing the JOBS output to the screen. If I put a HUSH ON prior to executing the command, then I get nothing back in the CAPTURING clause of my execute statement. Thanks in advance. -- View this message in context: http://www.nabble.com/phantom-checking---Universe-tp16763998p16763998.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] Sr. Programmer Position or Contractor - San Diego, CA
We have an opening at PETCO in San Diego, California for a Sr. level Universe/multi-value developer. While we are looking for a permanent employee, we do have projects that could be supported by a contract resource as well. Relocation is an option. If you're interested, please send resume and salary requirements to: Eric Rosenzweig [EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/Sr.-Programmer-Position-or-Contractor---San-Diego%2C-CA-tp17093238p17093238.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] XML Help
We're new to XML in Universe and are trying to generate XML that looks like this for our Warehouse Management System by Manhattan. The challenge is getting the number of levels that Manhattan requires. Since the only way we've found to get more levels is to have multi-valued fields in an association, we can't generate this XML because there are too many levels. We're resorting to just creating a BASIC program to handle this, but any guidance or reference to a way to do this semi-automatically within Universe would be greatly appreciated. XML Layout: -- View this message in context: http://www.nabble.com/XML-Help-tp17220286p17220286.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] XML extraction problem
Trying to extract an XML file and I want to use the BY_NAME clause in the extraction map so I can load the data into different attributes (not in order) but it keeps failing. We're on Universe 10.2.4 Is this feature not supported? Any help would be appreciated. -- View this message in context: http://www.nabble.com/XML-extraction-problem-tp18019674p18019674.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/
