RE: [U2] UniObject Problem
John If you find RedBack too slow try watching where youa re spending the effort (see perfrgw). Usual suspects: 1. WWSTATE (manage this file - positively) 2. RedBack 4.1.3.2 without the right patches (upgrade RedBack 4.2 - has them included) 3. Do you use the OPEN2 method or OPEN (please use OPEN2) 4. Run stateless objects 5. Do you use session variables ? - (don't - this leads to IIS bottlenecks - not a RedBack issue) Regads JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tsombakos, John Sent: 29 June 2004 13:16 To: [EMAIL PROTECTED] Subject: RE: [U2] UniObject Problem Just want to give my two cents. Yes, there is a threading issue with using Uniobjects with IIS to talk to Universe. Universe is not thread safe/aware with regards to Uniobjects. IIS uses a threading model to talk to multiple web connections, and when those connections then try to use Uniobjects, the connections cross. I was having multiple errors when I had more then one or two users using a system we developed. The errors that we are mostly getting are: 30114 UVE_EXECUTEISACTIVE An execute is currently active and 39120 UVE_SESSION_NOT_OPEN The session is not open I was given this information directly from IBM support (if you do a search of the archives, you'll see my previous messages. There was supposed to be a fix, but I haven't seen it. We've since moved to using Redback for our web applications, but frankly, I wish that Uniobjects worked with IIS. Redback is OK, but it seems to be a bit of overkill for some of the things we're doing, not to mention we've had some speed issues. Redback just isn't that fast for us, no matter what I've tried. Uniobjects, for all it's problems, was nice and fast. (also, watch out for this bug - http://www.indexinfocus.com/dl/u2list/200201/25228.html - this is with Universe 9.6. I'd like to assume it was fixed in a later version) Please let me know if a later version of Universe/Uniobjects/ASP does work, I'd love to be able to switch (and if possible, without going to .NET...ugh...) --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
The experience we had was with the UniOLEDB components but I believe the same unirpc service handles the requests at the Unidata side. It appears that unirpc serialises requests effectively limiting the system to one concurrent user. The system tested was Unidata 5.2. (Unidata 6 seems to solve the problem but more testing is required to confirm it) Hope that helps Nick -Original Message- From: Wendy Smoak [mailto:[EMAIL PROTECTED] Sent: 30 June 2004 23:02 To: [EMAIL PROTECTED] Subject: FW: [U2] UniObject Problem Anyone care to comment on this one? I'm curious! Martin Scholl wrote: UniObjects is not thread safe (Will be hopefully with the .NET version that comes out any day now). The connections cross. With every database interaction from ASP, I open the connection, do my read, write etc and disconnect. I don't know if this is really safe so I am awaiting UniObjects.NET impatiently. This is how I use UOJ as well. Can you give an example of an interaction in which the connections 'cross'? IOW, rather than connect, write, disconnect, what would an incorrectly written application that causes problems look like? Thanks, -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
Just want to give my two cents. Yes, there is a threading issue with using Uniobjects with IIS to talk to Universe. Universe is not thread safe/aware with regards to Uniobjects. IIS uses a threading model to talk to multiple web connections, and when those connections then try to use Uniobjects, the connections cross. I was having multiple errors when I had more then one or two users using a system we developed. The errors that we are mostly getting are: 30114 UVE_EXECUTEISACTIVE An execute is currently active and 39120 UVE_SESSION_NOT_OPEN The session is not open I was given this information directly from IBM support (if you do a search of the archives, you'll see my previous messages. There was supposed to be a fix, but I haven't seen it. We've since moved to using Redback for our web applications, but frankly, I wish that Uniobjects worked with IIS. Redback is OK, but it seems to be a bit of overkill for some of the things we're doing, not to mention we've had some speed issues. Redback just isn't that fast for us, no matter what I've tried. Uniobjects, for all it's problems, was nice and fast. (also, watch out for this bug - http://www.indexinfocus.com/dl/u2list/200201/25228.html - this is with Universe 9.6. I'd like to assume it was fixed in a later version) Please let me know if a later version of Universe/Uniobjects/ASP does work, I'd love to be able to switch (and if possible, without going to .NET...ugh...) John T. -Original Message- Date: Mon, 28 Jun 2004 07:54:59 -0700 From: Wendy Smoak [EMAIL PROTECTED] Subject: RE: [U2] UniObject Problem Kevin Vezertzis wrote: Has anyone had experience or problems interfacing UniObjects directly to .ASP? We are seeing errors when two simultaneous users are making requests to the database. I believe this is a known issue, check the archives for more info. Here's the first thread I turned up, although I'm not sure whether it refers to the exact setup you're using: http://www.indexinfocus.com/dl/u2list/200402/61668.html - -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management -- Date: Mon, 28 Jun 2004 12:44:36 -0400 From: Martin Scholl [EMAIL PROTECTED] Subject: RE: [U2] UniObject Problem UniObjects is not thread safe (Will be hopefully with the .NET version that comes out any day now). The connections cross. With every database interaction from ASP, I open the connection, do my read, write etc and disconnect. I don't know if this is really safe so I am awaiting UniObjects.NET impatiently. Martin Scholl President HIPAAsuite 18910 New Hampshire Ave Brinklow, MD 20862 301-924-5537 Phone 301-570-0139 Fax 301-613-9572 Cell --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObject Problem
We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
Hi, A similar problem, if the recent conversion included upgrading TO AIX 5.1. We also had VERY high paging faults. We actually found that there is an issue with AIX 5.1 itself being very slow, and that was fixed by installing Machine Level 04. I'm not sure if that's the most current machine level at this point, but I know it fixed our system (running Unidata). Check IBM's website for Machine Level downloads. Good luck! - Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Vezertzis Sent: Monday, June 28, 2004 9:30 AM To: [EMAIL PROTECTED] Subject: [U2] UniObject Problem We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
Sorry.. Typo. Make that AIX 5.1 ML-05 as the fix. - Dave -Original Message- From: Dave Tabor Sent: Monday, June 28, 2004 9:58 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] UniObject Problem Hi, A similar problem, if the recent conversion included upgrading TO AIX 5.1. We also had VERY high paging faults. We actually found that there is an issue with AIX 5.1 itself being very slow, and that was fixed by installing Machine Level 04. I'm not sure if that's the most current machine level at this point, but I know it fixed our system (running Unidata). Check IBM's website for Machine Level downloads. Good luck! - Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin Vezertzis Sent: Monday, June 28, 2004 9:30 AM To: [EMAIL PROTECTED] Subject: [U2] UniObject Problem We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObject Problem
Please disregard the previous email.this is the question that was intended. Hello all, Has anyone had experience or problems interfacing UniObjects directly to .ASP? We are seeing errors when two simultaneous users are making requests to the database. Thanks, Kevin [demime 1.01d removed an attachment of type text/x-vcard which had a name of Kevin Vezertzis ([EMAIL PROTECTED]).vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObject Problem
What kind of /tmp, or /temp file system space do you have? How much disk space for it, and is it striped across multiple spindles? How much memory? How much swap space? Should be AT LEAST 2X physical memory, (more if you got it). What is your current uvconfig parameters? How long has this system been installed? How is your file sizing? Tell us specific configuration of your Disks, and any RAID that may be in use? How many disk drives and their sizes? What is the Disk IO Block size on this system? Any striping? if so, what interleave factor? Tell us about the application - what is it- what does it do and how does it do it? How many users are there, and what mix of them are doing what types of things within the application throughout the day? Is there a VAR involved? If so, who, and what do they say? Who installed configured the system and did the conversion? Everyone using unique AIX login names/id's? What specifc revisions of AIX, including specific patch levels? - Original Message - From: Kevin Vezertzis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 28, 2004 9:30 AM Subject: [U2] UniObject Problem We are looking for some insight from anyone that has experienced performance degradation in UV, as it relates to the OS. We are running UV 10.0.14 on AIX 5.1.we are having terrible 'latency' within the application. This is a recent conversion from D3 to UV and our client is extremely disappointed with the performance. We've had IBM hardware support and Universe support in on the box, but to no avail..we are seeing high paging faults and very highly utilized disk space. Any thoughts or suggestions? Thanks, Kevin --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
Kevin Vezertzis wrote: Has anyone had experience or problems interfacing UniObjects directly to .ASP? We are seeing errors when two simultaneous users are making requests to the database. I believe this is a known issue, check the archives for more info. Here's the first thread I turned up, although I'm not sure whether it refers to the exact setup you're using: http://www.indexinfocus.com/dl/u2list/200402/61668.html -- Wendy Smoak Application Systems Analyst, Sr. ASU IA Information Resources Management --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObject Problem
In a message dated 6/28/2004 9:50:56 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: UniObjects is not thread safe (Will be hopefully with the .NET version that comes out any day now). The connections cross. What exactly does this mean? Are you saying that if two people are using UniObjects to manipulate two different records that perhaps the result will be each record gets writen to the place the other one was supposed to be ? Or what? Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
I developed a connection pooling mechanism. This helps with the scalability concerns. I'm talking java now. I simply found a textbook version using Oracle JDBC connections. It was fairly straight forward to customize it to handle Unisessions instead. I do a couple of extra things when checking a connection back into a pool, such as clearing select lists etc. I also use Named Common on the Universe side to hold file variables. When checking out a connection, I do an ICONV to make sure the connection is still alive. It works very well! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 1:52 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniObject Problem This is exactly the methodology I use and we've yet to have a problem...Call to COM object, object opens connection, gets data, closes connection. I wouldn't recommend this methodology in an environment where you were dealing with a large number of simultaneous users or transactions, but we've load tested it up to 50 simultaneous users on a Windows 2000 server running IIS (Dual P-4 2GHz, 1.5 GB Memory) along with 100 other users pulling static html without significantly degrading resources and no problems on the UniObjects side of things. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Problem
I have done this a couple of times, but never had a problem when two user are making requests simultaneously. Sorry. Maybe if you send a sample of code you are using - we can have a look see? Regards Bjorn Behr Programmer HYFLO Southern Africa (Pty) Ltd Tel : +27 11 386 5800 Fax : +27 11 444 5391 Mail: [EMAIL PROTECTED] WWW : http://www.hyflo.co.za In the beginning, the universe was created. This made a lot of people very angry, and has been widely regarded as a bad idea. - Douglas Noel Adams (1952-2002), British author -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Vezertzis Sent: 28 June 2004 04:07 To: [EMAIL PROTECTED] Subject: [U2] UniObject Problem Please disregard the previous email.this is the question that was intended. Hello all, Has anyone had experience or problems interfacing UniObjects directly to .ASP? We are seeing errors when two simultaneous users are making requests to the database. Thanks, Kevin [demime 1.01d removed an attachment of type text/x-vcard which had a name of Kevin Vezertzis ([EMAIL PROTECTED]).vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
