Re: [U2] Unidata 6.1 Replication
Someone needs to write an i/o agent, so U2 can be used with products like Double-Take and keep record level integrity. Anyone with c++ experience out there? - Original Message - From: "Address" To: "U2 Users List" Sent: Wednesday, December 09, 2009 9:33 AM Subject: Re: [U2] Unidata 6.1 Replication We are using Double-Take to replicate. --- On Wed, 12/9/09, BraDav wrote: From: BraDav Subject: Re: [U2] Unidata 6.1 Replication To: "U2 Users List" 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" To: "U2 Users List" 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 Replication
For redundancy, it's hard to beat triple mirrored drives on a SAN, with RFS on a 4th i/o channel. You break the mirror between drives 2 & 3, and then drive 1 & 2 remain mirrored. Back up off #3. When finished, reestablish the mirror between 2&3. RFS can be then write to 2 drives with a 0,1 configuration sequentially - which is fast. However, RFS can take 25% to 50% of resources, so have a fast box!!! - Original Message - From: "David Wolverton " To: "'U2 Users List'" Sent: Wednesday, December 09, 2009 12:25 PM Subject: 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 Replication
Dave, That's good to hear: went thu lots of pain with replication at last place. However, can it be restarted after a crash, or does it keep enough data in the pipe to recover and start replicating again? thanks, Brad - Original Message - From: "David Wolverton " To: "'U2 Users List'" Sent: Wednesday, December 09, 2009 12:23 PM Subject: 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RECORDLOCKED statement
Assign the result to a variable: that reduces the i/o to the lock manager by 60%+ Brad - Original Message - From: "Gregor Scott" To: "'U2 Users List'" Sent: Tuesday, December 15, 2009 8:39 PM Subject: Re: [U2] RECORDLOCKED statement The other consideration is that each case statement uses the same RECORDLOCKED(PICH.TX, SO) function reference, meaning it runs the function 3 times (according to your snippet). I would normally assign the function result to a variable and test the variable in the case statements: stat.LOCK = RECORDLOCKED(PICH.TX, SO) CASE stat.LOCK = CASE stat.LOCK = ... Gregor Scott -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of raul_doming...@neimanmarcus.com Sent: Wednesday, 16 December 2009 10:27 AM To: U2 Users List Subject: Re: [U2] RECORDLOCKED statement The only consideration is that your second case statement picks up at -2 instead of -1. I think you are going for CASE RECORDLOCKED(PICH.TX, SO) <= LOCK$OTHER.READL which is the -1 return value. At least according to the UniVerse documentation. Regards, Raul Dominguez raul_doming...@neimanmarcus.com 972-401-6502 Baker Hughes Sent by: u2-users-boun...@listserver.u2ug.org 12/15/2009 05:17 PM Please respond to U2 Users List To 'U2 Users List' cc Subject [U2] RECORDLOCKED statement I admit I have never used this little jewel of a [UV] statement, so although the code runs and works as designed, before I load it to production, someone please tell me if there are any nuances that would improve the design/operation. CASE RECORDLOCKED(PICH.TX, SO) >= LOCK$MY.READU * This user/process already has a lock on the record, and we DO NOT * WANT to clear the lock if process is ORDER.UPDATE so check the stack. IF INDEX(SYSTEM(9001),"ORDER.UPDATE",1) THEN WRITEVU "" ON PICH.TX, SO, 37 END ELSE WRITEV "" ON PICH.TX, SO, 37 RELEASE PICH.TX, SO END CLEARED.CCA.HOLD = TRUE CASE RECORDLOCKED(PICH.TX, SO) <= LOCK$OTHER.READU * Another User has the record locked, we cannot update at this time ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR CASE RECORDLOCKED(PICH.TX, SO) = LOCK$NO.LOCK * There is no lock on this record presently, free and clear READVU HOLD.RSN FROM PICH.TX, SO, 37 LOCKED * ...but that could change in 1 ms so still handle the locked condition. ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR RELEASE PICH.TX, SO END THEN WRITEV "" ON PICH.TX, SO, 37 CLEARED.CCA.HOLD = TRUE END CASE Thank you. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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 -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1yT6IW24xN/50V5hqHqZ3Up5ajJTQzChu/3 ___ 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
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" To: "U2 Users List" 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 - TANDEM verb
Dave, I didn't know they had it. Most people I know set up webinars to see the other person's PC. Also, Microsoft has office communicator, which has session sharing! Brad - Original Message - From: "David Wolverton " To: "'U2 Users List'" Sent: Thursday, December 03, 2009 12:35 PM Subject: [U2] UniData - TANDEM verb Does someone know offhand when TANDEM was added to UniData under Windows? I have a site that I need that function, but they say 'TANDEM' just returns a 'verb?' response. Thanks! David W. ___ 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] OT: Have a Good Thanksgiving
Same to everyone... - Original Message - From: "Karl Pearson" To: Sent: Thursday, November 26, 2009 2:09 AM Subject: [U2] OT: Have a Good Thanksgiving Just wishing all of you a great Thanksgiving. --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ 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] Where do print/crt statements go when using UniObjects?
Don't know if this helps, but always program the following way with UniObjects: PROGRAM *stuff STOP SUBROUTINE *stuff RETURN - Original Message - From: "Kate Stanton" To: "U2 Users List" Sent: Tuesday, November 24, 2009 9:47 PM Subject: Re: [U2] Where do print/crt statements go when using UniObjects? More of a worry: what happens if a subroutine has an INPUT statement (eg trying to update a locked record, and asking user to get it released). Execute comes back with a status of "waiting for input", but subroutine never comes back. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: "Ben Souther" To: Sent: Wednesday, November 25, 2009 11:25 AM Subject: [U2] Where do print/crt statements go when using UniObjects? Until now we've been using Redback for communicating with Unidata from our Java apps. I've just started playing around with UOJ and can't seem to find in the manual, what log (if any) the print/crt statements go. -- Ben Souther Manager, Web and Web Service Development bsout...@fwdco.com | 508.927.8147 FWDavison & Company, Inc. 10 Cordage Park Circle, Suite 200 Plymouth, MA 02360-7318 CONFIDENTIALITY NOTICE: This e-mail message, and any accompanying documents, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, distribution or copying is prohibited. If you are not the intended recipient, please contact our office by e-mail or by telephone at (508) 747-7261 and immediately destroy all copies of the original message. ___ 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 - Key Stucture - Compound Keys or Sequetial
Not in this case, but when I converted the file to a test file using sequential ids (same exact data pushed down 10 positions and putting the original key in the first field) I had no issues with the date select. It was as fast as 14ms on a cached index, which tells me the issue is the size of the keys. I did 2 selects for each file, 2x. Interesting, it's intuitive to think that the cached data would even things out, but it didn't. Once the selects were in memory, I got another 10x performance increase with sequential keys (200x to 2000x better). It must be some kind of overflow condition. Nothing I tried worked. It's an internal issue with UD. Note: this senario gets worse, the less resource the system has. It was probably a 10,000x+ difference or more at one time. We had 2 runaway processes on the system and it taking 10-15minutes to select 2 days difference. We fixed those and got the #s above... - Original Message - From: "Brian Whitehorn" To: "'U2 Users List'" Sent: Wednesday, November 18, 2009 11:10 PM Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial Have you defined NO.NULLS on the DATE field index? The condition less than equal to will be catering for "" or Null as being less than 0, whereas the SELECTINDEX in the program version will be using Date values (hence missing the less than equals part. $0.02, HTH. Cheers, Brian. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Thursday, 19 November 2009 3:02 PM To: U2 Users List Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial I do not know what is causing the peformance problem with Unidata and indexed fields, using large key. In the case of this particular file, there are translated fields that have to be built separately from the other 'D' type fields. The field in questions, that I was selecting on, was a date field. The date range was one day. What I ended up doing was a for/next loop selecting on each day in the date range. Dates in this file are fairly densly used, so there are not that many days that have no data. Regardless, the direct select is much faster than the date range. This is very fast code in Unidata: SUBROUTINE SELECT.DATE.RANGE(START,LAST,FILE) DATELIST="" FOR DATE=START TO LAST SELECTINDEX "DATE",DATE FROM FILE TO 1 READLIST LIST FROM 1ELSE LIST ="" IF LIST ELSE CONTINUE DATE.LIST<-1>=LIST NEXT FORMLIST LIST TO 0 RETURN However, I would prefer to do this: SELECT FILE WITH DATE >= 'START' AND DATE <= 'LAST' - Original Message - From: "Brian Leach" To: "'U2 Users List'" Sent: Sunday, November 08, 2009 8:37 AM Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial Hi Brad Interesting, but I wonder about another possibility.. As a partial field the select would be using an I-Descriptor or V-Descriptor. I wonder whether the overhead on that is the problem: if you crated a V-Type to access the date field in the new file (e.g. using EXTRACT(fieldname,0,0) ) would that show the same difference in performance, rather than the data structure? Just wondering.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: 07 November 2009 20:10 To: U2 Users List Subject: [U2] Unidata - Key Stucture - Compound Keys or Sequetial Subject: Keys, Large Transaction Files, Just recently ran into an interesting phenomenon - I was working with a file with compound keys and the selects over a date range were atrocious. I copy the data to a new file, using sequential keys and the selects averages 200-2000X faster (for the doubters, I have to say is the actual # were something like 197X to 2070x, the second # being as second select after the data was cached). The avg length of key on the file was 32 characters. The avg length of a sequential keys was about 5 characters. The fields was a 'date' field. The field was indexed. The range of the select was 2 days. It seems there's a Unidata threshold large key sizes exceed with indexing that kills peformance. Also, sequential keys hash the best. I managed a file with 80M records at another site and had no problems with file sizing or overflow. Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.698 / Virus Database: 270.14.55/2489 - Release Date: 11/08/09 07:37:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman
Re: [U2] [UV] Where is the COMMON block reserved ?
The common block is always the same memory space: com a(100) is the same as com a(50),b(50) that's why they have labeled common com /label/ c(10) The same common blocks share the same memory space. It depends on the # of elements in the block. com /urcom/ c(10) is the same as com /urcom/ a(5),b(5) or com /urcom/ a,b,c,d,e,f,g,h,i,j where j = b(5) or c(10), and i = c(9) or b(4) - Original Message - From: "Jacques G." To: "U2 Users List" Sent: Thursday, November 19, 2009 3:01 PM Subject: Re: [U2] [UV] Where is the COMMON block reserved ? Hello, I have a question pertaining to how the shell used by the connection pooling works as it relates to memory allocation. In the following cases: Case 1: Program 1 has a number of variables and matrixes declared in a common section it calls Program 2 which has the same common matrixes and variables declared. Ex: Program 1: COM ABC(100), D,E,F ARG = "BLAH" CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN Case 2: Program1 doesn't have any common variables declared it calls Program2 which does have common matrixes and variables declared: Program 1: ARG = "BLAH" CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN In Case 2, is the common block declared in the stack segment or will the common be declared in the same place in both cases ? ___ 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 - Key Stucture - Compound Keys or Sequetial
I do not know what is causing the peformance problem with Unidata and indexed fields, using large key. In the case of this particular file, there are translated fields that have to be built separately from the other 'D' type fields. The field in questions, that I was selecting on, was a date field. The date range was one day. What I ended up doing was a for/next loop selecting on each day in the date range. Dates in this file are fairly densly used, so there are not that many days that have no data. Regardless, the direct select is much faster than the date range. This is very fast code in Unidata: SUBROUTINE SELECT.DATE.RANGE(START,LAST,FILE) DATELIST="" FOR DATE=START TO LAST SELECTINDEX "DATE",DATE FROM FILE TO 1 READLIST LIST FROM 1ELSE LIST ="" IF LIST ELSE CONTINUE DATE.LIST<-1>=LIST NEXT FORMLIST LIST TO 0 RETURN However, I would prefer to do this: SELECT FILE WITH DATE >= 'START' AND DATE <= 'LAST' - Original Message - From: "Brian Leach" To: "'U2 Users List'" Sent: Sunday, November 08, 2009 8:37 AM Subject: Re: [U2] Unidata - Key Stucture - Compound Keys or Sequetial Hi Brad Interesting, but I wonder about another possibility.. As a partial field the select would be using an I-Descriptor or V-Descriptor. I wonder whether the overhead on that is the problem: if you crated a V-Type to access the date field in the new file (e.g. using EXTRACT(fieldname,0,0) ) would that show the same difference in performance, rather than the data structure? Just wondering.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: 07 November 2009 20:10 To: U2 Users List Subject: [U2] Unidata - Key Stucture - Compound Keys or Sequetial Subject: Keys, Large Transaction Files, Just recently ran into an interesting phenomenon - I was working with a file with compound keys and the selects over a date range were atrocious. I copy the data to a new file, using sequential keys and the selects averages 200-2000X faster (for the doubters, I have to say is the actual # were something like 197X to 2070x, the second # being as second select after the data was cached). The avg length of key on the file was 32 characters. The avg length of a sequential keys was about 5 characters. The fields was a 'date' field. The field was indexed. The range of the select was 2 days. It seems there's a Unidata threshold large key sizes exceed with indexing that kills peformance. Also, sequential keys hash the best. I managed a file with 80M records at another site and had no problems with file sizing or overflow. Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.698 / Virus Database: 270.14.55/2489 - Release Date: 11/08/09 07:37:00 ___ 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 odd error
Jeff, I have a question for you. Why are you moving to RedHat from Solaris? Do you think that Redhat is a better o/s? Thanks, Brad - Original Message - From: "Jeffrey Butera" To: "Wally Terhune" Cc: "U2 Users List" Sent: Saturday, November 14, 2009 10:58 AM Subject: Re: [U2] Unidata odd error Thanks Wally - that sounds right since this is a repurposed account in which I did unmount and remount the filesystem yesterday. We'll be moving from solaris 7.1.8 to RedHat 7.2.x shortly so it's no big deal in the long run. I worked around the problem anyway. Sent from my iPhone Jeff Butera jbut...@hampshire.edu On Nov 14, 2009, at 10:02 AM, Wally Terhune wrote: I wonder if this may apply - fixed at 7.1.9 (from the latest 7.1.x readme) The first entry for that device ID will be the one the udt process is checking for available space and may not be the file system you expect. Issue 9209 - Problem Description UniData -- The smm daemon maintains a table in shared memory that lists available file systems and the space available in each file system. You can view the table using the sms -F command. Prior to this release, if a new file system was mounted, a new entry was added to the table. Entries were not removed when a file system was unmounted. This may have resulted in entries in the table for two different mount paths that had the same ID. The problem has been fixed. Wally Terhune U2 Support Architect Rocket Software Tel: (720) 475-8055 Mobile: (303) 807-6222 wterh...@rocketsoftware.com u2supp...@rocketsoftware.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] Unidata - Key Stucture - Compound Keys or Sequetial
Subject: Keys, Large Transaction Files, Just recently ran into an interesting phenomenon - I was working with a file with compound keys and the selects over a date range were atrocious. I copy the data to a new file, using sequential keys and the selects averages 200-2000X faster (for the doubters, I have to say is the actual # were something like 197X to 2070x, the second # being as second select after the data was cached). The avg length of key on the file was 32 characters. The avg length of a sequential keys was about 5 characters. The fields was a 'date' field. The field was indexed. The range of the select was 2 days. It seems there's a Unidata threshold large key sizes exceed with indexing that kills peformance. Also, sequential keys hash the best. I managed a file with 80M records at another site and had no problems with file sizing or overflow. Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
Charlie, I agree with you overall that U2 (Unidata and Universe) is the best there is for development and maintaining applications. The data model stands head and shoulders above the rest, when it comes to RAD. However, there could be many improvements to the dbs, above and "below the hood" so to speak. That being said, one of the benefits of the U2 architecture is that it "can" be improved. For example, I maintained a file with 80 million records, at one site. It has virtually no overflow and the record distribution was nearly perfect. Access to the file was very fast, but we couldn't create indexes on it, because the indexes ran out of space. That's just one example, but the list is long. However, that's a positive. With the right amount of R&D, U2 is positioned for another 20 year run. thanks, Brad - Original Message - From: "Charlie Noah" To: "U2 Users List" Sent: Sunday, October 11, 2009 11:35 AM Subject: Re: [U2] U2 is now Rocket U2 Now, Rob, wait a minute... also having over 30 years experience in the MV world, I have watched the "progression" from LP to tape to CD to digital (iPod, etc.), the real advances from kilobytes of memory to gigabytes, from megabytes of disk to terabytes, and from kilohertz of CPU speed to gigahertz. Audiophiles are discovered what I have always believed: the richness of sound of the old vinyl LP can't be matched by today's digital music, and the LP is enjoying a much deserved return to glory. I'm glad I didn't get rid of my vinyl collection, although, like me, it is showing its age. I wish Rocket all the best. I hope they understand what they really have. Although I work with Jbase now, I have spent many enjoyable years working with both Universe and Unidata, and they, like all the other MV environments I've worked with, make our jobs easy and fun. I've tried other environments over the years, and have always concluded that I already had the best the computer world had to offer, so why should I use something else not nearly as powerful? It may have been around for many years, but it's ability to adapt to and work with the most modern of technologies keeps it fresh, flexible and strong. I just wish the rest of the world could see it. Best Regards, Charlie Noah On 10/9/2009 8:24 AM, Smith, Robert wrote: At some point, we will hopefully evolve beyond the "old = undesirable" mentality that is pervasive in our society, and once again appreciate the imagery that "old" things can evoke. As a technician with over thirty years experience, I have thoroughly enjoyed the journey I have witnessed since the days of the LP Player...to the iPod of today. What we largely lack today is a sense of history relative to what it has taken for us to progress to this point...and the imagination to achieve even more phenomenal accomplishments in the future. Where once our thoughts were expansive and limitless, they are now reserved and pedestrian. If someone with a sense of history and a determination to use "Rocket" as a means to evoke the imagery of a time when we thought in grander scales...then they were sadly mistaken. The company should seriously consider changing its name, otherwise they will be the butt of many a jokes. My two cents Rob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti Sent: Friday, October 09, 2009 5:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 is now Rocket U2 IBM is very sixties also. Have you ever been to the Apollo space centre? All the computers were IBM and the IBM logo is splashed all around the control room. So I think if you're thinking retro then IBM sits there right along side Sputnik et al. Jacques G. wrote: I wonder what is the marketing idea behind the name "Rocket" ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed "Maurice The Rocket Richard" and people watched "Flash Gordon" on a black and white television. When I hear Rocket I think "retro" like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term "Rocketship" in decades. Jacques ___ 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] U2 is now Rocket U2
Actually, I like U2. It short, to the point, and easy to remember. And it's got a popular association. However, if there is a name change, it would have to be a great alternative. - Original Message - From: "jpb-u2ug" To: "'U2 Users List'" Sent: Friday, October 09, 2009 4:23 PM Subject: Re: [U2] U2 is now Rocket U2 This all depends, if I am reading it correctly, their other products are being advertised until their original names and Rocket is more in the background. So they may advertise the U2 products under a completely different name. What would you like the name to be? Maybe Rocket would like some input on this point. After all we created the term U2 and IBM adopted it. Now, I think we should drop the U2 brand, since a lot of people think we are talking about the rock group, for a more 21st century name. Also we have got to stop calling them Pick databases. Multi-dimensional, multi-valued and extended relational are okay but maybe we can come up with a more futuristic name than that. How about Rocket or the users group starting up a contest to name the new division? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Smith, Robert Sent: Friday, October 09, 2009 8:24 AM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 At some point, we will hopefully evolve beyond the "old = undesirable" mentality that is pervasive in our society, and once again appreciate the imagery that "old" things can evoke. As a technician with over thirty years experience, I have thoroughly enjoyed the journey I have witnessed since the days of the LP Player...to the iPod of today. What we largely lack today is a sense of history relative to what it has taken for us to progress to this point...and the imagination to achieve even more phenomenal accomplishments in the future. Where once our thoughts were expansive and limitless, they are now reserved and pedestrian. If someone with a sense of history and a determination to use "Rocket" as a means to evoke the imagery of a time when we thought in grander scales...then they were sadly mistaken. The company should seriously consider changing its name, otherwise they will be the butt of many a jokes. My two cents Rob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti Sent: Friday, October 09, 2009 5:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 is now Rocket U2 IBM is very sixties also. Have you ever been to the Apollo space centre? All the computers were IBM and the IBM logo is splashed all around the control room. So I think if you're thinking retro then IBM sits there right along side Sputnik et al. Jacques G. wrote: I wonder what is the marketing idea behind the name "Rocket" ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed "Maurice The Rocket Richard" and people watched "Flash Gordon" on a black and white television. When I hear Rocket I think "retro" like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term "Rocketship" in decades. Jacques ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/U2-is-now-Rocket-U2-tp25693358p25817827.html Sent from the U2 - Users mailing list archive at Nabble.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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
Rob, The only thing that U2 has missed over the last few years has been sufficient development resources to bring its various processes up-to-date. IBM was not reinvesting in U2 heavily, it was a cash-cow for them. What we need is what Rocket software is talking about: investment in the technology... SQL was invented in the earlt 70's!! Brad - Original Message - From: "Jo Lester" To: Sent: Friday, October 09, 2009 4:28 PM Subject: Re: [U2] U2 is now Rocket U2 We can be called retro-rockets! From: smi...@philau.edu To: u2-users@listserver.u2ug.org Date: Fri, 9 Oct 2009 09:24:18 -0400 Subject: Re: [U2] U2 is now Rocket U2 At some point, we will hopefully evolve beyond the "old = undesirable" mentality that is pervasive in our society, and once again appreciate the imagery that "old" things can evoke. As a technician with over thirty years experience, I have thoroughly enjoyed the journey I have witnessed since the days of the LP Player...to the iPod of today. What we largely lack today is a sense of history relative to what it has taken for us to progress to this point...and the imagination to achieve even more phenomenal accomplishments in the future. Where once our thoughts were expansive and limitless, they are now reserved and pedestrian. If someone with a sense of history and a determination to use "Rocket" as a means to evoke the imagery of a time when we thought in grander scales...then they were sadly mistaken. The company should seriously consider changing its name, otherwise they will be the butt of many a jokes. My two cents Rob _ Hotmail: Powerful Free email with security by Microsoft. http://clk.atdmt.com/GBL/go/171222986/direct/01/ ___ 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] hpux to linux
Karl, Quotes are funny! Only Benjamin Franklin wanted the turkey to be the national bird! I prefer the Eagle: a majestic bird of their ever was one. Brad --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] hpux to linux
Harold , If you're moving from Linux to Unix, I would check out Stratus computers. They're fault-tolerant Linux machines, running Redhat, with a long heritage from the 80's (with their own operating system). Their claim to fame is 99. % uptime or something ridiculously reliable like that... Brad Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- "To mess up your Linux PC, you have to really work We have Rocket's Universe 10.2 over hpux 11.11 but are considering moving to a linux box. Has anyone ported a U2 app from hpux to linux? I am trying to estimate for management how long such a porting might take. Just an opinion would be helpful, like 'easy', 'medium', 'hard', 'really hard'. Thanks- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- "To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it." --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ 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] Anybody familiar with Storis software?
Storis makes their own front end. They have their own client/server interface. You'd have to learn their system. - Original Message - From: "Steve Kunzman" To: Sent: Wednesday, October 07, 2009 2:16 PM Subject: [U2] Anybody familiar with Storis software? I have been talking to a company about some programming work. They are running a software package called Storis. Is the source code included with this software? What is the GUI front end written in (Revision 8.5)? Thank you. ___ 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] @NV or @VALUE.COUNT
Does anyone know how to use @NV or @VALUE.COUNT in a dictionary, thanks, Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Software + U2
They are working on the web page. They said the U2 page would be ready when the sale is completed. - Original Message - From: "Israel, John R." To: "U2 Users List" Sent: Wednesday, September 30, 2009 8:43 AM Subject: Re: [U2] Rocket Software + U2 Link did not work. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, September 29, 2009 8:34 PM To: U2 Users List Subject: [U2] Rocket Software + U2 Webinar today with Rocket Software. Very postitive outlook for U2. Looks like their the "right-size" player to help grow the U2 market space For more information, please visit http://www.rocketsoftware.com/u2. ___ 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] Locking records in host subroutine w/uniobjects
You can try and use a user defined lock, that only releases when you tell it to -- one way to do this is to have a file called locks or something and write the file*id's that are being locked (delete the ones that are not locked). The tables should have some sort of id in record<1> that tells it who is doing the locking, so they can do the unlocking. Have a read and write subroutine that obeys the locks. The downside is that all process that access these records will have to respect the user defined locks. The the custom.read/write program will have to be applied to all the process that use the files. If UniObjects is being used for the web only, or for a particular purpose, one thing you can do is have a series of transactions files that gather data (all using the locks) and batch update the db tables for the rest fo the application. Brad - Original Message - From: "ack_9_ball" To: Sent: Tuesday, September 29, 2009 2:53 PM Subject: [U2] Locking records in host subroutine w/uniobjects Is there a way to keep records locked between calls to a host subroutine using uniobjects? From what I can tell once the subroutine finishes the first time the lock goes away. -- View this message in context: http://www.nabble.com/Locking-records-in-host-subroutine-w-uniobjects-tp25668748p25668748.html Sent from the U2 - Users mailing list archive at Nabble.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] Rocket Software + U2
Webinar today with Rocket Software. Very postitive outlook for U2. Looks like their the "right-size" player to help grow the U2 market space For more information, please visit http://www.rocketsoftware.com/u2. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Start Phantom in Another Account?
I know someone who is working on a solution to that problem in Java and C#, and it may ready in a few months... interesting... - Original Message - From: "Kevin King" To: "U2 Users List" Sent: Tuesday, September 22, 2009 12:49 PM Subject: Re: [U2] Start Phantom in Another Account? My apologies for the confusion on the Windows issue. The issue I am facing is actually on AIX but I am trying to figure out the differences between Windows and AIX to try to come up with a more generic (i.e. not hardcoded to the OS) solution. This has all been good information; appreciate it everyone! ___ 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] Worst Case/Best Case
"Without vision a people perish..." - Original Message - From: "Brian Leach" To: "'U2 Users List'" Sent: Tuesday, September 22, 2009 4:37 AM Subject: Re: [U2] Worst Case/Best Case What we really need in the U2 world is constant innovation, a new, modern development platform, or several, >the ability to use and interface to the Windows world with all it's wonderful tool sets. We just need some visionary injection into our world... Now I'm confused. What part of 'interface to the Windows world' can't you do with UniVerse? It has UO.net - which is cleaner and faster than any other DB interface I've used - ADO.net, OleDB, ODBC, Web Services, nacent support for Entity Framework (though what will happen to the ADO.NET provider following the sale is up in the air) .. The only thing it really lacks is a good native mode PHP provider. Calling Basic subroutines from any of these is no harder than calling SQL stored procedures. Of course, SQL Server has an excellent development tool - it's called Visual Studio. So does UniVerse - it's called Visual Studio. You don't get as many wizards when using UniVerse, but then if you're doing any real development against SQL Server you will ignore the wizards anyway.. Oh, and back tracking a little, UniVerse does support referential integrity if you define your files as SQL tables. It has the same CASCADE option found on other RDBMS. Just 'cos people don't use it, don't mean it ain't there. Brian ___ 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] Worst Case/Best Case
Laura, Most people would agree that mySQL is a relational database. What many people don't probably relaize is the underlying datastore is not-fixed. mySQL can use any of a number of db's to do it's I/O, and relational datastore. mySQL is a relational interface or layer to true db's data stores. They even now have their own. Wait? What's the difference? Free! Free! Free! SQL! SQL! SQL! Have you ever heard of EDA? Unidata/Universe can be middleware to many db's. Take this psuedo diagram: Unidata/Hashed Tables -- mySQL - db's? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users