Re: [U2] Limitations of uvrestore
Hi group, I'm using uvbackup/uvrestore as the system to backup uv accounts. Imho the only tool to perform : - a uvdb backup with binary level db integrity. - a cross plateform compatible backup We perform account level uvbackup sent to a local file (uvbackup accountfile.uvb). I can't talk about block sizes impact. About perf, I use the option -limit set to 1 ; then uvbackup don't start two process (reader/writer) this is really more quick. I know a problem with Type1 files when uvbackup from unix and uvrestore on windows. uvrestore 'restore' dir and subs-dir on windows like prepared on unix but uvwindows don't respect Type1 subs dir ... You must resize Type1 to Type19 on uvunix before uvbackup and uvrestore on uvwin. My 2 pence manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Gregor Scott Envoyé : mardi 3 mai 2011 04:13 À : U2 Users List Objet : [U2] Limitations of uvrestore I have just finished some testing of uvbackup and uvrestore on AIX and Linux to see if there are areas to improve performance. The results were interesting, and somewhat alarming - see http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and- uvrestore/ for details. What I am interested in is: a) Do UV platforms other than AIX and Linux have similar issues with uvrestore? b) Does anyone use block sizes beyond 1mb for uvbackup and uvrestore? If so, what size and what impact does it have on backup performance? Thanks Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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] Reliability doesn't raise enough issues to keep the list busy
I am with Tony on this one, I frequent a number of .net forums, there is massive dialogue on these - not because of bugs, but because people are constantly driving forward the boundaries on what is possible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 03 May 2011 06:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy From: David Jordan It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. I feel a need to stick a pin that balloon of hot air, even if I happen to agree with it in large part, and present an equal but opposite view. :) Paraphrase: It is the problem with a dying product there are not enough creative thoughts to keep the list busy. If you had one of the competitor products there would be a ton of ideas to discuss to keep multiple forums busy. Funny how great software can look bad, because there are so few people to discuss all the wonderful ways to use it. Just trying to keep things real. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1325 / Virus Database: 1500/3610 - Release Date: 05/02/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Databasic conversion
Thanks - sounds usefull. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: 28 April 2011 20:41 To: U2 Users List Subject: Re: [U2] Databasic conversion I realize this thread is a little old, but I just came across this Rocket press release dated yesterday that might be of interest. They've released an Automated Migration Tool that may include free remote support (based on # of users migrated): http://www.dbta.com/Articles/Editorial/News-Flashes/Rocket-U2-Launches-M igration-Factory-for-Moving-Legacy-Solutions-to-U2--75174.aspx It says an app running on any other MV database qualifies as a candidate. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, April 06, 2011 2:14 PM To: 'U2 Users List' Subject: [U2] Databasic conversion Hi I am looking at a little side project to convert an entire system written in databasic on D3 to run on unidata. The guy i work with says it is a couple of hours work - I am not so sure myself. Anyone done this and know what the 'gotchyas' are ? Cheers Symeon. ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1325 / Virus Database: 1500/3602 - Release Date: 04/28/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
How a product that is growing can simultaneously be dying is a bit of a mystery. Sitting here with last quarter's sales figures for U2 in the UK I can definitely say it's not dying, they look very healthy indeed. George Land APT Solutions Ltd U2 UK Distributor On 03/05/2011 06:36, Tony Gravagno 3xk547...@sneakemail.com wrote: From: David Jordan It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. I feel a need to stick a pin that balloon of hot air, even if I happen to agree with it in large part, and present an equal but opposite view. :) Paraphrase: It is the problem with a dying product there are not enough creative thoughts to keep the list busy. If you had one of the competitor products there would be a ton of ideas to discuss to keep multiple forums busy. Funny how great software can look bad, because there are so few people to discuss all the wonderful ways to use it. Just trying to keep things real. T ___ 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] Reliability doesn't raise enough issues to keep the list busy
But surely the reason is that whilst some years ago we all did everything in U2 (or D3 or whatever) today we use a blend of technologies. So it is unlikely that you will be doing new front end development in basic, you will have adopted a .NET or java or whatever approach. You will then, I hope, be interfacing back to U2 for data storage and, to a greater or lesser extent, business logic, but you are unlikely to be trying to work out how to do massively innovative things in U2. That is a reflection of the fact the U2 is becoming more and more a database and less of a complete development environment. It's part of the evolution, when I started on a CMC/Microdata Reality the operating system, database and development environment were combined. Then the o/s bit gradually dropped away and it all became a database and development environment on unix or windows. Now, to some extent, the development environment is moving away and it is becoming a database. Arguably that is where it should have been positioned in the first place, Pick/Reality etc were never great as operating systems, as development environments they have had their day but it was always and still is as a database that the true strengths lie. George Land APT Solutions Ltd U2 UK Distributor On 03/05/2011 10:00, Symeon Breen syme...@gmail.com wrote: I am with Tony on this one, I frequent a number of .net forums, there is massive dialogue on these - not because of bugs, but because people are constantly driving forward the boundaries on what is possible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 03 May 2011 06:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy From: David Jordan It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. I feel a need to stick a pin that balloon of hot air, even if I happen to agree with it in large part, and present an equal but opposite view. :) Paraphrase: It is the problem with a dying product there are not enough creative thoughts to keep the list busy. If you had one of the competitor products there would be a ton of ideas to discuss to keep multiple forums busy. Funny how great software can look bad, because there are so few people to discuss all the wonderful ways to use it. Just trying to keep things real. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1325 / Virus Database: 1500/3610 - Release Date: 05/02/11 ___ 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] Reliability doesn't raise enough issues to keep the list busy
So maybe we all need to discuss more about the blend of technologies that we use. I am also a member of a couple of MongoDB discussion groups, Mongo is a fairly new DB, and i don't think it has the userbase of U2, yet those forums are alive with technical discussion, much of it about the interfaces from different languages into MongoDB. Then again it comes back to an older post on here - Mongo have developed interfaces to their DB for many languages, and many third party ones have followed, Rocket have a .net and a java interface, the code is closed and there are very few if any third party interfaces to say php, ruby etc. Maybe this is all linked, maybe there are just a handful of us on this group developing in a blend of technologies with U2 at the backend - I don't know ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: 03 May 2011 12:32 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy But surely the reason is that whilst some years ago we all did everything in U2 (or D3 or whatever) today we use a blend of technologies. So it is unlikely that you will be doing new front end development in basic, you will have adopted a .NET or java or whatever approach. You will then, I hope, be interfacing back to U2 for data storage and, to a greater or lesser extent, business logic, but you are unlikely to be trying to work out how to do massively innovative things in U2. That is a reflection of the fact the U2 is becoming more and more a database and less of a complete development environment. It's part of the evolution, when I started on a CMC/Microdata Reality the operating system, database and development environment were combined. Then the o/s bit gradually dropped away and it all became a database and development environment on unix or windows. Now, to some extent, the development environment is moving away and it is becoming a database. Arguably that is where it should have been positioned in the first place, Pick/Reality etc were never great as operating systems, as development environments they have had their day but it was always and still is as a database that the true strengths lie. George Land APT Solutions Ltd U2 UK Distributor On 03/05/2011 10:00, Symeon Breen syme...@gmail.com wrote: I am with Tony on this one, I frequent a number of .net forums, there is massive dialogue on these - not because of bugs, but because people are constantly driving forward the boundaries on what is possible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 03 May 2011 06:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy From: David Jordan It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. I feel a need to stick a pin that balloon of hot air, even if I happen to agree with it in large part, and present an equal but opposite view. :) Paraphrase: It is the problem with a dying product there are not enough creative thoughts to keep the list busy. If you had one of the competitor products there would be a ton of ideas to discuss to keep multiple forums busy. Funny how great software can look bad, because there are so few people to discuss all the wonderful ways to use it. Just trying to keep things real. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1325 / Virus Database: 1500/3610 - Release Date: 05/02/11 ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1325 / Virus Database: 1500/3611 - Release Date: 05/02/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
One of the things that U2 has is the KISS principle. What I find like in .Net, is sometimes it overcomplicates a solution. 80% of my code is in UniBasic and 20% in .Net, however I feel like 80% of my time is taken up managing the .Net code compared to 20% managing the greater amount of code in UniBasic. That is something I hear from a number of developers who develop in both environments. I agree we should not do everything in U2, but I wish some of the other environments kept it simple to. One thing I have always liked about U2 is that I always felt confident that I would deliver a project close to time and close to budget, I rarely get surprises. However with .Net, suddenly I hit strange problems relating to versions of OS, security issues, etc that muddy the waters. Hence I spend a lot of time on .Net forums seeking solutions that I just don't need to do with U2. Buggy may have been a bit harsh, but there is an issue of consistency and dependability of development. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Verify all indexes
Hi, Is there a way to verify the indexes integrity of all files in Universe? Regards, Marcos Fogaça ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
What makes U2, isn't the database, it's the database interface. I haven't worked with any other language that was as easy to access/manipulate the data in the database than data basic. Essentially, databasic allows raw access to the data within the database. So, the beef we have, isn't so much with database, nor the interface, but how to get the interface to play nice with others, once that is solved -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Tuesday, May 03, 2011 9:27 AM To: U2 Users List Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy One of the things that U2 has is the KISS principle. What I find like in .Net, is sometimes it overcomplicates a solution. 80% of my code is in UniBasic and 20% in .Net, however I feel like 80% of my time is taken up managing the .Net code compared to 20% managing the greater amount of code in UniBasic. That is something I hear from a number of developers who develop in both environments. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Limitations of uvrestore
Hi. I agree with Manu. Even I would add that it is the best tool to detect File corruption too. We are doing it for years in Windows, Linux, HP-UX and AIX boxes. We allways increase the BLKMAX from default 8196 to 65536. (Otherwise uvbackup takes ages to finish...) We schedule one uvbackup of all of the accounts, dumping to a single disk file. Then we tar it to tape or removable media. The main issue is that you can zip the uvbackup on the fly, but you can't uvrestore from stdin. So that, we have to unzip prior to restore. Regarding the uvrestore issue that you mention on RHEL, I cant tell you, for sure, that uvrestore (from a file) works fine with block size 65536. Regards -- Augusto Alonso Alonso Director de Sistemas QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al usuario de destino, pudiendo contener información confidencial o protegida legalmente. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida, es exclusiva de su autor y no representa necesariamente la opinión de Quiter Servicios Centrales. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the author´s own and do not necessarily reflect those of Quiter Servicios Centrales. 2011/5/3 Manu Fernandes e...@infodata.lu Hi group, I'm using uvbackup/uvrestore as the system to backup uv accounts. Imho the only tool to perform : - a uvdb backup with binary level db integrity. - a cross plateform compatible backup We perform account level uvbackup sent to a local file (uvbackup accountfile.uvb). I can't talk about block sizes impact. About perf, I use the option -limit set to 1 ; then uvbackup don't start two process (reader/writer) this is really more quick. I know a problem with Type1 files when uvbackup from unix and uvrestore on windows. uvrestore 'restore' dir and subs-dir on windows like prepared on unix but uvwindows don't respect Type1 subs dir ... You must resize Type1 to Type19 on uvunix before uvbackup and uvrestore on uvwin. My 2 pence manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Gregor Scott Envoyé : mardi 3 mai 2011 04:13 À : U2 Users List Objet : [U2] Limitations of uvrestore I have just finished some testing of uvbackup and uvrestore on AIX and Linux to see if there are areas to improve performance. The results were interesting, and somewhat alarming - see http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and- uvrestore/ for details. What I am interested in is: a) Do UV platforms other than AIX and Linux have similar issues with uvrestore? b) Does anyone use block sizes beyond 1mb for uvbackup and uvrestore? If so, what size and what impact does it have on backup performance? Thanks Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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] Reliability doesn't raise enough issues to keep the listbusy
I decided to expand on this topic and post a blog on it: nospamNebula-RnD.com/blog/tech/mv/2011/05/back-in-my-day1.html Some people may need to 'sew' that link together if the list server or their email client rips it apart. Please remove 'nospam'. (Oh the hassles of the modern world) T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Verify all indexes
Hi. The only way I know to be sure (without BASIC) is doing a BUILD.INDEX on every suspicious file. Regards -- Augusto Alonso 2011/5/3 Marcos Fogaca mfog...@integral.com.br Hi, Is there a way to verify the indexes integrity of all files in Universe? Regards, Marcos Fogaça ___ 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] Reliability doesn't raise enough issues to keep the list busy
Symeon: I think there are two problems here; closed platform, and deployment costs. You know how many times Kevin King was hoping to find a native connector to PHP. No response. How long did it take to get a .NET connectivity product? I can't find out a darned thing about the product (an earlier version of mv.NET). Once one developes, finding out the cost of deploying an MV application is rather disconcerting. As much as a number of people on this list try, you can never get a good buz going because the vendor is only interested in moving forward to maintain current revenue structures. In the open-source world, all kinds of things are being tried, enhanced, retrofitted, etc. There's huge interest, but little business deployment. Most businesses are trying to use technology to decrease costs and/or increase income. The revenue structure of the U2 products seem to preclude this movement toward more openness and less cost. Bill - Original Message - *From:* syme...@gmail.com *To:* 'U2 Users List' u2-users@listserver.u2ug.org *Date:* 5/3/2011 5:05 AM *Subject:* Re: [U2] Reliability doesn't raise enough issues to keep the listbusy So maybe we all need to discuss more about the blend of technologies that we use. I am also a member of a couple of MongoDB discussion groups, Mongo is a fairly new DB, and i don't think it has the userbase of U2, yet those forums are alive with technical discussion, much of it about the interfaces from different languages into MongoDB. Then again it comes back to an older post on here - Mongo have developed interfaces to their DB for many languages, and many third party ones have followed, Rocket have a .net and a java interface, the code is closed and there are very few if any third party interfaces to say php, ruby etc. Maybe this is all linked, maybe there are just a handful of us on this group developing in a blend of technologies with U2 at the backend - I don't know ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: 03 May 2011 12:32 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy But surely the reason is that whilst some years ago we all did everything in U2 (or D3 or whatever) today we use a blend of technologies. So it is unlikely that you will be doing new front end development in basic, you will have adopted a .NET or java or whatever approach. You will then, I hope, be interfacing back to U2 for data storage and, to a greater or lesser extent, business logic, but you are unlikely to be trying to work out how to do massively innovative things in U2. That is a reflection of the fact the U2 is becoming more and more a database and less of a complete development environment. It's part of the evolution, when I started on a CMC/Microdata Reality the operating system, database and development environment were combined. Then the o/s bit gradually dropped away and it all became a database and development environment on unix or windows. Now, to some extent, the development environment is moving away and it is becoming a database. Arguably that is where it should have been positioned in the first place, Pick/Reality etc were never great as operating systems, as development environments they have had their day but it was always and still is as a database that the true strengths lie. George Land APT Solutions Ltd U2 UK Distributor On 03/05/2011 10:00, Symeon Breensyme...@gmail.com wrote: I am with Tony on this one, I frequent a number of .net forums, there is massive dialogue on these - not because of bugs, but because people are constantly driving forward the boundaries on what is possible. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 03 May 2011 06:36 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reliability doesn't raise enough issues to keep the list busy From: David Jordan It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. I feel a need to stick a pin that balloon of hot air, even if I happen to agree with it in large part, and present an equal but opposite view. :) Paraphrase: It is the problem with a dying product there are not enough creative thoughts to keep the list busy. If you had one of the competitor products there would be a ton of ideas to discuss to keep multiple forums busy. Funny how great software can look bad, because there are so few people to discuss all the wonderful ways to use it. Just
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
We'll all believe you, when they are published. What's the link again? In a message dated 5/3/2011 4:21:55 A.M. Pacific Daylight Time, george.l...@aptsolutions.net writes: How a product that is growing can simultaneously be dying is a bit of a mystery. Sitting here with last quarter's sales figures for U2 in the UK I can definitely say it's not dying, they look very healthy indeed. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [uv] file header sica region structure
Hi group, I've some uvfiles where I set triggers (no SQL Schema defn). I'll check the TRIGGER defn by BASIC ! FILEINFO, STATUS ? ? I found no documentation about uvfile's SICA Region structure/access. Is there someone with idea ? (yes, I can execute a LIST.SICA and analyse the text-output but if possible I prefer use of a better interface than text) Thanks. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [uv] file header sica region structure
Hi Manu, As the UniVerse internals course notes state, describing the structure of the SICA would defeat its purpose. LIST.SICA is the only tool provided to access this. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 - Original Message - From: Manu Fernandes e...@infodata.lu To: u2-users@listserver.u2ug.org Sent: Tuesday, May 03, 2011 7:35 PM Subject: [U2] [uv] file header sica region structure Hi group, I've some uvfiles where I set triggers (no SQL Schema defn). I'll check the TRIGGER defn by BASIC ! FILEINFO, STATUS ? ? I found no documentation about uvfile's SICA Region structure/access. Is there someone with idea ? (yes, I can execute a LIST.SICA and analyse the text-output but if possible I prefer use of a better interface than text) Thanks. Manu ___ 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 RESIZE CONCURRENT
Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
Upgrade to 7.2.8 before you try it. We tried this on 7.2.5 in Dev and required a reboot from corruption. We were informed we need to upgrade 7.2.8 to get the fix for it. As always, I'd suggest doing anything new a few times on a Dev server before trying it on a Production server. Cheers, dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, 4 May 2011 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata RESIZE CONCURRENT Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
Databases have become utility. I don't see many applications today advertising they run on Oracle or Microsoft, many are trying to be generic. People are more interested in buying SAP than worry what database it runs on. Those days of user base and TPC ratings are gone. Users and developers want to know does it run on the environments they want, does it interface with other applications, does it work with cloud, what are the costs, what are the returns it will deliver. They are not asking who uses the database or how many users around the world use it, they are asking who uses the application that they are looking to buy. There is nothing in U2 that stops me interfacing with new technologies. Sure I would like some more native and sometimes simpler interfaces but I have been able to do most things talking to U2. Rocket may not publish figures, but U2 is increasing staff, U2 are introducing new products such as DataVu, these are not indicators of a dying product. Less than 500 people attended U2 universities around the world which means everyone else failed to find out what Rocket is doing. Rocket created the opportunity, but people failed to take advantage of it. Stop focusing on what U2 does not do as all technologies have holes. Focus on what it does do and then work with Rocket to further improve the technology. People do not understand where they are touched by U2. Your baggage being unloaded from the plane is probably using U2. Dialing an emergency number, the operator could be using U2. Doing a banking transaction often has a pick application involved, booking a flight, membership to a union, project management of a building site, dealing with a car distributor, going to the library, managing a nuclear reactor. You name it you are being touched by U2 applications everyday. For me U2 allows me to compete with a small RD staff, small support staff and at a lower cost. I am able to deliver far more for a tenth of the cost of my competitors. If new developers are making decisions based on technology awe instead of business justification, then they will have a short life span. I don't really see why we need to know what the number of users in the market are, it is not that relevant. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata RESIZE CONCURRENT
I am not aware of any problems with RESIZE CONCURRENT that resulted in a corrupt file. There is a problem that can occur that results in a WRITE failure, but not physical file corruption. From the 7.2.8 readme (for Linux you will need to upgrade to 7.2.9): Issue UDT-3787 - Problem Description UniBasic -- After a RESIZE CONCURRENT command had been run on any UniData file on a server, subsequent updates to records in another UniData file could result in a fatal UniBasic runtime error: U_LLM_Release error 7 This problem occurred very rarely. While it could occur with an update to any UniData file type, it had only been reported with updates to a DIR-type file within UniBasic. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Tuesday, May 03, 2011 4:23 PM To: U2 Users List Subject: Re: [U2] Unidata RESIZE CONCURRENT Upgrade to 7.2.8 before you try it. We tried this on 7.2.5 in Dev and required a reboot from corruption. We were informed we need to upgrade 7.2.8 to get the fix for it. As always, I'd suggest doing anything new a few times on a Dev server before trying it on a Production server. Cheers, dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, 4 May 2011 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata RESIZE CONCURRENT Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ 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 RESIZE CONCURRENT
Hi Wally, I just confirmed with our Admin that it was programs crashing, not a corrupt file that required the reboot. Thanks for the clarification and actual issue ID. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Wednesday, 4 May 2011 10:02 AM To: U2 Users List Subject: Re: [U2] Unidata RESIZE CONCURRENT I am not aware of any problems with RESIZE CONCURRENT that resulted in a corrupt file. There is a problem that can occur that results in a WRITE failure, but not physical file corruption. From the 7.2.8 readme (for Linux you will need to upgrade to 7.2.9): Issue UDT-3787 - Problem Description UniBasic -- After a RESIZE CONCURRENT command had been run on any UniData file on a server, subsequent updates to records in another UniData file could result in a fatal UniBasic runtime error: U_LLM_Release error 7 This problem occurred very rarely. While it could occur with an update to any UniData file type, it had only been reported with updates to a DIR-type file within UniBasic. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Tuesday, May 03, 2011 4:23 PM To: U2 Users List Subject: Re: [U2] Unidata RESIZE CONCURRENT Upgrade to 7.2.8 before you try it. We tried this on 7.2.5 in Dev and required a reboot from corruption. We were informed we need to upgrade 7.2.8 to get the fix for it. As always, I'd suggest doing anything new a few times on a Dev server before trying it on a Production server. Cheers, dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, 4 May 2011 8:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata RESIZE CONCURRENT Unidata 7.2.5 on RedHat. Historically, we have had downtime and a brief (1 hour) maintenance window each week where we memresize our files. We'd like to switchover to RESIZE/CONCURRENT to reduce downtime and would like to hear from anyone doing this on a production system. It's not that I don't trust it: I'm just looking for insight, gotchas, pros/cons of memresize vs RESIZE or other input from those who might've gone down this road already. TIA, -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received
[U2] UV readSocket bug
Thanks to those who replied to my Itanium Endianness question. While looking at the issues in going from UV 10.0 (HP-UX) to a later version, I came across a fix to the readSocket function for a bug we didn't realise was a bug. 'Problems Fixed in UniVerse Release 10.3.7 (Build 4185) Issue Short Description - - 6739UniVerse -- When blocking mode was set to 1, a timeout on a readsocket caused the socket to be unusable. A message similar to the following example appeared: readSocket1: The virtual circuit was terminated due to a time-out or other failure. The application should close the socket as it is no longer usable.' We have a system that uses readSocket in this way and copes with the erroneous error. What will happen under the fix when there's a timeout ? Will this just appear as a successful read with an empty read buffer and an actual_read_size of zero ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
