Re: [U2] Unidata 6.1 Replication
Kevin, I would not use replication for U2 for 6x. I was given the mandate to use then IBM replication at a company I used to work for, and it didn't work. It wasn't on problem, but a whole hosts of problem. I set up two test boxes four different times and tested it. The 4th time I had 30 people from then IT staff (I was part of the staff then) hammer on it. Then we went live. It worked for 4 days then crashed the whole system. Then it worked for a few hours. Then, it kept crashing (hanging the servers). We had to pull it out. We were on Unidata, but it's the same code base. I can only say that if you want to go ahead with it, find someone who's using it successfully, and find out what environment they're in, version, ect. It's based on Unix and has different issues on different O/Ss. But, personally, I'd try RFS first, or write your own. That's what we ended up doing. And it worked. We used triggers and hammered the system 24/7. There were some issues, but we worked them all out, and we're able to process millions of transactions per day. What we ended up doing is finding all the weak spots in Unidata and avoiding them. The biggest weak spot was locks. The system couldn't hanldle the million+ locks per day. I went to double buffering, avoiding locks (an old GUI technique!). Also, I had to convert types of records to hex, and the UD hex conversion is slow. It's amazing what works in UD and scales, and what doesn't. To write one's own takes time and is expensive. I think that using mirrored drives is better!!! RFS??? Brad - Original Message - From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 08, 2009 12:22 PM Subject: [U2] Unidata 6.1 Replication Is replication solid and functional in Unidata 6,1? Anyone using it with roaring success? -Kevin http://www.PrecisOnline.com ___ 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
Re: [U2] Unidata 6.1 Replication
We are using Double-Take to replicate. --- On Wed, 12/9/09, BraDav broadri...@comcast.net wrote: From: BraDav broadri...@comcast.net Subject: Re: [U2] Unidata 6.1 Replication To: U2 Users List u2-users@listserver.u2ug.org Date: Wednesday, December 9, 2009, 8:33 AM Kevin, I would not use replication for U2 for 6x. I was given the mandate to use then IBM replication at a company I used to work for, and it didn't work. It wasn't on problem, but a whole hosts of problem. I set up two test boxes four different times and tested it. The 4th time I had 30 people from then IT staff (I was part of the staff then) hammer on it. Then we went live. It worked for 4 days then crashed the whole system. Then it worked for a few hours. Then, it kept crashing (hanging the servers). We had to pull it out. We were on Unidata, but it's the same code base. I can only say that if you want to go ahead with it, find someone who's using it successfully, and find out what environment they're in, version, ect. It's based on Unix and has different issues on different O/Ss. But, personally, I'd try RFS first, or write your own. That's what we ended up doing. And it worked. We used triggers and hammered the system 24/7. There were some issues, but we worked them all out, and we're able to process millions of transactions per day. What we ended up doing is finding all the weak spots in Unidata and avoiding them. The biggest weak spot was locks. The system couldn't hanldle the million+ locks per day. I went to double buffering, avoiding locks (an old GUI technique!). Also, I had to convert types of records to hex, and the UD hex conversion is slow. It's amazing what works in UD and scales, and what doesn't. To write one's own takes time and is expensive. I think that using mirrored drives is better!!! RFS??? Brad - Original Message - From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, December 08, 2009 12:22 PM Subject: [U2] Unidata 6.1 Replication Is replication solid and functional in Unidata 6,1? Anyone using it with roaring success? -Kevin http://www.PrecisOnline.com ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 Replication
Replication is QUITE useful at 7.1.20 and later I know -- we have lots of people using it now! Before this time, it had issues with large records, multiple overwrites one the same key, etc. At 7.1.20 they also improved the monitoring. Don't bother at less than 7.1.20 IMHO David W. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 Replication
Doubletake is an O/S answer -- but you cannot use the 'DoubleTake' data to host a reporting server, can you? UniData Replication is great for being able to have the database in two places at once with for either backup, hot spare, or 'query only' access. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Address Sent: Wednesday, December 09, 2009 8:33 AM To: U2 Users List Subject: Re: [U2] Unidata 6.1 Replication We are using Double-Take to replicate. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobject.NET -Unable to load subroutine
This may be a total red herring, but I would try setting both subroutine arguments to something, not just the first one - even if you only set them to String.Empty. How is the subroutine catalogued BTW? As for your connection pooling issue - Make sure you are: 1. using a UniObjects DLL that supports pooled connections 2. are connecting to a version of UniData/UniVerse that supports pooled connections 3. connecting to a server that is licensed for pooled connections.. HTH Ray -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leimer, Thomas (SVW) Sent: 08 December 2009 21:10 To: u2-users@listserver.u2ug.org Subject: [U2] Uniobject.NET -Unable to load subroutine I'm getting the error Unable to load the subroutine on the server The subroutine is compiled and cataloged. Also, I had to comment out the 'UniObjects.UOPooling = True, 'UniObjects.MaxPoolSize = 2, and'UniObjects.MinPoolSize = 1 in order to get a connection. Could having this commented out be causing the load subroutine error? Thank you, Tom WebMethod() _ Public Function last_chance(ByVal strRSA As String) As String Dim u2Session As UniSession = Nothing Dim rtnMessage As String = String.Empty Dim u2Sub As UniSubroutine 'UniObjects.UOPooling = True 'UniObjects.MaxPoolSize = 2 'UniObjects.MinPoolSize = 1 Try u2Session = UniObjects.OpenSession(HOST, USERNAME, PASSWORD, ACCOUNT, udcs) Try u2Sub = u2Session.CreateUniSubroutine(AUTO.RSA.SCAN.CHK, 2) u2Sub.SetArg(0, strRSA) u2Sub.Call() rtnMessage = u2Sub.GetArg(1) Catch ex As Exception rtnMessage = ERROR - In call to sub - ex.ToString Finally u2Sub = Nothing UniObjects.CloseSession(u2Session) End Try Catch ex As Exception rtnMessage = ERROR - ex.ToString Finally u2Session = Nothing End Try Return rtnMessage End Function Tom Confidentiality Notice: This message, together with any attachments, is intended only for the use of the individual or entity to which it is addressed and may contain confidential or privileged information. If you think you have received this message in error, please advise the sender and then delete this message and any attachments immediately. ___ 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
Re: [U2] Unidata 6.1 Replication
Awesome, great feedback my friends. Appreciate it very much. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] BCI Connectivity
I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 BASIC SQL Client Interface Guide but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in LOGTO UV uv are unClear. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] BCI Connectivity
which user did you install Universe as. They become the user with SQL DBA rights. Check the UV_USERS file which is documented in the SQL Catalog section of the SQLREF guide root needs DBAuth permission to be in this file. Hope this guides you down the right path in resolving and understanding the SQL user setup Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Wednesday, December 09, 2009 3:58 PM To: U2 Users List Subject: Re: [U2] [UV] BCI Connectivity I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 BASIC SQL Client Interface Guide but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in LOGTO UV uv are unClear. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Removehttps://asp-6.reflexion.net/FooterAction?ver=1un-wl-sender-address=1rID=46755898aID=60327323 this sender from my allow list You received this message because the sender is on your allow list. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
You need to change the the READ parameter in the HS_FILE_ACCESS record for the UV file to READ_WRITE, then run HS.UPDATE.FILEINFO in that file's account. At that point a SQL insert to the file from the windows side should be allowed. See the UV ODBC guide for more detailed info. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, December 01, 2009 1:09 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ 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