RE: [U2] Performance monitoring
Get a count of the number of read locks at a busy time. If it's more than RLTABSZ times GSEMNUM, you'll want to increase gsemnum. I would avoid increasing GLTABSZ and RLTABSZ by much; the lock table is a hashed table, and just like uv files, broad and shallow yields better performance/less contention. Also look at MFILES; in the uv account, do a PORT.STATUS with the MFILE.HIST option to see how things are going. Closing reopening files is very expensive. I've asked a few people if there's an upper limit, and while nobody will commit to an answer (feel free, anyone), there appears to be no penalty to making it too big. I don't recall what the scratch buffer pool does, and the documentation is sparse. SELBUF is interesting, if you're doing a lot of selects. The default is 4, in units of 1K. So, if you do a select, it starts accumulating a list of id's in RAM until the size of that list reaches 4K. At that point, it creates a file in UVTEMP, and you're going to disk. I can't see much reason not to increase this to 1024, so select lists up to 1Mb are created in RAM. These may help some, but unless MFILES is massively underconfigured and you're using some absurd amount of cpu to just close re-open files, I'm inclined to think that the symptoms you mention indicate that AIX VMM tuning will give you more bang for the buck. I'd be especially looking at how VMM is treating computational vs file cache; with the amount of data you churn through in a night, you'll want to be sure to heavily favor computational memory pages. How much RAM do you have? -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 7:31 PM To: u2-users@listserver.u2ug.org Subject: 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
[U2] Performance monitoring
A quite different thing to check. From memory when we had AIX one of the batteries, I think for write cache, required replacement. The system would not cache any writes and performance slowed. Regards, Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:sara.bu...@publictrust.co.nz mailto:sara.bu...@publictrust.co.nz The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Index not working
Hi Over the past months we've seen a number of problems reported on this list that seem to relate to changes in the way that UniVerse is interpreting numeric/non-numeric fields. Clearly .20 is numerically the same as .2, but they shouldn't be indexed together. If you do a LIST.INDEX, is it reporting the index as left or right justified? Brian Current problem. when selecting for another item, i get 2, one of which is the 'unselected' record that we have been looking for. BEEN USING SELECT FILE WITH INVOICE EQ 509010016.2 and get zero when no using NO.INDEX if I switch to another invoice number ED FILE.INDEX 509010016.20 3 lines long. 0001: 01*261318*IN.509010016.20 0002: 01*261318*IN.509010016.2 0003: 01*261318*RF.509010016.2 Bottom at line 3. SELECT AR.OPEN.B4 WITH INVOICE EQ 509010016.20 2 record(s) selected to SELECT list #0. the two selected, first is number 1, 16.20 and the second is the one i want, # 2. --- Back in Version 6. I created several nifty indexes for the order file. Which had been designed to contain all orders, open or closed. by marrying the status flag to the custno, I created a unique enough key as to not bog down. Yeah, my first mistake was to create an index based on open or closed, which caused quite a performance hit. But by creating OPEN.ORDERS 001 = I 002 = IF STATUS = 'OPEN' THEN CUSTNO ELSE and create.index ORDER.DET OPEN.ORDERS NO.NULLS. I created a very useable index.. ditto when I swapped ORDNO for CUSTNO, so that the index was keyed by the ORDER NUMBER... But I haven't - Original Message - From: Charles Stevenson Date: Wednesday, March 4, 2009 4:45 pm Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org In a prior release 10.0 or earlier, I encountered a problem that could corrupt an index if a write was issued without an explicit readu precedingit. I don't think IBM ever corrected that because writing without explicitly locking is Bad Form. If I remember, when process A holds a lock on a record and then process B issues a write (w/o explicitly locking),by default B sits and waits for 20 minutes, then gives up with a write error. (In my opinion, the defaultlock.wait should either be forever, or a uvconfig parameter, not 20 minutes.) If process B's write was to a file that had indexes, that complicated things - I don't recall the details - and we ended up with inconsistencies between the data files and the index files. How to proceed: - Monotor uv/errlog to see if you have write errors. - Look for programs that write without locking. - 20 minute wait limit is configurable. I set ours to one month (=2678400seconds), effectively forever, since we'd bring UV down up more frequently then that. To do so, execute a basic program from UV.LOGIN (that all uv processes execute on startup) that does ASSIGN 2678400 TO SYSTEM(1999).TCL command SET.SQL LOCK.WAIT 2678400 accomplishes the same. All that is from memory, by that's the gist of it. Completely separate, but did you know you can create an F- pointer to the index file itself and then select, ed, basic open/read/write it like any other file? The F-pointer would look something like this: F I_FILE/INDEX.00n D_your_debugging_index_dictionary_with trans()s to data file, etc. Sometimes that can help you troubleshoot or even manually correct a critical index on the fly. But be careful. You can easily introduce more corruption. Especially if you leave the F-pointer lying around after you're done. Chuck Stevenson --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML Extraction -- Receiving XML Documents
I am trying to import an XML document following the examples given in the UniBasic Extension manual. I tried the method cited on page 6-17 of this manual using PrepareXML, OpenXMLData, etc and got successful status results at each step but I never saw any data. I tried using the XMAP API example cited on page 9-21 getting successful results down to the XMAPReadNext; however the first readnext yielded an end of data. Does anyone know where I can find a meaningful example of how to properly use either of these methods? Perhaps somewhere there is a step-by-step list of the things I must first have in place and a complete working example not just code segments? I'm using UniData 7.1 on AIX 5.1.3. (I posted this on the u2ug technology forum but no response.) Thanks, Steve Jones --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC Connection to Universe on HP-UX
We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? Are there any performance issues or considerations that we need to be aware of? Thanks, Henry. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Performance monitoring
MFILES is related to the OS per process open file limit (documented in the uvconfig file). The specific name of this value varies for different OSes. It looks like the default limit for AIX is 2000 (listed as nofiles). This was the absolute maximum until around 4.3.1. An individual user can see their setting via the ulimit -a command. Some time ago we had a program that started getting slower over time. Turns out the original programmer had made liberal use of dynamic arrays rather than dimensioned arrays, and these become horribly inefficient when they become large. HTH Drew -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Thursday, March 05, 2009 2:47 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Performance monitoring Get a count of the number of read locks at a busy time. If it's more than RLTABSZ times GSEMNUM, you'll want to increase gsemnum. I would avoid increasing GLTABSZ and RLTABSZ by much; the lock table is a hashed table, and just like uv files, broad and shallow yields better performance/less contention. Also look at MFILES; in the uv account, do a PORT.STATUS with the MFILE.HIST option to see how things are going. Closing reopening files is very expensive. I've asked a few people if there's an upper limit, and while nobody will commit to an answer (feel free, anyone), there appears to be no penalty to making it too big. I don't recall what the scratch buffer pool does, and the documentation is sparse. SELBUF is interesting, if you're doing a lot of selects. The default is 4, in units of 1K. So, if you do a select, it starts accumulating a list of id's in RAM until the size of that list reaches 4K. At that point, it creates a file in UVTEMP, and you're going to disk. I can't see much reason not to increase this to 1024, so select lists up to 1Mb are created in RAM. These may help some, but unless MFILES is massively underconfigured and you're using some absurd amount of cpu to just close re-open files, I'm inclined to think that the symptoms you mention indicate that AIX VMM tuning will give you more bang for the buck. I'd be especially looking at how VMM is treating computational vs file cache; with the amount of data you churn through in a night, you'll want to be sure to heavily favor computational memory pages. How much RAM do you have? -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 7:31 PM To: u2-users@listserver.u2ug.org Subject: 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
Re: [U2] Performance monitoring
There are a series of articles written by Mark Baldridge that are very good. A little verbose, but very good. You can find them in the Developers Works section of the U2 web site. Here it link to one of them http://www.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-i.html It takes awhile to go through them, but it very educational. HTH Tom Dodds On Mar 4, 2009, at 10:58 AM, ericro wrote: 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/
RE: [U2] XML Extraction -- Receiving XML Documents
If everything works with the extract (using an EXT file) without error but you are not getting any data then either the start attribute is wrong or your field attributes are wrong. If you post the first chunk of the xml and your ext we can have a look. Rgds Symeon. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Steve Jones Sent: 05 March 2009 11:44 To: u2-users@listserver.u2ug.org Subject: [U2] XML Extraction -- Receiving XML Documents I am trying to import an XML document following the examples given in the UniBasic Extension manual. I tried the method cited on page 6-17 of this manual using PrepareXML, OpenXMLData, etc and got successful status results at each step but I never saw any data. I tried using the XMAP API example cited on page 9-21 getting successful results down to the XMAPReadNext; however the first readnext yielded an end of data. Does anyone know where I can find a meaningful example of how to properly use either of these methods? Perhaps somewhere there is a step-by-step list of the things I must first have in place and a complete working example not just code segments? I'm using UniData 7.1 on AIX 5.1.3. (I posted this on the u2ug technology forum but no response.) Thanks, Steve Jones --- 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/
RE: [U2] ODBC Connection to Universe on HP-UX
We have noticed that the first connection of the day takes longer then subsequent reads. We use ODBC for reads only. We created a separate UV account with scaled down dictionaries that have I-descriptors with UV basic code to extract the Multi-value fields and format as need for our application. The primary application for ODBC is our UPS shipping system to read SHIP-TO and Package data. If you have Multi-value fields the SQL INSERT and UPDATE probably will not work. For our web site we use RedBack since the ODBC could not provide the speed required. (IBM(r) U2 Web Development Environment for UniData and UniVerse (U2 Web DE) is the new name for RedBack) Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Martel, Henry Sent: Thursday, March 05, 2009 5:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] ODBC Connection to Universe on HP-UX We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? Are there any performance issues or considerations that we need to be aware of? Thanks, Henry. --- 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/
RE: [U2] Multiple email copies
Look at the headers for each e-mail and see where the mail is coming from and going to. If you're using Outlook open the message fully and click on View, Options . The Internet Headers are the complete mail envelope headers as transmitted from your mail server. It could be a case of mail client rules duplicating it because of duplicate rule entries or a KCI(keyboard chair interface) error on behalf of the SMTP server admin. If the headers of all of the messages are identical then your mail client is doing it. If they are all different then a mail server is doing it. I'd say post the mail headers but munging the spam-bot-loving info makes the headers useless for debugging. If you can't figure it out e-mail me the headers of the duplicate messages directly and I'll take a look. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Rusty Bug Sent: Wednesday, March 04, 2009 7:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multiple email copies Yes, I still receiving multiple copies... :( --- Diego - Original Message From: George Gallen ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Wednesday, March 4, 2009 2:06:45 PM Subject: RE: [U2] Multiple email copies No. I've only been getting 1 each. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Wednesday, March 04, 2009 2:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple email copies Is anyone else receiving 5 copies of each mail sent to the u2-users list ? Last week I was only receiving 3 copies of each mail. --- --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Index not working
Brian Initially testing confirms that a R versus L is the problem. thanks. Roger Original Message - From: Brian Leach Date: Thursday, March 5, 2009 5:41 am Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org Hi Over the past months we've seen a number of problems reported on this list that seem to relate to changes in the way that UniVerse is interpreting numeric/non-numeric fields. Clearly .20 is numerically the same as .2, but they shouldn't be indexed together. If you do a LIST.INDEX, is it reporting the index as left or right justified? Brian Current problem. when selecting for another item, i get 2, one of which is the 'unselected' record that we have been looking for. BEEN USING SELECT FILE WITH INVOICE EQ 509010016.2 and get zero when no using NO.INDEX if I switch to another invoice number ED FILE.INDEX 509010016.20 3 lines long. 0001: 01*261318*IN.509010016.20 0002: 01*261318*IN.509010016.2 0003: 01*261318*RF.509010016.2 Bottom at line 3. SELECT AR.OPEN.B4 WITH INVOICE EQ 509010016.20 2 record(s) selected to SELECT list #0. the two selected, first is number 1, 16.20 and the second is the one i want, # 2. --- Back in Version 6. I created several nifty indexes for the order file. Which had been designed to contain all orders, open or closed. by marrying the status flag to the custno, I created a unique enough key as to not bog down. Yeah, my first mistake was to create an index based on open or closed, which caused quite a performance hit. But by creating OPEN.ORDERS 001 = I 002 = IF STATUS = 'OPEN' THEN CUSTNO ELSE and create.index ORDER.DET OPEN.ORDERS NO.NULLS. I created a very useable index.. ditto when I swapped ORDNO for CUSTNO, so that the index was keyed by the ORDER NUMBER... But I haven't - Original Message - From: Charles Stevenson Date: Wednesday, March 4, 2009 4:45 pm Subject: Re: [U2] Universe Index not working To: u2-users@listserver.u2ug.org In a prior release 10.0 or earlier, I encountered a problem that could corrupt an index if a write was issued without an explicit readu precedingit. I don't think IBM ever corrected that because writing without explicitly locking is Bad Form. If I remember, when process A holds a lock on a record and then process B issues a write (w/o explicitly locking),by default B sits and waits for 20 minutes, then gives up with a write error. (In my opinion, the defaultlock.wait should either be forever, or a uvconfig parameter, not 20 minutes.) If process B's write was to a file that had indexes, that complicated things - I don't recall the tails - and we ended up with inconsistencies between the data files and the index files. How to proceed: - Monotor uv/errlog to see if you have write errors. - Look for programs that write without locking. - 20 minute wait limit is configurable. I set ours to one month (=2678400seconds), effectively forever, since we'd bring UV down up more frequently then that. To do so, execute a basic program from UV.LOGIN (that all uv processes execute on startup) that does ASSIGN 2678400 TO SYSTEM(1999).TCL command SET.SQL LOCK.WAIT 2678400 accomplishes the same. All that is from memory, by that's the gist of it. Completely separate, but did you know you can create an F- pointer to the index file itself and then select, ed, basic open/read/write it like any other file? The F-pointer would look something like this: F I_FILE/INDEX.00n D_your_debugging_index_dictionary_with trans()s to data file, etc. Sometimes that can help you troubleshoot or even manually correct a critical index on the fly. But be careful. You can easily introduce more corruption. Especially if you leave the F-pointer lying around after you're done. Chuck Stevenson --- 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/ --- 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/
Re: [U2] ODBC Connection to Universe on HP-UX
In message 291595756f51e34ea52a45b3a191dae3f5b...@anorpexbe01.auca.corp, Martel, Henry henry.mar...@wearguard-crest.com writes We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? OleDB or ODBC? Are there any performance issues or considerations that we need to be aware of? If you can use OleDB you're probably a lot better off. I'm sure somebody will correct me if I'm wrong :-) but as I understand it OleDB is the main connectivity thing, and ODBC is a layer on top of it. Best avoided if you don't need to use it. While it still makes an awful lot of sense to run HS.SCRUB, with OleDB you don't need @SELECT (all your fields and files are visible, which may or may not be a good thing :-), you don't need HS.UPDATE.FILEINFO, and generally there's just less to go wrong! And in my experience, things do go wrong ... accessing UV using the MS-Access ODBC as a front end is currently passing dud SQL to UV :-( Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Connection to Universe on HP-UX [ad]
From: Henry.Martel We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? Are there any performance issues or considerations that we need to be aware of? One of our clients was using ODBC with Universe and got into a situation where licenses would get consumed but couldn't be released. They worked closely with IBM for months and the only resolution was to buy more licenses to avoid other users from being inconvenienced. Yes, that's the way it worked out, so they needed to find another solution, and they called me. Nebula RD sells, support, and provides development services for mv.NET, which this site evaluated and then adopted as their solution. mv.NET allows for reads and writes, with familiar MV BASIC syntax, or optionally using SQL-like queries it seamlessly integrates with all facets of ADO.NET. We use it to move data between MV systems, to/from relational, and now between MV and Amazon SimpleDB and other cloud repositories. Email for more info. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services Blog: remove.pleaseNebula-RnD.com/blog Contribute to PickWiki.com! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Unexpected telnet/SSH error
This started out to be a bug report, but now I'm not sure if it's just a don't do that issue. Whenever I connect to my Unidata PE 7.2 over Windows via telnet, an unknown software exception error dialog would display on the _server_ desktop. I realized this was because I was telnetting onto the SSH port. OK, oops, don't do that. But I'd consider this a bug. Can someone else verify this behaviour and then report it to IBM through proper channels? (As a PE user I've never reported an issue directly to IBM and frankly wouldn't know how. Did I not RTM properly?) Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML Extraction -- Receiving XML Documents
Here is the information I have so far. I have not yet determined how to pull the attributes Lease and Type from the Transaction node. I don't have a DTD. I've included my test program, the ext file and the xml file. Thanks, Steve PAGE 1Uni/Basic Thu Mar 5 11:28:23 2009 TEST.PARSER 001 PROGRAM TEST.PARSER 002 * 003 $INCLUDE INCLUDE XML.H 004 xdata = '' 005 FILE.NAME = 'testextract.xml' 006 THE.PATH = _XML_/ 007 THE.FULL.NAME = THE.PATH : FILE.NAME 008 * 009 STATUS = PREPAREXML(THE.FULL.NAME,INSUR_DATA) 010 IF STATUS = XML.SUCCESS THEN 011 DISPLAY 'STATUS ':STATUS 012 END ELSE 013 STOP 'COULD NOT OPEN THE FILE' 014 END 015 * 016 STATUS = OPENXMLDATA(INSUR_DATA, _XML_/testextract.ext, INSUR_DATA_HANDLE) 017 IF STATUS = XML.ERROR THEN 018 STOP ERROR WHEN OPENING THE XML DOCUMENT 019 END 020 * 021 IF STATUS = XML.INVALID.HANDLE THEN 022 STOP ERROR: INVALID PARAMETER PASSED 023 END 024 * 025 EOR = 0 026 LOOP UNTIL EOR DO 027 STATUS = READXMLDATA(INSUR_DATA_HANDLE,xdata) 028 DISPLAY 'STATUS 2 ':STATUS 029 IF STATUS = XML.ERROR THEN 030STOP ERROR WHEN PREPARING THE XML DOCUMENT. 031 END ELSE IF STATUS = XML.EOF THEN 032PRINT NO MORE DATA 033EOR = 1 034 END ELSE 035DISPLAY xdata 036INPUT XXX 037IF XXX='S' THEN EOR = 1 038 END 039 REPEAT 040 * 041 STATUS = CLOSEXMLDATA(INSUR_DATA_HANDLE) 042 * 043 STATUS = RELEASEXML(INSUR_DATA) 044 RETURN testextract.ext in _XML_ U2XML_extraction file_extraction start = /BDT_TRANSACTIONS/Transaction/ field_extraction field = TRANSACTION_CODE path = Transaction/TRANSACTION_CODE/text()/ field_extraction field = CLIENT_NUMBER path = Transaction/CLIENT_NUMBER/text()/ field_extraction field = COMPANY_NUMBER path = Transaction/COMPANY_NUMBER/text()/ field_extraction field = CUSTOMER_ID path = Transaction/CUSTOMER_ID/text()/ field_extraction field = LEASE_NUMBER path = Transaction/LEASE_NUMBER/text()/ field_extraction field = REASON_CODE path = Transaction/REASON_CODE/text()/ /U2XML_extraction The xml transaction file: ?xml version=1.0 encoding=UTF-8 ? - BDT_TRANSACTIONS - Transaction Lease=040815.01 Type=C TRANSACTION_CODEC/TRANSACTION_CODE CLIENT_NUMBER2505/CLIENT_NUMBER COMPANY_NUMBER01/COMPANY_NUMBER CUSTOMER_ID040815/CUSTOMER_ID LEASE_NUMBER040815.01/LEASE_NUMBER REASON_CODELC/REASON_CODE CLIENT_COVERAGE_EFFECTIVE_DATE20080201/CLIENT_COVERAGE_EFFECTIVE_DATE CLIENT_COVERAGE_EXPIRATION_DATE20090110/CLIENT_COVERAGE_EXPIRATION_DATE CLIENT_COVERAGE_CANCEL_DATE20080805/CLIENT_COVERAGE_CANCEL_DATE INSURANCE_TERM0/INSURANCE_TERM EQUIPMENT_VALUE20818/EQUIPMENT_VALUE CHANGE_IN_EQUIP_VALUE0/CHANGE_IN_EQUIP_VALUE LI_CLASS_CODE / INVOICE_METHOD / PROGRAM_CODEPLLSL/PROGRAM_CODE REMAINING_INVOICES10/REMAINING_INVOICES INVOICE_CREATE_DUE_DATE20080310/INVOICE_CREATE_DUE_DATE FULL_TERM_CLIENT_INSURANCE_COST-49.16/FULL_TERM_CLIENT_INSURANCE_COST FULL_TERM_FINANCE_CHARGE-17.26/FULL_TERM_FINANCE_CHARGE FULL_TERM_LI_SERVICE_FEE0.00/FULL_TERM_LI_SERVICE_FEE FULL_TERM_SUBCONTRACTOR_FEE-33.28/FULL_TERM_SUBCONTRACTOR_FEE FULL_TERM_CUSTOMER_INSURANCE_CHARGE-99.70/FULL_TERM_CUSTOMER_INSURANCE_CH ARGE CUSTOMER_INVOICE_FREQUENCYM/CUSTOMER_INVOICE_FREQUENCY CUSTOMER_INSURANCE_CHARGE_PER_INVOICE21.72/CUSTOMER_INSURANCE_CHARGE_PER_ INVOICE CHANGE_IN_CUSTOMER_INSURANCE_CHARGE_PER_INVOICE-21.72/CHANGE_IN_CUSTOMER_ INSURANCE_CHARGE_PER_INVOICE PRIOR_AMOUNT0.00/PRIOR_AMOUNT INSURANCE_COMPONENT0.00/INSURANCE_COMPONENT FINANCE_COMPONENT0.00/FINANCE_COMPONENT LI_SERVICE_FEE_COMPONENT0.00/LI_SERVICE_FEE_COMPONENT SUBCONTRACTOR_FEE_COMPONENT0.00/SUBCONTRACTOR_FEE_COMPONENT LI_CERTIFICATE_NUMBER0029990118/LI_CERTIFICATE_NUMBER /Transaction - Transaction Lease=044533.02 Type=C TRANSACTION_CODEC/TRANSACTION_CODE CLIENT_NUMBER2505/CLIENT_NUMBER COMPANY_NUMBER01/COMPANY_NUMBER CUSTOMER_ID044533/CUSTOMER_ID LEASE_NUMBER044533.02/LEASE_NUMBER REASON_CODEOC/REASON_CODE CLIENT_COVERAGE_EFFECTIVE_DATE20070910/CLIENT_COVERAGE_EFFECTIVE_DATE CLIENT_COVERAGE_EXPIRATION_DATE20100910/CLIENT_COVERAGE_EXPIRATION_DATE CLIENT_COVERAGE_CANCEL_DATE20070910/CLIENT_COVERAGE_CANCEL_DATE INSURANCE_TERM0/INSURANCE_TERM EQUIPMENT_VALUE81808/EQUIPMENT_VALUE CHANGE_IN_EQUIP_VALUE0/CHANGE_IN_EQUIP_VALUE LI_CLASS_CODE / INVOICE_METHOD / PROGRAM_CODEPLLSL/PROGRAM_CODE REMAINING_INVOICES31/REMAINING_INVOICES INVOICE_CREATE_DUE_DATE20080210/INVOICE_CREATE_DUE_DATE
Re: [U2] [UD] Unexpected telnet/SSH error
G-Man: Is something listening on port 22? Bill __ From: Tony G 1tlx6h...@sneakemail.com Sent: 3/5/2009 4:09 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Unexpected telnet/SSH error This started out to be a bug report, but now I'm not sure if it's just a don't do that issue. Whenever I connect to my Unidata PE 7.2 over Windows via telnet, an unknown software exception error dialog would display on the _server_ desktop. I realized this was because I was telnetting onto the SSH port. OK, oops, don't do that. But I'd consider this a bug. Can someone else verify this behaviour and then report it to IBM through proper channels? (As a PE user I've never reported an issue directly to IBM and frankly wouldn't know how. Did I not RTM properly?) Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.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/
Re: [U2] ODBC Connection to Universe on HP-UX
Henry, The ODBC connection is the slowest connection into the U2 product line. If the application will not have a lot of users on it, ODBC will be fine. But, ODBC will not scale if you have numerous connections. Steve O'Neal U2 Lab Services Sales Specialist,IBM Data Management, IBM Software Group From: Martel, Henry henry.mar...@wearguard-crest.com To: u2-users@listserver.u2ug.org Date: 03/05/2009 07:07 AM Subject: [U2] ODBC Connection to Universe on HP-UX We are thinking of changing our application connect to Universe through ODBC connections. Has anyone had experience doing this? Are there any performance issues or considerations that we need to be aware of? Thanks, Henry. --- 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/
RE: [U2] [UD] Unexpected telnet/SSH error
Bill - the problem isn't that I want to run SSH or that I can't find telnet. Although I do have 7 MV DBMS platforms running on my system and none of them run on default ports. :) I did accidentally telnet to the wrong port, but then found the right port, oops, mea culpa. The issue is that it looks like anyone can generate a mysterious server desktop dialog simply by telnetting to the SSH port. That would have to annoy someone if it happens at the wrong time and you're not sure what caused it. Try it. If your default for Telnet is 23 and SSH is 22, just Telnet to port 22 and see what happens. T From: Bill Haskett G-Man: Is something listening on port 22? Bill From: Tony G This started out to be a bug report, but now I'm not sure if it's just a don't do that issue. Whenever I connect to my Unidata PE 7.2 over Windows via telnet, an unknown software exception error dialog would display on the _server_ desktop. I realized this was because I was telnetting onto the SSH port. OK, oops, don't do that. But I'd consider this a bug. Can someone else verify this behaviour and then report it to IBM through proper channels? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/