Hi Jeff If you go to the following link:
http://www14.software.ibm.com/download/data/web/en_US/trialprograms/Z955 364D40826J60.html?S_TACT=104CBW71 and select UniData Clients this will download UniODBC etc. You can use these for all your needs and I don't believe they will expire. Good luck! Glenn Sallis Systems Developer Insurance Company Limited Insurance with a different perspective Telephone: +44 (0) 115 934 8990 Fax: +44 (0) 115 941 1316 Website: www.igi.co.uk -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 July 2007 14:09 To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #1760 U2 Users Digest Friday, July 13 2007 Volume 01 : Number 1760 In this issue: [U2] Unidata ODBC [U2] RE: [ID] Copying from AIX box to Linux box RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Re: [U2] Tracking Disk Writes - AIX, Unidata ---------------------------------------------------------------------- Date: Fri, 13 Jul 2007 08:30:05 -0400 From: Jeffrey Butera <[EMAIL PROTECTED]> Subject: [U2] Unidata ODBC We may embark down the ODBC connectivity path with Unidata (7.1.8 on solaris 9). My understanding is that I need to get the UniData clients toolkit and, in particular: UniODBC, the UniDK developer's Toolkit, and the Visual Schema Generator. Can anyone confirm this, and how/where I obtain these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, - -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "Daddy - did you lose your mind?" Catherine Butera ------------------------------ Date: Fri, 13 Jul 2007 07:57:41 -0500 From: Jon Wells <[EMAIL PROTECTED]> Subject: [U2] RE: [ID] Copying from AIX box to Linux box You guys were on the right track. My Sys. Admin. traced her connection to the network and found she was on the wrong kind of port. After switching that around, "scp" works much much faster. Now I'm going to look into this rsync folks have been talking about. THANKS, Jon Wells At 04:55 PM 7/12/2007, Matthew E. Lauterbach wrote: >I agree with Clayton. Sounds like a duplex issue. It sounds like the >port on the switch is erroring (<- is that even a word?) out. > > >Matthew E. Lauterbach >Programming/Systems Administration Support Specialist >Academic and Information Services >West Texas A&M University >8066512177 > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Clayton >Burton >Sent: Thursday, July 12, 2007 3:40 PM >To: Jon Wells; [EMAIL PROTECTED] >Subject: Re: [ID] Copying from AIX box to Linux box > >That ought to be a pretty fast process. >Are either of these boxes new to the network? >Are the duplex/simplex and network speeds set appropiately on the boxes >and on the routers/switches? > >--Clayton ------------------------------ Date: Fri, 13 Jul 2007 09:11:13 -0400 From: "Nick Cipollina" <[EMAIL PROTECTED]> Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance I agree. Trying to compare a relational database (such as SQL Server) and a post-relational database (such as UniData) is like trying to compare apples and oranges. Your best bet is to analyze how you are going to use the data, and pick the database that can handle those needs. Thanks, Nick Cipollina - -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, July 12, 2007 10:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Hi Robert Performance Benchmarking needs to be aligned with a business measure. Most performance benchmarks are done on the basis of Simple transactions per second. However where U2 realy bolts ahead is in complex transactions per second. In the realworld we have complex transactions, not always the simple Dr,Cr of a general ledger. A transaction will often involve various business rules and accessing multiple files for checks and process tables. With most RDBMS as the complexity increases, the more likely they will have to resort to processing outside of the database which causes a performance hit. With U2, the processing remains inside the database where basic code resides. Hence before doing performance benchmarking, make sure that the benchmarking represents the business process. It is like using a ferrari to delive furniture, it may be fast but it is the wrong vehicle for the job. Regards David Jordan > Is anyone aware of any performance benchmarks for UniData 7.1? How does > it stack up against SQL 2005? > > > Robert K. Kubarych > Network Services > Bergen Community College > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------------------------------ Date: Thu, 12 Jul 2007 09:36:38 -0400 From: Timothy Snyder <[EMAIL PROTECTED]> Subject: Re: [U2] Tracking Disk Writes - AIX, Unidata > I have a client who is experiencing something rather strange. Every few > seconds, and not with any particularly regularity, "topas" will report a > spike in disk writes, maxing out one or more disks to 100% utilization. CPU > utilization, on the other hand, remains nominal or only slightly elevated. > When this happens, the world stands still - literally - as user screens > freeze up until several seconds after the disks have gone back to normal > load. It may be tied to the syncd daemon, depending on how frequently "every few seconds" is. Try fiddling with the maxrandwrt parameter of the ioo command. I've seen this work miracles with intermittent spikes like you're describing. (I've also seen it make no difference at all, depending on the circumstances.) The default behavior of AIX provides improved overall system performance, but sometimes interactive processes suffer. By using the write-behind buffer with maxrandwrt, you even things out and reduce the spiky performance. Anyway, check out the man page for ioo and search for maxrandwrt for more information. This would probably be the easiest thing to try first. If it doesn't provide relief, you may want to play around with filemon, as suggested by somebody else. It will show you the busiest files on the system, but requires tinkering with quite a few command-line parameters to get useful results. Of course, AIX and UniData tuning can be quite complex, and the problems could be due to any number of factors. If no relief is in sight, you may need to get some assistance from somebody with experience with this type of tuning. [Oops - I forgot to enable the shameless plug alert.] Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group ------------------------------ End of U2 Users Digest V1 #1760 ******************************* ------------ u2-users-digest mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ IMPORTANT This email is issued on behalf of the IGI Group Limited or one of its subsidiary companies. This e-mail and any attachments are CONFIDENTIAL and may contain privileged information. If you are not the intended recipient of this e-mail message, please telephone or e-mail us immediately, delete this message from your system and do not read, copy, distribute, disclose or otherwise use this e-mail message and any attachments. You should not expect any e-mail communications to be private in nature. While this e-mail has been scanned for viruses, we cannot accept responsibility for any loss or damage arising from the use of this e-mail or attachments. IGI Group has the facility to monitor and read both incoming and outgoing communications by e-mail and these may be intercepted by its automated e-mail administrators. IGI Group will not accept e-mail communications found to contain viruses. Parent Company: IGI Group Limited. Registered office: Market Square House, St James's Street, Nottingham NG1 6FG. Tel: 0115 941 1022. Subsidiary companies (all with registered offices at the address above) include: IGI Insurance Company Limited (Reg No: 1229676). Authorised and regulated by the Financial Services Authority. Pedigree Livestock Insurance Limited (Reg No: 746184). Authorised and regulated by the Financial Services Authority. Shield Total Insurance Limited (Reg No: 3322760). Authorised and regulated by the Financial Services Authority. IGI Administration Services Limited. Oakwood Village Limited. Caravan Security Storage Limited. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/