[U2] UniData Guide Command
We use the UniData guide51 command to test the integrity of our files each night and whenever our system takes a hit. We are also using alternate indexing on some of our larger files. Does guide51 test alternate index files? If not, is there anything that DOES test the alternate index files? Is there a newer tool that should be used instead of guide51? We are using HPUX 11i and UniData 7.2.1. John Israel ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Guide Command
'regular' guide is best for hashed files. When we enhanced guide at 5.2, we had a couple of problems that were ironed out years ago (these early problems were the only reason to use the prior version - guide51). Guide_ndx can be used to check the logical and/or physical integrity of alternate index files. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **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 Israel, John R. Sent: Wednesday, December 16, 2009 6:21 AM To: U2 Users List Subject: [U2] UniData Guide Command We use the UniData guide51 command to test the integrity of our files each night and whenever our system takes a hit. We are also using alternate indexing on some of our larger files. Does guide51 test alternate index files? If not, is there anything that DOES test the alternate index files? Is there a newer tool that should be used instead of guide51? We are using HPUX 11i and UniData 7.2.1. John Israel ___ 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 Guide Command
Thanks! I always thought guide51 replaced guide. Should guide51 be used at all, or just use the old (but updated) guide command? 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 Wally Terhune Sent: Wednesday, December 16, 2009 8:25 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command 'regular' guide is best for hashed files. When we enhanced guide at 5.2, we had a couple of problems that were ironed out years ago (these early problems were the only reason to use the prior version - guide51). Guide_ndx can be used to check the logical and/or physical integrity of alternate index files. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **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 Israel, John R. Sent: Wednesday, December 16, 2009 6:21 AM To: U2 Users List Subject: [U2] UniData Guide Command We use the UniData guide51 command to test the integrity of our files each night and whenever our system takes a hit. We are also using alternate indexing on some of our larger files. Does guide51 test alternate index files? If not, is there anything that DOES test the alternate index files? Is there a newer tool that should be used instead of guide51? We are using HPUX 11i and UniData 7.2.1. John Israel ___ 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 Guide Command
Guide51 is the old command. It has not been changed, fixed or updated since UniData 5.1. Plus it requires exclusive access to dynamic files and RFS files to run. Guide is current and recommended. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 ..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 Israel, John R. Sent: Wednesday, December 16, 2009 6:33 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command Thanks! I always thought guide51 replaced guide. Should guide51 be used at all, or just use the old (but updated) guide command? 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 Wally Terhune Sent: Wednesday, December 16, 2009 8:25 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command 'regular' guide is best for hashed files. When we enhanced guide at 5.2, we had a couple of problems that were ironed out years ago (these early problems were the only reason to use the prior version - guide51). Guide_ndx can be used to check the logical and/or physical integrity of alternate index files. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **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 Israel, John R. Sent: Wednesday, December 16, 2009 6:21 AM To: U2 Users List Subject: [U2] UniData Guide Command We use the UniData guide51 command to test the integrity of our files each night and whenever our system takes a hit. We are also using alternate indexing on some of our larger files. Does guide51 test alternate index files? If not, is there anything that DOES test the alternate index files? Is there a newer tool that should be used instead of guide51? We are using HPUX 11i and UniData 7.2.1. John Israel ___ 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
Do you replicate every file on the server ? --- On Wed, 12/16/09, John Hester jhes...@momtex.com wrote: From: John Hester jhes...@momtex.com Subject: Re: [U2] Unidata 6.1 Replication To: U2 Users List u2-users@listserver.u2ug.org Date: Wednesday, December 16, 2009, 1:00 AM Brad is right. You can get bitten by OS-level replication with U2 because hashed files require more than one write when a record has to go to overflow space. If the primary box crashes when only one of these writes is done, the secondary box will have a corrupted file. There are also issues with UV dynamic files (don't know about UD) because some of the file structure information is cached in memory and not immediately flushed to disk. We do OS-level replication on UV and got around these issues by sizing all files to use no overflow and only using dynamic files for temp report work files. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Address Sent: Tuesday, December 15, 2009 8:12 PM To: U2 Users List Subject: Re: [U2] Unidata 6.1 Replication Double-Take replicates byte by byte. --- On Tue, 12/15/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: Tuesday, December 15, 2009, 10:56 PM 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? ___ 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
Brad and John, [ad] Since, we work with both UD and UV we found replication is not the same. We wrote a simple Java program that runs using UOJ and does the replication to one or many sites. The software can even replicate from Universe to Unidata or the other way. Additionally, we added support for TCL/ECL commands such as CREATE.FILE, BASIC, and most others. We don't have any problems with any release of Unidata 6.0 or greater or Universe 9.6 or greater. We don't have any issues with dynamic or hashed files since everything is replicated at the record level. This is all part of our amazing U2WebLink(tm) product that runs on Apache Tomcat. We even added native support for PHP. The product handles thousand upon thousand of transactions per hour without even a hiccup at our clients for many many years. [/ad] Regards, Doug www.u2logic.com/tools.html BTW: We heard that soon UD and UV will be using the same replication engine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Tuesday, December 15, 2009 11:01 PM To: U2 Users List Subject: Re: [U2] Unidata 6.1 Replication Brad is right. You can get bitten by OS-level replication with U2 because hashed files require more than one write when a record has to go to overflow space. If the primary box crashes when only one of these writes is done, the secondary box will have a corrupted file. There are also issues with UV dynamic files (don't know about UD) because some of the file structure information is cached in memory and not immediately flushed to disk. We do OS-level replication on UV and got around these issues by sizing all files to use no overflow and only using dynamic files for temp report work files. -John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] XLr8Editor Sale
[ad] We are having a year end sale. No red tags, no door buster promotions we selling software for next to nothing. Well not really, but we feel it is a good deal. For 49.00 you get the XLr8Editor for Universe and Unidata that allows you to edit your Basic code, or you data records, do version control, multiple copy and past clipboard options, add your own projects,replace ESEARCH with local search engine, use the built in compare editor, local version control, and many more options. Before I get pinched by the run on sentence people, go to our web site and click on either the Google Checkout or PayPal Buy Now buttons, and you can be editing your programs with the finest editor $49.00 can buy. See www.u2logic.com/tools.html for more information and check out our downloads page for all of the information you might need or even some free source code for the iPhone. Regards, Doug www.u2logic.com [/ad] BTW: See www.u2logic.com/pdfs/XLr8EditorComparison.pdf ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RECORDLOCKED statement
Thank you Raul. We don't use shared locks so started at -2, but it won't hurt to get them all. Changed made. Thank you. -Baker x3598 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of raul_doming...@neimanmarcus.com Sent: Tuesday, December 15, 2009 5:27 PM 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 baker.hug...@mouser.com Sent by: u2-users-boun...@listserver.u2ug.org 12/15/2009 05:17 PM Please respond to U2 Users List u2-users@listserver.u2ug.org To 'U2 Users List' u2-users@listserver.u2ug.org 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
Re: [U2] RECORDLOCKED statement
Thank you Gregor. Good efficiency. Change made. Thank you. -Baker x3598 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Tuesday, December 15, 2009 7:40 PM To: 'U2 Users List' 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 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
Re: [U2] RECORDLOCKED statement
Thanks Brad, good catch. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, December 15, 2009 9:48 PM To: gregor.sc...@pentanasolutions.com; U2 Users List Subject: Re: [U2] RECORDLOCKED statement Assign the result to a variable: that reduces the i/o to the lock manager by 60%+ Brad 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
Re: [U2] Unidata 6.1 Replication
Good info to have. I'll have to evaluate your solution when it comes time to upgrade the UV servers again. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, December 16, 2009 8:46 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 6.1 Replication Brad and John, [ad] Since, we work with both UD and UV we found replication is not the same. We wrote a simple Java program that runs using UOJ and does the replication to one or many sites. The software can even replicate from Universe to Unidata or the other way. Additionally, we added support for TCL/ECL commands such as CREATE.FILE, BASIC, and most others. We don't have any problems with any release of Unidata 6.0 or greater or Universe 9.6 or greater. We don't have any issues with dynamic or hashed files since everything is replicated at the record level. This is all part of our amazing U2WebLink(tm) product that runs on Apache Tomcat. We even added native support for PHP. The product handles thousand upon thousand of transactions per hour without even a hiccup at our clients for many many years. [/ad] Regards, Doug www.u2logic.com/tools.html BTW: We heard that soon UD and UV will be using the same replication engine. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 Replication
In message e6179e13392ec14aabcd5272c3aedd61112ce...@exchangesvr.momtex.com, John Hester jhes...@momtex.com writes There are also issues with UV dynamic files (don't know about UD) because some of the file structure information is cached in memory and not immediately flushed to disk. This is no longer true. Can't remember which IBM'er it was, but it was confirmed that UV flushes everything at once, and it's been that way for quite a while now. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users