Re: [U2] Left Outer Join Question
What ECl type are you using. If you are using 'P' instead of 'U', use the lowercase verb and it should work select FILE1 TO 1 select FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Monday, March 03, 2014 4:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Left Outer Join Question I must be doing something wrong. When I try this I get; SELECT FILE1 TO 1 SELECT FILE2 TO 2 MERGE.LIST 1 INTERSECT 2 TO 3 SELECT list 1 is not active. - I used to be an Optimist until I knocked over the glass. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Left-Outer-Join-Question-tp42740p42762.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 -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2014 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
We create a lot of delimited flat files at a Unix level. Then we ftp them to the windows side of the network. The ftp process generates an email to the user with a link to the file we just put on the LAN. The users can then open it up using the email link in Excel and do what they want. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Lettau Sent: Friday, February 28, 2014 8:29 AM To: U2 Users List Subject: Re: [U2] Reporting Tools In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? My first instinct when hearing this is that a report is not what you need. How many rows are in this report? Please note that my email address has changed. Beginning immediately my new address is jeff.let...@soundunited.com . Use this new address for all communications. Jeffrey Lettau | ERP Systems Manager | O 410.358.3600 | D 410.764.5242 | 5601 Metro Drive | Baltimore MD 21215 | www.soundunited.com Polk Audio - WWW.POLKAUDIO.COM Definitive Technologies - WWW.DEFINITIVETECH.COM BOOM Movement - WWW.BOOMMOVEMENT.COM -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Friday, February 28, 2014 9:22 AM To: U2 Users List Subject: [U2] Reporting Tools I'm looking for feedback from those in any industry about your report needs with U2 and what tools you use to solve them. In short, Entrinsik has serious inroads in the academic community and Informer is a reasonably good and inexpensive tool for most reports. However, we are running into issues with some users like to write large reports. Large, by out standards, are reports with 200+ columns in the output. Are others writing reports with this many output fields? If so, are you ever running up against limits in the sentence size (U_SENTLEN)? Our limit is about 9700 chars and we have some reports hitting this limit. I'm having a hard time explaining to some VP types that the database can't handle this size report... Any feedback is welcome. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2014 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging program execution in Unidata?
What we did was have a cron run every 10 minutes that executed a Unidata program. The Unidata program did a PCPERFORM sbcsprogs to capture everything that was running out of the global catalog. It parses up the output of sbcsprogs and builds a Unidata file. This file has the program name as the key and the following attributes: DR DoctoR (Display Record) File: CBH.PROGRAM.TRACKING ATB ATB Name Conv Value Item: CLM101 1 Last Update D2/01/06/14 2 First RecordedD2/11/16/00 3 No of Times Captured 4254 End of Defined Attributes If something consistently runs and finshes within 10 minutes, it will never be recorded. You could have the threshold set to whatever you want. But we thought 10 minutes was good enough for our usage. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, January 06, 2014 7:07 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging program execution in Unidata? I believe there is something wrong with this suggestions. IIRC you don't get the time and date it was last RUN, only the date it was last Accessed. I suspect this is the touch date, which could mean that just looking at it in a directory scan, touches it. Along with a host of other things that don't actually *run* the code. So it wouldn't answer the Q as to whether it's actively executed. You also get the number of times is has run since being catalogued, which always seemed to be an odd choice for me. It may have been run a thousand times, but not run at all in the past ten years. But if I ruled the world, things would be different. Not better just different. Anyway, let us know how it works for your purpose. -Original Message- From: McGowan, Ian james.mcgo...@bankofthewest.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jan 6, 2014 4:55 pm Subject: Re: [U2] Logging program execution in Unidata? Larry/Wol, thanks for this. Trying it now on a dev server. Not sure how I've missed this all these years, but glad to learn something new! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, January 06, 2014 4:44 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? MAKE.MAP.FILE We catalog all our programs - locally (so they end up in CTLG in the current account) for programs specific to a particular account, as well as globally (so there is a pointer in CTLGTB) for generic programs. Unfortunately, unidata seems to have _MAP_ file in $UDTHOME/sys/_MAP_ (as well as a MAP command) but at least for us it's not populated. Thanks for the suggestion, Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Monday, January 06, 2014 4:13 PM To: U2 Users List Subject: Re: [U2] Logging program execution in Unidata? Ian, In universe the map file contains the most recent execution date for cataloged programs. Programs that are just RUN I don't know of any way. Dale On 01/06/2014 06:08 PM, McGowan, Ian wrote: We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaway and haven't been touched in years. It would be great to get some sense of which ones are active. We unfortunately don't have a wrapper program, wondering if anyone has run into this before - is it possible to somehow log when a program is executed in Unidata? Any magic triggers, directory flags or other audit flags that can get turned on? Any ideas gratefully received, Ian - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the 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 ___ U2-Users mailing
Re: [U2] UniData Dynamic File Splitting Question
We have some very large dynamic files. Some are over 100 gigabytes in size. Too me it is weird that you have one dat portion and 45 overflow portions of the file. My 100 gig file has 43 Dat portions and 1 overflow, which is what I try to maintain. I want as few overflow portions of the file as I can get. What does GROUP.STAT say about this file? When you do the guide, it shows how many records fall into 1-512 512-1028 1028-2056 etc. I try and adjust my block size for the file to get close to 80-90% of the records in the file to fit into the block size. I usually don't use memresize to rebuild my dynamic files. I create a new file with the configuration I want. We have developed a process called PHANTOM.COPY. It requires a list of the id's that exist in the current file. Then if I tell PHANTOM.COPY to run using 10 phantoms, it breaks the list up into 10 pieces and does simultaneous copies. So it is not much slower than memresize. The reasoning for this is that memresize creates one overflow portion for every dat portion. And I don't want my 100 gig file to have 43 dats and 43 overflow portions. I want 43 dats and one overflow if I can do it. And PHANTOM.COPY allows me to get that setup. This allows me to figure out what files need resizing too. If I have more than a couple overflow portions, it is time to rebuild the file again. Are you using KEYONLY or KEYDATA for your dynamic files. We have had problems with KEYDATA when we have a keys that have #''s for separators in the key. So for these files, I use KEYONLY. We use all kinds of dynamic files and most are quite large. We are on 7.1 though. So maybe 7.2 has issues. - Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 11:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniData Dynamic File Splitting Question I work with the North Carolina Community College System which supports the 58 NC colleges. We have an unusual dynamic file issue at a couple of the colleges and am hoping someone could provide some insight/direction. OS - Solaris 10 UniData version 7.2.5 (have upgraded a couple of times in the past from 6.1 and 7.1) Colleges have been running Ellucian's Colleague software since 2001 The problems do not seem to be occurring in all dynamic files but where there are issues, there are more than 100 files affected. From timestamps in some of the files, we can see that this has been going on for several years but we are unaware of the issue until the files have split into so many parts that the application can no longer open enough files to read/write the files. Database tools do not show these files as undersized or in overflow2. Guide will show you the many parts if you know what to look for but it is not obvious that the file is fragmented. When we found the issue at the first college we opened a call with Ellucian and was told to resize the files.We had a call to Rocket opened and unfortunately didn't get much further. The Rocket support analyst looked at udtdiags for us and did not find anything out of the ordinary. Rocket identified a couple of potential dynamic file issues at our UniData version and suggested that we upgraded to UniData 7.3. One of the identified issues seemed to apply but it did not explain all issues. We are looking at the UniData upgrade but we likely will still need to address the current file issues. We started resizing files and the files were compressed as expected but soon began splitting again. To 'fix' the files now, we are manually recreating the files, copying data to new files, renaming everything and rebuilding any indices. Long and tedious process but the file seem to behave better, at least so far. Below is a listing of one of the main application files and all its parts. Many of the files have many more parts that the listing below. The splitting occurs with dat, over and idx with files some files having many of one part while other have many of all. If anyone has any insight into how/why the files split this way and suggestion on how to correct and prevent it in the future, I would very much like to hear your ideas. Thanks for your input and suggestions. Cinda Goff sun2:/datatel/coll18/production/apphome/DATA/DATA_P/PERSON165-$ ls -al total 533958 drwxrwx--- 2 datatel users 1536 Jun 26 12:42 . drwxrwx--- 269 datatel users 13824 Feb 18 10:24 .. -rw-rw 1 datatel users6292480 Jul 1 12:57 dat001 -rw-rw 1 datatel users152743936 Jul 1 12:56 idx001 -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx002 -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx003 -rw-rw-rw- 1 ijackson users 4096 Aug 12 2011 idx004 -rw-rw-rw- 1 gmoore users 4096 Aug 12 2011 idx005 -rw-rw-rw- 1 sbarnes users 4096 Aug 12 2011 idx006 -rw-rw-rw- 1 whardwic
Re: [U2] UniData Dynamic File Splitting Question
There are a lot of Universe features I Would like to see in Unidata. Distributed files and all the hashing algorithms would be a nice start. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 12, 2013 12:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData Dynamic File Splitting Question Ahhh if that's true is amazing. Universe has had this for over twelve years. I guess the number of customers who used it was too small for them to port it to Unidata. -Original Message- From: Dave Davis dda...@harriscomputer.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jul 12, 2013 10:40 am Subject: Re: [U2] UniData Dynamic File Splitting Question UniData doesn't do distributed files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 12, 2013 1:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData Dynamic File Splitting Question This statement of yours is a wonder As for distributed files, Ellucian doesn't support them in the application so they are not an option at this point. Ellucian has an application that reaches in and reads and writes data in some kind of raw form? Otherwise I have no idea how the application would even *know* that the underlying file is dynamic since that detail should be completely hidden at the application level. It's as if an application would know that a file is dynamic or not dynamic, the application should both not know, and more importantly not *care*. -Original Message- From: Cinda Goff go...@nccommunitycolleges.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jul 12, 2013 10:28 am Subject: Re: [U2] UniData Dynamic File Splitting Question Definitely crazy. When we rebuild some of files, they fit into one dat and one over so there was no reason for them to split in the first place. Application never purges records in most files so it is not likely a space reclamation issue. I'm used to a split grabbing a large chunk of space so basically, dat and over pretty much increase together if needed with hopefully, over lagging behind. We normally use KEYONLY which is the application default unless we have looked at the file and determined we need to go to KEYDATA. The one Rocket issue that I did not think applied was for KEYDATA files and at the time we looked to see if any of the files at that particular college had been converted to KEYDATA. We use hash type 0. I don't have a GROUP.STAT on this file but I'm working with one of the colleges today and will gather that information. Below is a FILE.STAT from another small file which we found at another college yesterday. The file does have overflow but the records are very small and there really aren't that many records in the file. :FILE.STAT UI.LOG.INFO File name(Dynamic File) = UI.LOG.INFO Number of groups in file (modulo) = 3277 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 1024 File has 1632 groups in level one overflow. Number of records = 44217 Total number of bytes = 2781198 Average number of records per group = 13.5 Standard deviation from average = 3.9 Average number of bytes per group = 848.7 Standard deviation from average = 244.4 Average number of bytes in a record = 62.9 Average number of bytes in record ID = 18.6 Standard deviation from average = 3.3 Minimum number of bytes in a record = 49 Maximum number of bytes in a record = 76 Minimum number of fields in a record = 5 Maximum number of fields in a record = 5 Average number of fields per record = 5.0 Enter New line to continue... Standard deviation from average = 0.0 File has 17 over files, 22 prime files As for distributed files, Ellucian doesn't support them in the application so they are not an option at this point. -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F9473sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, July 12, 2013 1:02 PM To: 'U2 Users List' Subject: Re: [U2] UniData Dynamic File Splitting Question Frankly, this doesn't look like a very big file at all, and I'm amazed you're getting any 'performance' out of it at all with all those OVER files. Crazy! Sincerely, David Laansma Hubbard Supply
Re: [U2] UniData Dynamic File Splitting Question
Something is radically wrong here. You only have 44K records in the file with 3277 groups. See if you can run a guide with the -d3 option and also show us the first page of the GROUP.STAT command. From ECL, do a GROUP.STAT UI.LOG.INFO and do a !guide -d3 UI.LOG.INFO. The guide will build 3 report files at a UNIX level. The one that is called GUIDE_STATS.LIS has the most useful info in it. cat that file by doing !cat GUIDE_STATS.LIS and paste that into a mail message. That should show the split/merge info. If you can post that, we should be able to figure out what is wrong. - Thanks Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 12:27 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Definitely crazy. When we rebuild some of files, they fit into one dat and one over so there was no reason for them to split in the first place. Application never purges records in most files so it is not likely a space reclamation issue. I'm used to a split grabbing a large chunk of space so basically, dat and over pretty much increase together if needed with hopefully, over lagging behind. We normally use KEYONLY which is the application default unless we have looked at the file and determined we need to go to KEYDATA. The one Rocket issue that I did not think applied was for KEYDATA files and at the time we looked to see if any of the files at that particular college had been converted to KEYDATA. We use hash type 0. I don't have a GROUP.STAT on this file but I'm working with one of the colleges today and will gather that information. Below is a FILE.STAT from another small file which we found at another college yesterday. The file does have overflow but the records are very small and there really aren't that many records in the file. :FILE.STAT UI.LOG.INFO File name(Dynamic File) = UI.LOG.INFO Number of groups in file (modulo) = 3277 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 1024 File has 1632 groups in level one overflow. Number of records = 44217 Total number of bytes = 2781198 Average number of records per group = 13.5 Standard deviation from average = 3.9 Average number of bytes per group = 848.7 Standard deviation from average = 244.4 Average number of bytes in a record = 62.9 Average number of bytes in record ID = 18.6 Standard deviation from average = 3.3 Minimum number of bytes in a record = 49 Maximum number of bytes in a record = 76 Minimum number of fields in a record = 5 Maximum number of fields in a record = 5 Average number of fields per record = 5.0 Enter New line to continue... Standard deviation from average = 0.0 File has 17 over files, 22 prime files As for distributed files, Ellucian doesn't support them in the application so they are not an option at this point. -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F9473sid=2008362 E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and shall be disclosed to third parties when required by the statutes. (NCGS.Ch.132) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, July 12, 2013 1:02 PM To: 'U2 Users List' Subject: Re: [U2] UniData Dynamic File Splitting Question Frankly, this doesn't look like a very big file at all, and I'm amazed you're getting any 'performance' out of it at all with all those OVER files. Crazy! Sincerely, David Laansma Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Friday, July 12, 2013 12:53 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Cinda, my apologies for mis-spelling your name in my previous response . Susan Lynch -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Friday, July 12, 2013 12:48 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question We could with some of them but a good number of them need to remain dynamic because they are in total over the 2gb limit. -- Cinda Goff N.C. Community College System Database Administrator 919 807-7060 vRoom Link:
Re: [U2] Unidata RESIZE CONCURRENT
Have you used the Concurrent index build? The downside I have seen with that is the speed. I have some files that are large and the concurrent index build is very slow. So I only use the concurrent index build when I have small files. I would guess you would see similar performance with the resize. But it is a guess on my part. It will be interesting to see if anybody has used it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Tuesday, March 05, 2013 2:43 PM To: U2 Users List Subject: [U2] Unidata RESIZE CONCURRENT So is anyone using Unidata's RESIZE CONCURRENT in production environments? I have a dedicated maintenance window, so performing regular file resizing usually isn't a problem here but I'm considering moving over to using the CONCURRENT feature - particularly if a fire crops up in our production environment. Just curious about people's experience with it and the possible impact on performance in a production environment. -- Jeffrey Butera, PhD Associate Director for Applications and Web Services Information Technology Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2013 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Determining number of users licensed
Are you on UNIX by chance? The first couple of lines of listuser tell you: # listuser | head Licensed(UDT+CP)/Effective Udt Sql iPhtm Pooled Total ( 875 + 0 ) / 875 511 45 2 0 558 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Wednesday, September 12, 2012 3:54 PM To: 'U2 Users List' Subject: Re: [U2] [UD] Determining number of users licensed I've tracked the largest number of users logged in - but I didn't have to worry about the max. I had thought it was in the SYSTEM() somewhere - but a quick look through help didn't show it. You could try parsing it out of the @udtbin\smm.log file... It's in there for windows - not sure about HPUX though. good luck Colin -Original Message- From: dean.armbrus...@ferguson.com Sent: September 12, 2012 2:24 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Determining number of users licensed Is there a way to programmatically determine the number of licensed users allowed? SYSTEM(514) reports the number of non-phantom users currently logged in, which is essentially the number of licenses in use. I want to compare that against the number of users allowed in a monitoring program. I want to know if we're close to the limit before we run out. The number of licenses varies by server. Colleagues have suggested using grep on udtconfig for NUSERS, but that is not the same thing. Since we generally have 100-200 phantom processes, we sometimes configure to a size larger than the license limit to have room for those phantom processes. UniData 7.3.1 HPUX 11.31 Dean Armbruster ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A better LISTU
It is taking some work to make it function in Unidata. But thanks for the framework. -Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, September 04, 2012 1:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] A better LISTU WLISTU pulls up the list sorted by date and time, and allows you to resort it by PID. It could be easily modified to allow sorting on any of the columns FFT.BP 'WLISTU' BASIC 71 lines Level: 3 0001 * 0002 * Writen Aug 2012 by Will Johnson 0003 * This routine sorts the LISTU table by date and then by time 0004 * Builds a multi-sub-valued table, so the times get sorted right 0005 * Then swaps the SVMs for VMs so it becomes a regular table 0006 * Then it also allows you to resort it by PID 0007 * 0008 EQUATE FALSE TO 0, TRUE TO 1 0009 TODAY = DATE() ; THIS.YEAR = OCONV(TODAY,'DY') 0010 SWITCH = DATE ; EXIT.PROGRAM = FALSE 0011 LOOP 0012 EXECUTE LISTU, OUT RESULTS 0013 SELECTV RESULTS TO L.RESULTS 0014 DONE = FALSE ; CNT = 0 ; HEADERS = '' ; TABLE = '' 0015 LOOP 0016 READNEXT LINE FROM L.RESULTS ELSE DONE = TRUE 0017 UNTIL DONE DO 0018 CNT += 1 0019 T.PID = LINE[16,5] 0020 T.TIMEDATE = LINE[62,13] 0021 T.DATE = OCONV(T.TIMEDATE,'G0 2'):' ':THIS.YEAR 0022 T.TIME = OCONV(T.TIMEDATE,'G2 1') 0023 IF SWITCH = DATE THEN GOSUB BY.DATE.AND.TIME 0024 IF SWITCH = PID THEN GOSUB BY.PID 0025 REPEAT 0026 TABLE1 = HEADERS:@VM:TABLE1 0027 TABLE = CONVERT(@SVM,@VM,TABLE) 0028 * 0029 S.TABLE = DCOUNT(TABLE1,@VM) 0030 FOR I.TABLE = 1 TO S.TABLE 0031 IF TABLE1,I.TABLE # '' THEN 0032PRINT I.TABLE'R%2':' ':TABLE1,I.TABLE 0033 END 0034 NEXT I.TABLE 0035 DISPLAY SORT BY (D)ATE, (P)ID, OR (Q)UIT : ; INPUT ANYTHING 0036 BEGIN CASE 0037 CASE ANYTHING = 'Q' ; EXIT.PROGRAM = TRUE 0038 CASE ANYTHING = 'P' ; SWITCH = 'PID' 0039 CASE ANYTHING = 'D' ; SWITCH = 'DATE' 0040 END CASE 0041 UNTIL EXIT.PROGRAM DO REPEAT 0042 STOP 0043 * 0044 BY.DATE.AND.TIME: 0045 I.DATE = ICONV(T.DATE,'D') ; I.TIME = ICONV(T.TIME,'MT') 0046 IF STATUS() THEN 0047 HEADERS1,-1 = LINE 0048 END ELSE 0049 LOCATE I.DATE IN TABLE2,1 BY 'AR' SETTING W.DATE ELSE 0050 TABLE = INSERT(TABLE,1,W.DATE;'') 0051 TABLE = INSERT(TABLE,2,W.DATE;I.DATE) 0052 TABLE = INSERT(TABLE,3,W.DATE;'') 0053 END 0054 LOCATE I.TIME IN TABLE3,W.DATE,1 BY 'AR' SETTING W.TIME ELSE 0055 NULL 0056 END 0057 TABLE = INSERT(TABLE,1,W.DATE,W.TIME;LINE) 0058 TABLE = INSERT(TABLE,3,W.DATE,W.TIME;I.TIME) 0059 END 0060 RETURN 0061 * 0062 BY.PID: 0063 IF NUM(T.PID) THEN 0064 T.PID = TRIM(T.PID) + 0 0065 LOCATE T.PID IN TABLE2,1 BY 'AR' SETTING W.PID ELSE NULL 0066 TABLE = INSERT(TABLE,1,W.PID;LINE) 0067 TABLE = INSERT(TABLE,2,W.PID;T.PID) 0068 END ELSE HEADERS1,-1 = LINE 0069 RETURN 0070 * 0071END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running a command in a different account
Are you on Unix or Windows? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, July 27, 2012 10:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] Running a command in a different account Greetings! We have a program that runs in one account, but under certain conditions it is becoming necessary for that program to execute a command in another account, and then continue on its merry way doing other things. One fairly simplistic example might be that the process might find it necessary to create a file in another account. We have come up with a number of different ways of accomplishing this, but all involve a phantom LOGTO of some sort -whether it be through working with the UV.ACCOUNT file, the LOGIN paragraph, or some combination of the above. While this will do what is necessary, there are timing issues to consider, control and response issues, error checking, etc. It can be done, but it's not pretty. Does anyone have a more elegant and efficient way of accomplishing this? Thanks in advance! Brian F. Paige _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. 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 strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Really trying to understand dynamic file sizing
Sorry I don't have time to really dive into this. A lot of the documentation are things that work most of the time. But sizing dynamic files is more art than science some times. But just looking at your stats, KEYDATA might be an option as well. You have a pretty high ratio of bytes per record to a 12 character key and will you ever get enough keys into a group to cause a split? Maybe. But KEYDATA uses both the data and keys to figure out when to split. The only problem I have had using KEYDATA is if you have a meaningful key with separators like '#' in them. The hashing gets goofed up and I can get good distribution into groups. I get splitting but I end up having groups that never get anything in them. So I will have one group with 11 records and then 2 with zero bytes: 4 0 0 5 795 1 6 0 0 7 4888 9 8 0 0 9 669 1 10 0 0 11 598711 12 0 0 13 0 0 14 0 0 15 579511 16 0 0 17 1113 2 18 0 0 19 984216 I have one file that has nice numeric keys and KEYDATA works great: -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat001 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat002 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat003 -rwxrwxr-x 1 root mcc 20 Jun 17 17:10 dat004 -rwxrwxr-x 1 root mcc 20 Jun 17 17:40 dat005 -rwxrwxr-x 1 5126 mcc 20 Jun 28 09:02 dat006 -rwxrwxr-x 1 30012mcc 20 Jun 17 17:46 dat007 -rwxrwxr-x 1 9421 mcc 20 Jun 17 17:46 dat008 -rwxrwxr-x 1 30334mcc 20 Jun 28 09:02 dat009 -rwxrwxr-x 1 30334mcc 20 Jun 17 16:16 dat010 -rw-rw-r-- 1 9319 mcc 20 Jun 17 17:40 dat011 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat012 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat013 -rwxrwxr-x 1 30334mcc 20 Jun 17 17:40 dat014 -rwxrwxr-x 1 30334mcc 941259776 Jun 28 09:02 dat015 -rwxrwxr-x 1 root mcc 194880 Jun 25 12:57 idx001 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:10 idx002 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:40 idx003 -rwxrwxr-x 1 root mcc 194880 Jun 25 12:57 idx004 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:30 idx005 -rwxrwxr-x 1 root mcc 194880 Jun 17 17:24 idx006 -rwxrwxr-x 1 c00655 mcc 194880 Jun 17 17:40 idx007 -rwxrwxr-x 1 8575 mcc 194880 Jun 17 16:16 idx008 -rw-rw-rw- 1 udtcron mcc 194880 Jun 17 17:46 idx009 -rw-rw-rw- 1 30334mcc 194880 Jun 25 12:57 idx010 -rw-rw-rw- 1 30334mcc 194880 Jun 25 12:57 idx011 -rw-rw-rw- 1 udtcron mcc 1765761024 Jun 26 15:17 idx012 -rwxrwxr-x 1 root mcc 954723328 Jun 28 09:02 over001 I haven't had to do anything to this file for a couple of years. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Thursday, June 28, 2012 9:29 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Really trying to understand dynamic file sizing I've only got a handful of dynamic files but of course they're huge and have a big impact on our daily and monthly processing. I'd REALLY like to understand the tuning mechanisms for these files, specifically SPLIT/MERGE. The formulas that I got on previous responses just don't seem to make sense on one particular file. So here's a FILE.STAT and ANALYZE.FILE of a file that I believe is in need of resizing and/or reconfiguring. I believe that if I can get some input on this file, I'll be able to apply that knowledge to my other files. First, I understand quite clearly that the modulo of 235889 is about half of what it should be, at least for a block size of 4096. Second, unless I'm doing something wrong, I computed my SPLIT LOAD to be 1, which just doesn't seem right. I'd like to resize this file this weekend and I know that if I do one thing incorrectly it could make my performance even worse. Any input would be greatly appreciated. File name(Dynamic File) = OH Number of groups in file (modulo) = 235889 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 4096 File has 234167 groups in level one overflow. Number of records = 1387389 Total number of bytes = 2132217978 Average number of records per group = 5.9 Standard deviation from average = 1.6 Average number of bytes per group = 9039.1 Standard deviation from average = 9949.2 Average number of bytes in a record = 1536.9 Average number of bytes in record ID = 12.4 Standard deviation from average = 4009.7 Minimum number of bytes in a record = 659 Maximum
Re: [U2] Learning about file sizing
Can't remember if this came from Wally or not a long time ago. But I use it to figure out Split/Merge. I have a development box that has a copy of production that I can play with. So I do a lot of playing with mod and sep and depend on GROUP.STAT to give me some idea of how groups are being populated. Sizing Dynamic Files Technote (FAQ) Problem Sometimes, administrators would like some ideas and insights on how to configure dynamic files to maximize file access speed and minimize the physical size. This article describes one process for making this determination. Solution To improve dynamic file performance an administrator can choose a new modulo and/or block size. Other important factors, however, are the percent standard deviation of the record size, the correct the hash type, and the split load percent. The first step is to generate file statistics using the ECL command FILE.STAT (in ECLTYPE U mode). The percent standard deviation can be obtained by the following formula: Standard deviation from average divided by Average number of bytes in a record. Ideally, this percent would be zero - all records are exactly the same size. Having all records the same size makes calculations more accurate for our file sizing purposes. A standard deviation percent under 15-20% means the variation of record sizes is less than perfect but we can still predict well enough to be confident that the problem has a satisfactory solution. However, it is very common in the U2 world for a file design to have been left in service beyond what is reasonable for today's situations - i.e. what worked well in 1980 may not be a good solution for much larger files than was originally anticipated. So, if in the old days you had, say, 10 multivalues in most records and today you have between 20 and 3000, then it is easy to see how the percent standard deviation for record size can creep up over the years without being noticed. Anyway, we'll slog forward on the assumption that the standard deviation percent is good. Final point: a high standard deviation percent for record size usually leads to wasted space, either in the form of sparsely populated primary groups and/or excessive overflow. A high standard deviation percent can create a situation where there is no good answer. An important factor in correct file sizing is to determine the better hashing algorithm - either type 0 or 1. It is useful to keep an open mind on this because hash type is another thing that can be set correctly and, over time, the format of the ids changes, and now the other hash type is better. First, you should always do ANALYZE.FILE filename and look at the Keys column. If you see consistency in the number as you look down the column, then the algorithm currently in place is likely correct. It can be variable enough to warrant further study. How you do this kind of analysis is to select a sample of 10,000 record ids from the file. Then create two dynamic files (one a type 0, the other a type 1) of blocksize 1024 and a modulo of 3. Then, CONFIGURE.FILE to set the MERGE.LOAD to 5 and the SPLIT.LOAD to 10. This configuration helps exagerate the results of the testing to make the decision a little easier. Then, populate each of the files using the sample list of ids and the empty string for a record. Whichever file is the smaller is usually the better hash type. Determine Id Size and Record Size Get two numbers from the FILE.STAT report: Average number of bytes in a record(avg rec size), rounded up to the next whole number; and, Average number of bytes in record ID(id size), rounded up to the next whole number. Follow these steps: 1.IDSIZE = id size from report above + 8 2.DATASIZE = avg rec size from report above - id size from report above 3.TOTAL = IDSIZE + DATASIZE Example: File name(Dynamic File) = DYN1 Number of groups in file (modulo) = 115 Dynamic hashing, hash type= 1 Split/Merge type = KEYONLY Block size= 1024 File has 5 groups in level one overflow. Number of records = 575 Total number of bytes = 25708 . . . Average number of bytes in a record = 100.7 Average number of bytes in record ID = 8.2 Standard deviation from average = 15.3 Average number of bytes in a record = 100.7 - 101 Average number of bytes in record ID = 8.2 - 9 IDSIZE = 9 + 8 = 17 DATASIZE = 101 - 9 = 92 TOTAL = 17 + 92 = 109 Determine Blocksize and Modulo The first block in each group has 32 bytes of header information. So, for a 1024 byte block, 992 bytes are useable for keys and data. Of this, a minimum of roughly 10 percent (124 bytes in this case) is reserved for key information. Each key will use up 8 bytes of overhead plus the length of the key itself. This is represented by IDSIZE above. The data portion of the record(s) begins after the key area and
Re: [U2] Huge Dynamic Unidata file
Indexes and all, 91 G with about 75 million records. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, April 26, 2012 4:08 AM To: 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file Out of interest, how big is this file and how many records ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 25 April 2012 21:30 To: 'U2 Users List'; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Huge Dynamic Unidata file
I think at the time I wrote this, Unidata 6 I think, I could not even get memresize to handle overflow that was larger than 2 gigabytes. So I thought the solution by Unidata was to create an overflow file for every dat segment. I have never specified the OVERFLOW option when using memresize. Plus, I rarely have enough space in a file system to handle 2 copies of one of my big file. One work around for the file system space issue is to symbolically link the original file in another file system. But that is a lot of work when you have a lot of dat files. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dean.armbrus...@ferguson.com Sent: Wednesday, April 25, 2012 3:16 PM To: u2-users@listserver.u2ug.org; jonathan.lec...@blairswindows.co.uk Subject: Re: [U2] Huge Dynamic Unidata file Were you using the OVERFLOW option with memresize? If not, memresize should not be creating the extra over files. If memresize did create the extra over files without the OVERFLOW option, then that would be a bug in memresize. Dean Armbruster System Analyst 757-989-2839 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, April 25, 2012 12:29 To: 'Jonathan Leckie'; 'U2 Users List' Subject: Re: [U2] Huge Dynamic Unidata file I resize most of my Dynamic files this way. I don't like having a small overxxx segment for every datxxx segment that memresize creates.. By creating the new file my self, I don't have a lot of these small overxxx segments that are never used. I also wrote a process to Select the old file and create a SAVELIST. Without going into to much detail, the process uses PHANTOM to spawn off a number of Unidata copies. So there are a number of simultaneous processes working to build the new file. Each PHANTOM Copy knows how many total phantoms are working on the file and what sequence IT is within the total number of PHANTOMS. Each Phantom handles part of the SAVELIST. Each PHANTOM does the iteration below until the list is exhausted: 1. QSELECT SAVEDLISTS listname000. (process 2 would use 001, process 3 would use 002 etc) 2. COPY FROM old.file TO new.file 3. Increment the list counter from 000 by the number of Phantoms and go back to step one to process a new segment of the savelist. 4. If a process cannot find the next savelist segment in SAVEDLISTS, it is done. This process is almost as fast as memresize. You can control what file systems are used for space reasons and you don't get scads of overxxx segments in your FILE.NAME directory (one of my dynamic files has 39 dat segments and just a over001). So I don't use memresize for dynamic files anymore. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Wednesday, April 25, 2012 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Huge Dynamic Unidata file I have a very large file that I don't have enough free space to memresize, however howabout I create new dynamic (temporary) file and then copy all the records (in ECL) to the new file and then (unix) copy the temporary file over the top of the original. Does that seem like a sensible idea? Regards Jonathan Leckie ** * This message has been scanned for viruses and dangerous content * and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairswindows.co.uk * * Name Registered Office: * * Blairs Windows Limited * Registered office : 9 Baker Street, Greenock, PA15 4TU * Company No: SC393935, V.A.T. registration No: 108729111 ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Change default UniVerse account on Solaris and ManFact
That should be a item named 'profile' in /etc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Sunday, April 08, 2012 8:35 AM To: 'U2 Users List' Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact I'm looking for the profile everyone is routed through. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Saturday, April 07, 2012 1:40 PM To: 'U2 Users List' Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact Are you looking for the profile in /etc that everyone is routed through on Solaris. Or a specific user, which should be found by doing grep userid /etc/passwd And look in the 5th or 6th field separated by colons. If it isn't either of those two, I'm not sure what you are looking for. - Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Saturday, April 07, 2012 9:59 AM To: 'U2 Users List' Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact Not On our Solaris box, unfortunatly -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Friday, April 06, 2012 6:07 PM To: U2 Users List Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact John, On our HP-UX I look in '/home'. There is a directory for each user id and '.profile' is in there. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Friday, April 06, 2012 2:58 PM To: 'U2 Users List' Subject: [U2] Change default UniVerse account on Solaris and ManFact I just migrated my company from a single user instance to a multi-plant instance on ManFact, over UniVerse and Solaris. This included an account change from MANLIVE to another account. I think I need to change a .profile entry to change the account that our users are logged into by default, but no one (Including Epicore) and tell me where that path is. Does anyone have any ideas? ___ 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 -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ 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 -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Change default UniVerse account on Solaris and ManFact
Are you looking for the profile in /etc that everyone is routed through on Solaris. Or a specific user, which should be found by doing grep userid /etc/passwd And look in the 5th or 6th field separated by colons. If it isn't either of those two, I'm not sure what you are looking for. - Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Saturday, April 07, 2012 9:59 AM To: 'U2 Users List' Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact Not On our Solaris box, unfortunatly -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Friday, April 06, 2012 6:07 PM To: U2 Users List Subject: Re: [U2] Change default UniVerse account on Solaris and ManFact John, On our HP-UX I look in '/home'. There is a directory for each user id and '.profile' is in there. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Friday, April 06, 2012 2:58 PM To: 'U2 Users List' Subject: [U2] Change default UniVerse account on Solaris and ManFact I just migrated my company from a single user instance to a multi-plant instance on ManFact, over UniVerse and Solaris. This included an account change from MANLIVE to another account. I think I need to change a .profile entry to change the account that our users are logged into by default, but no one (Including Epicore) and tell me where that path is. Does anyone have any ideas? ___ 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 -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD: Resizing and Caching
DO the resize at Unix with the memresize command and you can specify where the TMP space is. So you can use space from another file system during the resize. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rainer Viehöfer Sent: Tuesday, April 03, 2012 11:10 AM To: U2-USERS@listserver.u2ug.org Subject: [U2] UD: Resizing and Caching Unidata 7.1.8 Sun Fire 4500 32 GB RAM Main Storage on an EMC SAN. Single Application: 24/7 Library database, no replication. Hello, perhaps someone can help me or point me to an piece of helpful text with the following two questions: 1. Our storage operator claims that we produce too much steam on his drives. Are there UD parameters to look at in respect of Unidata caching? 2. For better performance I try to resize some of the files. It often happens, that no space for the temporary file can be found or it is not possible to copy the resized file as shown below: (happens with memresize as well) The actual file size in bytes = 34798592. Suggested resize modulo = 30449. :RESIZE AAF.KEY.BSN.BIS 30449 AAF.KEY.BSN.BIS is a synonym, real name is /usr/ud/opacfiles/AAF.KEY.BSN.BIS. The temporary file for RESIZE is /dev/shm/rsztp7nw1D8. Not enough space to copy /dev/shm/rsztp7nw1D8 back to /usr/ud/opacfiles/AAF.KEY. BSN.BIS. RESIZE failed. Cannot mv file. This is our file system design: Dateisystem 1K-Blöcke Benutzt Verfügbar Ben% Eingehängt auf /dev/mapper/VolGroup00-LogVol00 34252528 27323732 5188816 85% / /dev/sda1 101086 65155 30712 68% /boot none 16224128 5548488 10675640 35% /dev/shm /dev/mapper/VolGroup00-LogVol01 103662848 33754404 64642628 35% /tmp /dev/mapper/urica_prodp1 88591264 42596672 45994592 49% /usr/ud Can I force Unidata not to use /dev/shm but /tmp instead? Yours sincerely, Rainer Viehoefer -- - Rainer Viehöfer Digitale Bibliothek Bibliothekarische Datenverarbeitung BIS - Bibliotheks- und Informationssystem der Universität Oldenburg Universitätsbibliothek Postfach 2541 26015 Oldenburg - Germany Tel : +49 (0)441 798 22 65 Fax : +49 (0)441 798 40 40 Mail : rainer.viehoe...@uni-oldenburg.de - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Debugger Woes
Check the size of the program when compiled with the -D. You may be blowing some Shared Basic Code parameter in udtconfig. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, July 11, 2011 1:40 PM To: 'U2 Users List' Subject: [U2] Debugger Woes OK boys and girls, here is a weird one! Last week, one of our programmers was looking for some issues with 2 programs in Avanté. All he did with the 1st program (IIREADUL) was add a comment and recompile the code with the debugger option. All he did to the 2nd program is recompile with the debugger on. For some weird reason, our barcode handheld users started core dumping! This was not constantly happening, but was occurring 5-10 times an hour. We did not initially hit on the fact that it was one or both of these programs (debug mode should NOT do this), but after recompiling them w/o the debugger, the problems disappeared. Any divine insight as to why having a program compiled with debug on would cause frequent (but not consistent) code dumps? HPUX: 11.31 UniData: 7.2.1 SB: 5.4.2 John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ 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] Reading a Unix file from another machine.
Is AIX ebcdic? I use dd to convert files from ebcdic to ascii. Are they sending you packed data? I used to have to read the records using OSBREAD and then do an OCONV to unpack them. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard Sent: Tuesday, November 09, 2010 4:05 PM To: 'U2 Users List' Subject: [U2] Reading a Unix file from another machine. Hi all, I am trying to read a Unix file from and old aix machine. The people who sent it will not bend in how they sent it. What I got was in binary format so I used 'od' to convert it to ascii. When I tried to cat the file before trying to READSEQ records it looked like gibberish! I realized that if I set my Term type to vt100, I could read it but the carriage returns were just ^M after each record. After trying 'sed' I gave up. Universe will not read the file at all. I still get gibberish even on the converted file. Any ideas? There must be a way to do this. What am I missing? Thanks, Roy ___ 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] Reading a Unix file from another machine.
Try /usr/bin/strings -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard Sent: Tuesday, November 09, 2010 4:23 PM To: 'U2 Users List' Subject: Re: [U2] Reading a Unix file from another machine. NO joy! # cd /dbms # ls -l master -rwxrwxrwx 1 root system 54683259 Nov 08 18:16 master # string master newmaster ksh: string: not found. # -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, November 09, 2010 5:09 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Reading a Unix file from another machine. Try using at the unix command line String filename newfilenamer This will strip out all control characters - Original Message - From: Roy Beard [mailto:r...@cfl.rr.com] Sent: Tuesday, November 09, 2010 05:05 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: [U2] Reading a Unix file from another machine. Hi all, I am trying to read a Unix file from and old aix machine. The people who sent it will not bend in how they sent it. What I got was in binary format so I used 'od' to convert it to ascii. When I tried to cat the file before trying to READSEQ records it looked like gibberish! I realized that if I set my Term type to vt100, I could read it but the carriage returns were just ^M after each record. After trying 'sed' I gave up. Universe will not read the file at all. I still get gibberish even on the converted file. Any ideas? There must be a way to do this. What am I missing? Thanks, Roy ___ 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] Universe and stripped drives
Do you do a dbpause at all during this snapshot process? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Wednesday, April 28, 2010 1:09 PM To: U2 Users List Subject: Re: [U2] Universe and stripped drives Many 'nix systems not longer require breaking mirrors for backups... We haven't broken a mirror for backups since the late 90s. HP-UX and Linux for example. A MUCH better option is using logical volumes (and yes, you can still mirror and stripe) as well and use filesystem snapshots to backup. A snapshot takes what the filesystem looks like at the moment of creation and mounts it to another mount point. All writes occur to an alternate disk set, which any active application sees under the original mount point. When undoing the snapshot, all the writes are applied in order to the filesystem. The process of creating usually takes seconds, and if the users see it at all, it will appear as a slight pause. Undoing it depends on the volume of writes pending, usually seconds to minutes, but regardless will likely be MUCH less than rebuilding the mirror. And instead of needing a while 3rd set of drives, you only need enough space to hold the pending writes for the length of the backup. And they can live on the same set of drives of separate drives if you prefer. Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Dave Laansma dlaan...@hubbardsupply.com 4/28/2010 12:16 PM My opinion is to stripe all your data over as many drives as possible. Regarding mirroring, I would suggest a third mirror. The third mirror can be broken anytime during the day and used for backup, then 're-sync'd.' This configuration provides for minimum data loss due to (the number one cause of data loss) disk failure. Drives are cheap. Mirror up! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, April 28, 2010 12:47 PM To: U2 Users List Subject: [U2] Universe and stripped drives We are in the process of upgrading our system. When we setup our current system, it was suggested we strip our data drives (5) into one, instead of having 5 separate drives, so it could pull more data at once. The new system will have 6 drives available for striping We were going to have 6 drives striped into one, which would be partitioned into our data areas the thought being it would be faster disk access if it's pulling from all 6 drives at once. BUT...all of the partitions are on that one striped drive. Would it be better to have (2) sets of 3 drives striped into one, and setup the two most used accounts on each of those drives, so now it's only pulling data from 3 drives, but there could be less competition between the two accounts, since they are pulling from separate drives? Anyone played with this at all? FYI, each drive is mirrored as well, so if there is a drive failure, data loss is protected, if there was a drive failure on both the main and mirror (same drive) then with the 6 drive strip, we stand to potentially lose more data, than if there were 2 sets of 3 striped. But...since we have full daily backups, and potentially, considering a second backup during the day, the amount of data loss would be minimalso I'm putting that off the table for now in determining whether to go with a 3 or 6 stripe. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uucp
I would tar up the files, zip them and ftp them -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barber, Bonnie Sent: Friday, November 20, 2009 10:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] uucp Hi everyone. I would like to use uucp to copy files from our AIX production server to our AIX development/test server. I already use rcp to copy programs back and forth, but that does not work for files. Ftping the files to the desktop then to the development server is very tedious. I have created the uucppublic directories and the .hosts directory has the server names. When I enter the uucp command on the production server I get an error that states the dev server name is not valid. I think I am missing another setup for uucp but I do not know what it is. Thanks, Bonnie Barber Perseus Distribution | Senior Programmer, J-Cispub 731-988-3135 Direct 800-343-4499 ext. 178 731-988-4452 Fax Unus pro omnibus, omnes pro uno ___ 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] Trigger Question
We have successfully used this approach several times to find out what program was causing the problem. We used the call stack and also some info in our named commons to write to a debug file that we created for this process. We used to use dummy indexes to debug this type of problem. But triggers work just as well. -Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bessel, Karen Sent: Thursday, October 22, 2009 10:23 AM To: U2 Users List Subject: [U2] Trigger Question My application is creating some bogus records in a file, somewhere...we are unable to pinpoint when where what the user is doing to create these records, but they're popping up every couple of weeks. I'd like to create a trigger to tell me when these records appear so that someone gets notified, instead of inadvertently falling across the data days later. Since I don't know where this bogus data is being created, is it possible for the trigger subroutine to tell me what the call stack/writing program is. Thanks, Karen Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.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] Start Phantom in Another Account?
If you are on UNIX, you could use a UNIX shell script to 'cd' to the account before doing the 'udt PHANTOM' -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, September 22, 2009 10:08 AM To: U2 Users List Subject: [U2] Start Phantom in Another Account? Unidata 7.1.22. Is it possible to start a phantom job in another account? If so, how does one make this happen? -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] Null character causes odd UV behaviour
Try SWAP instead of CONVERT. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, September 16, 2009 6:28 PM To: U2 Users List Subject: [U2] Null character causes odd UV behaviour I'm just curious if anyone can shed some like on this odd behaviour I'm seeing with the ASCII null character (128) in a UV string variable. We have bidirectional sync between UV and MS SQL 2005 over ODBC, and it's possible to get the null character back from the SQL side. It doesn't happen under normal circumstances, but is within the realm of possibility. I guard against it with: CONVERT CHAR(128) TO '' IN VARNAME This worked fine when originally implemented (UV 9.5.1 I think), but now it seems to be broken (UV 10.2.7 on RH EL 5.1). We're testing an upgrade of our CRM software on the SQL side, and a developer was testing trigger changes that caused some fields to be sent to UV as null instead of empty strings. This caused a program which tries to build a file ID from one of these variables to abort on the READ statement. I put in some print statements for debugging, and I'm getting very odd results. Here's the code: 0089: CONVERT CHAR(128) TO '' IN STATE 0090: STATE = UPCASE(STATE) 0091: PRINT 'STATE = ':STATE:'' 0092: PRINT 'LEN(STATE) = ':LEN(STATE) 0093: PRINT 'SEQ(STATE[1,1]) = ':SEQ(STATE[1,1]) 0094: IF STATE = '' THEN 0095: PRINT 'UV THINKS STATE IS AN EMPTY STRING' 0096: END ELSE 0097: PRINT 'UV DOES NOT THINK STATE IS AN EMPTY STRING' 0098: END 0099: READV DUM FROM FILE.CF, 'STA*':STATE, 1 ELSE and here's the output it produces: STATE = LEN(STATE) = 0 SEQ(STATE[1,1]) = UV DOES NOT THINK STATE IS AN EMPTY STRING Program PGMCR1001: Line 99, Improper data type. I can eliminate the error with the following code: STATE2 = '' FOR I = 1 TO LEN(STATE) STATE2 := STATE[I,1] NEXT I STATE = STATE2 Is this a bug? It looks that way to me. -John ___ 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] Null character causes odd UV behaviour
I think if you looked at the hex values of Char(128) you would see two characters. Convert will only change one character for another (same size). Swap will change characters of any size to characters of any size. SWAP CHAR(128) WITH IN STATE should work if I remember right. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, September 16, 2009 7:58 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Null character causes odd UV behaviour Indeed. I'd call IBM or my VAR if I were you. And thanks for the mention! Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell: 650-207-3235 - Original Message - From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed Sep 16 17:54:12 2009 Subject: Re: [U2] Null character causes odd UV behaviour -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, September 16, 2009 5:16 PM To: U2 Users List Subject: Re: [U2] Null character causes odd UV behaviour Try SWAP instead of CONVERT. I can't find any UV documentation on the syntax for SWAP, and it what I tried wouldn't compile, but it looks like UV BASIC just can't see the null character as a character. Thanks to a suggestion from Laure Hansen I tried writing the value out to a file, and it is definitely character 128: Top. : P 0001: ^128 Bottom at line 1. I was able to work around it with: IF LEN(STATE) = 0 THEN STATE = '' Seems like a bug to me, though. Thanks, John ___ 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] More questions on indexing
I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, July 16, 2009 3:00 PM To: U2 Users List Subject: [U2] More questions on indexing Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2009 CIGNA == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More questions on indexing
I usually do a TERM 132,999 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, July 16, 2009 3:19 PM To: U2 Users List Subject: Re: [U2] More questions on indexing Thanks, Rod. One more thing. I've written a test program to simplify index creation and building. When I run it under type U or type P using BUILD.INDEX or BUILD-INDEX, it gives me the Enter New line to continue... prompt after each screen of *'s. Definitely not desirable for an automated process. It doesn't do this at TCL. How can I work around this? I'd rather not throw a bunch of DATA statements in there. EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY' DATA 20 EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY' EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY' TIA, Brad. Please respond to U2 Users List I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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] More questions on indexing
One more thing that we do. We build a database of our indexes every night using a 'cron'. It does a find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level. The results of this 'find' are then passed into a Unidata program. Using a combination of LIST.INDEX and INDICES we get all the info we need to build the index and write a record to a database using the FILE.NAME as the key. We then have a process to rebuild indexes using this database. So if I want to re-build an index. I just type REBUILD.INDEX file name and everything gets redone. This is really nice for when you have a file with 10 indexes and you want to rebuild it. -Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, July 16, 2009 3:25 PM To: U2 Users List Subject: Re: [U2] More questions on indexing I usually do a TERM 132,999 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, July 16, 2009 3:19 PM To: U2 Users List Subject: Re: [U2] More questions on indexing Thanks, Rod. One more thing. I've written a test program to simplify index creation and building. When I run it under type U or type P using BUILD.INDEX or BUILD-INDEX, it gives me the Enter New line to continue... prompt after each screen of *'s. Definitely not desirable for an automated process. It doesn't do this at TCL. How can I work around this? I'd rather not throw a bunch of DATA statements in there. EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY' DATA 20 EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY' EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY' TIA, Brad. Please respond to U2 Users List I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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] General guidelines on indexing
We used to us the DIM approach as well. But having the process blow up a couple of years later because the DIM array was not large enough to accommodate the data caused us to go the work file method. The DIM array was fast, but needed to much upkeep. And after Sarbanes-Oxley, making changes to programs took a whole new perspective. But that is another rant for another time. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Ward Sent: Thursday, July 09, 2009 9:24 AM To: 'U2 Users List' Subject: Re: [U2] General guidelines on indexing Original test and a couple of other variations. We use the DIM approach in several cases where variable data is large and temporary. Test system run on WindowsXP Single DuoCore @2.20ghz 2GB Ram Original version - -1 variable append Elapsed Time 00:25:04 Altered version - Using WRITESEQ - Same System 1.203 seconds Altered version - Using DIM Variable - Same System 0.172 seconds ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2009 CIGNA == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
When you have a file with 50 million records, it does not matter how you build the or parse the dynamic array. A well sized work file will run circles around the dynamic array. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:12 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing After indexing, we made a lot more use of the SETINDEX and READFWD logic in our programs. I find this curious / disappointing - is it really the case that unidata can't take the mix of indexed / unindexed dictionary items and do just as efficient a job as the code you're writing? Also, the performance of dynamic arrays need not be as much an issue as you've found. If they're built up with -1 rather than a counter then the speed penalty of adding items to a very large list is much the same as a tiny one. Then, when you loop through them for further processing use the REMOVE (or FORMLIST) command rather than a counter. The only real issue with dynamic arrays is if the machine does not have the physical memory available to hold the variable. Ed --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. --- ___ 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] General guidelines on indexing
In theory, I would have to agree with you. Who knows how all this stuff really works under the hood. You have Unidata Shared memory management and shared basic code server. We also have a huge SAN with a lots of cache. Measuring performance and impacting it is different these days. There are so many layers and events, finding the bottleneck can be tricky. All I can tell you is that we did extensive testing and we would not be doing what we are unless it worked. Maybe on you site, on your server and your database, these techniques don't enhance performance. I'm telling you what we found, your mileage may vary. We have been told to use concatenate with a @AM to build our arrays, as Unidata has a pointer to the end of a variable. We have been told to use REMOVE when pulling data out of the array. We know that. We still had performance gains that went from days to hours when we changed to a well sized work file. There are many reasons why we use the work file. Typically this is used in the selection part of the process. The sorting and reporting is after. Sometimes the work file contains more than keys ( vs. having multiple dynamic arrays). Sometimes multiple reports are generated from the same work file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:47 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing I don't agree. Disk access is inherently slower than RAM access. Therefore a process that makes efficient use of RAM will be faster than an equivalent algorithm making efficient use of disk. In your case, it's just a matter of scale: 50 million records at (lets say) 14 bytes per ID plus the multivalue marker needed to build up the dynamic array. 15 * 50,000,000 = 750,000,000 bytes. That's 732,422KB, 715MB If your process is running on a modern server then this kind of op becomes practical. Assumptions: - that the dynamic array isn't using Unicode. If it is then memory reqirements double. - That you select every record - normally (presumably) it would be just a fraction? In fact isn't all of this theoretical? Using the index select / readfwd / own tests method, there's no need to build workfiles or dynamic arrays at all - simply do the tests as each record is retrieved with readfwd and then create the report / do the processing all within the same loop? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 08 July 2009 12:30 To: U2 Users List Subject: Re: [U2] General guidelines on indexing When you have a file with 50 million records, it does not matter how you build the or parse the dynamic array. A well sized work file will run circles around the dynamic array. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:12 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing After indexing, we made a lot more use of the SETINDEX and READFWD logic in our programs. I find this curious / disappointing - is it really the case that unidata can't take the mix of indexed / unindexed dictionary items and do just as efficient a job as the code you're writing? Also, the performance of dynamic arrays need not be as much an issue as you've found. If they're built up with -1 rather than a counter then the speed penalty of adding items to a very large list is much the same as a tiny one. Then, when you loop through them for further processing use the REMOVE (or FORMLIST) command rather than a counter. The only real issue with dynamic arrays is if the machine does not have the physical memory available to hold the variable. Ed --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services
Re: [U2] UV UOJ hung sessions
Do you have truss or a trace command at UNIX that can track what the PID is doing. It is pretty low level stuff, but if it is doing any file IO, you can see that and maybe see what is going on. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Monday, June 29, 2009 3:46 PM To: U2 Users List Subject: [U2] UV UOJ hung sessions We have an issue where UOJ sessions initiated by our web app server occasionally get hung. This is a rare occurrance, but when it does happen the end user on the site usually repeats the action that causes it enough times to chew up a large number of UV licenses. The sessions remain until killed via kill -9 at the linux OS level. We had this problem once in the past and were able to track down the offending UV BASIC subroutine via PORT.STATUS because of a unique EXECUTE 'SELECT ...' within the program. We're not so lucky this time and PORT.STATUS is not providing any useful info that would point to what subroutine was called. Is there any way to know what the hung session is doing aside from adding code to write out logging info within every subroutine called by UOJ? Maybe something in the /proc filesystem? We're running UV 10.2.7 on RedHat ES 5.1. Thanks, John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2009 CIGNA == ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Resize of large dynamic file
We too do not use memresize to rebuild dynamic files. We have a process that select the original file, breaks the subsequent list up into parts and have phantom simultaneously copy records into the new file based on the portion of the original list that that an individual phantom is given. We have found this to almost as quick as the memresize verb. And we don't get all the extra overxxx parts of the file that memresize creates. I am used to looking at the 'guide' results to figure what block size to use. At the bottom of the guide, you get the ids' of some of the largest records and their size. You also get a view of what percentage of the file has records =512 and = 1024 and = 2048 and so on. Your standard deviation is high. So I have a feeling that a block size of 8 or 16 might work better with your file. Here is a sample of the 'guide' output that I think is helpful in deciding block size. This file has the same problem you are running into. Huge records next to tiny records. This is the downside of multi-values over a period on years. And there is not much you can do. I just recently had to make this file dynamic. Below is how it looks after being made dynamic Basic statistics: File type... Static Hashing File size... 1909768192 File modulo. 89399 File hash type.. 0 File block size. 16384 Group count: Number of level 1 overflow groups... 27163 Primary groups in level 1 overflow.. 10555 Record count: Total number of records. 288052 Average number of records per group. 3.22 Standard deviation from average. 1.79 Minimum number of records per group. 0 Maximum number of records per group. 13 Median number of records per group.. 6.50 Record length: Average record length... 2647.85 Standard deviation from average. 2795.27 Minimum record length... 99 Maximum record length... 267363 Median record length 133731.00 Key length: Average key length.. 14.08 Standard deviation from average. 0.29 Minimum key length.. 14 Maximum key length.. 16 Median key length... 15.00 Data size: Average data size... 2671.93 Standard deviation from average. 2768.48 Total data size. 769654711 Minimum data size... 123 Maximum data size... 267387 Median data size 133755.00 Data in 1 - 512 bytes range. 73149 (25.39%) Data in 513 - 1024 bytes range.. 96984 (33.67%) Data in 1025 - 2048 bytes range. 36724 (12.75%) Data in 2049 - 3072 bytes range. 30213 (10.49%) Data in 3073 - 4096 bytes range. 16530 (5.74%) Data in 4097 - 5120 bytes range. 9881 (3.43%) Data in 5121 - 6144 bytes range. 5760 (2.00%) Data in 6145 - 7168 bytes range. 3848 (1.34%) Data in 7169 - 8192 bytes range. 1940 (0.67%) Data in 8193 - 9216 bytes range. 1492 (0.52%) Data in 9217 - 10240 bytes range 1234 (0.43%) Data in 10241 - 11264 bytes range... 818(0.28%) Data in 11265 - 12288 bytes range... 809(0.28%) Data in 12289 - 13312 bytes range... 567(0.20%) Data in 13313 - 14336 bytes range... 501(0.17%) Data in 14337 - 15360 bytes range... 412(0.14%) Data in 15361 - 16384 bytes range... 320(0.11%) Data greater than 16384 bytes... 6870 (2.38%) Largest data size: 267387 bytes of data for this key... 02325Z5049*1:3 266943 bytes of data for this key... 02262Z6138*1:3 214466 bytes of data for this key... 0315320746*4:4 Smallest data size: 123 bytes of data for this key.. 08339Z6287*1:2 131 bytes of data for this key.. 0730910506A*1:3 131 bytes of data for this key.. 07341Z8969A*1:1 Predicted optimal size: Records per block... 10 Percentage of near term growth.. 10 Scalar applied to calculation... 0.80 Block size.. 16384 Modulo.. 85597 total 5571664 -rw-rw-r-- 1 root mcc 194880 May 28 15:35 dat001 -rw-rw-r-- 1 epopsmcc 288489472 May 28 14:40 dat002 -rw-rw-rw- 1 root mcc 49135616 May 28 15:35 idx001 -rw-rw-r-- 1 root mcc 515047424 May 28 14:40 over001 -Original Message- From: owner-u2-us...@listserver.u2ug.org
RE: [U2] U_shmalloc() failed
We just had one of these where a Dim array was getting filled with data and that caused shared memory to blow. IT was stuffing an entire record in the array and doing it for the same key over and over. As a quick fix, we put a LOCATE in to see if the record was already in the array and that fixed the problem. This was really old code that had never blown up before and hit some new criteria that caused the problem. The whole logic should have used a work file instead of a Dim array. But that is how things were done 15-20 years ago. - Rod -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, May 06, 2009 4:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] U_shmalloc() failed Hi - I have a process that runs overnight that quite often crashes with this error. This is on udt7.2 on RHEL ES 4 64bit My first thought was an item/variable with more that 32Meg of data in it but i really cannot see that happening, I may be wrong on that tho ... Does anyone know why i get this error and if i should be looking toward my udtconf or the code and variable sizes. Cheers Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata File Corruption
There should be a rszx (where xx is some temp file unique Unidata name) file in whatever directory you have defined for TMP (if this is UNIX, do !echo $TMP) that should be the file after it was resized. I am guessing that the memresize got interrupted right at the point where Unidata was copying the rsz file over the top of your TEMP file. I would set up a temporary VOC pointer to the rsz file and see if it looks like the info that you expect to find in TEMP. - Rod -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Wednesday, April 15, 2009 5:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata File Corruption Unidat a 7.1.8 on Solaris 9. I have a file that was mistakenly interrupted during a memresize. Now I if I try LIST, SELECT or guide I get: File size(16908288) is minimum hash file size, blocksize(8192) * (modulo(5147) + 1). TEMP is not a UniData data file TM failed to open file 'TEMP'. I assume at this point I'm SOL. Anyone have other ideas? I have backups and only appear to have 31 records added since the backup was created, but any insight as to how I might recover data would be appreciated. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 Dad, you're talking in grown-up and need to stop. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DataStage and UniData
We have been pulling data nightly from Unidata using Datastage and moving it over to Oracle for at least 10 years. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Tuesday, April 14, 2009 8:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] DataStage and UniData Is anyone live with DataStage and UniData? I am interested in success stories as well as any suggestions for success. In this case the site would be going from UniData to Cognos on Oracle. Thanks. --dawn -- Dawn M. Wolthuis Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DataStage and UniData
We have a staff of 3 people that deal with Datastage and the warehouse on Oracle. I think everything goes smoothly for that group as far as I can tell. We are trapped on an older release of Datastage. I have asked about going to a new release and was told that most of our Datastage jobs would have to be redeveloped in order to go to the newer release. I can't tell you why this is or if it really is true. I think there are some nice features in the newer Datastage products. But apparently this is not a priority as it is not broken and does not need fixing here I guess. I believe Universe is still central to the product we use. I am not sure if this is still the case in the newer releases. If you want to email me, I can put you in touch with one of our Datastage people if you have other questions. - Rod -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Tuesday, April 14, 2009 9:39 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataStage and UniData Good deal. I gather you are happy with DataStage? By the way, does it still have a derivative of Universe inside or did they migrate it to something else? --dawn On Tue, Apr 14, 2009 at 9:24 AM, Baakkonen, Rodney A (Rod) 46K rodney.baakko...@cigna.com wrote: We have been pulling data nightly from Unidata using Datastage and moving it over to Oracle for at least 10 years. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Tuesday, April 14, 2009 8:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] DataStage and UniData Is anyone live with DataStage and UniData? I am interested in success stories as well as any suggestions for success. In this case the site would be going from UniData to Cognos on Oracle. Thanks. --dawn -- Dawn M. Wolthuis Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Dawn M. Wolthuis Take and give some delight today --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SQL a possibility?
Is this Unidata or Universe? In Unidata, when using the Unidata ECL, I could use SAVING SWITCHIT -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, April 01, 2009 4:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] SQL a possibility? I'm trying to save the first field of a .csv file to a select list, Yes, I can write a program, but I also wanted to try to do it on the fly. Using UV10.0.2 , unix on Information format The source data looks like: '#12345566#','first','last',. '#12344555#','first','last',. Basically, field one has the item ID of another file. The source file gets read into a tempory file input file I created an I-desc of the following: SWITCHIT 0001: I 0002: CONVERT(REUSE(@AM),REUSE(@VM),@RECORD) ; FIELDS(@1,REUSE(,),REUSE(1)) ; CONVERT(REUSE('# '),REUSE(''),@2) 0003: 0004: DATA 0005: 20L 0006: M The above will convert the whole record into one mutlivalue attribute, then strip off the first field delimited by the , then strip out the # ,' and spaces LIST FILENAME ITEMNAME SWITCHIT ID-SUPP will list to the screen exactly what I want and so does SELECT SWITCHIT FROM FILENAME WHERE @ID = 'ITEMNAME'; NowHow can I put that data into a saved-list? (Using either TCL or SQL?) for that matter, how do you save a list using SQL on Universe? I tried creating a view, but was told I had to create a schema in order to create tables...that's no fun... I could open a como file, list the output with no headings close the como file, edit it clean, the form-list the como file (work around 1) George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] {UD} SAVEDLISTS list expansion
I am still at 7.1.0. When I have had this GET.LIST problem, I think I was able to get the list using QSELECT SAVEDLISTS. I have never had the SAVE.LIST fail, just the GET.LIST. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Tuesday, November 18, 2008 7:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] {UD} SAVEDLISTS list expansion hmm... per the readme - the following should have been fixed at 7.1.3. Testcase?? Issue 8594 - Problem Description UniData -- When the SAVE.LIST command created an item in the. _SAVEDLISTS_ directory that contained more than 10,000 parts, for example list001, list002, and so forth, a GET.LIST command to retrieve that list only returned the first 9,999 parts. This problem has been resolved. Wally Terhune U2 Support Architect IBM Information Management Software Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 Email: [EMAIL PROTECTED] http://www.ibm.com/software/data/u2/support From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Date: 11/18/2008 02:58 PM Subject:[U2] {UD} SAVEDLISTS list expansion Is there any way to expand the number of items stored in a SAVEDLISTS list? We've hit our system's limit on savedlists size. The limits of 1000 sublist files and 34,815 bytes per sublist are not enough to hold some of our savedlists. Is there any way to expand the sublist file range from 3 to 4 digits to have 10,000 sublist files, or allow more bytes in each sublist file? 34,815 is an interesting number for a limit, it being one less than 34k. I don't see anything in the configuration for it. I was unable to find anything related to this in the UniData docs, nor in the U2 Knowledge bases. UniData: 7.1.10 HP-UX 11.11 Dean Armbruster System Analyst Wolseley North American Division * 12500 Jefferson Avenue * Newport News * VA * 23602-4314 USA T: +1(757) 989-2839 * F: +1(757)989-2801 * E: [EMAIL PROTECTED] www.wolseley.com blocked::http://www.wolseley.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD HP-UX] I need to track user logins
If you have UNIX accounting on the machine, the 'last' command may provide some help. Otherwise I think it will have to come from something written into you Unidata applications. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lunt, Bruce Sent: Wednesday, November 05, 2008 11:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD HP-UX] I need to track user logins Hi All, I need to provide a report that shows what users have not been on the system for the last 90 days. I don't know how to do this and was hoping that someone out there could help me. Thanks in advance, Bruce Lunt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
That is why we discourage developers from using dynamic arrays in programs. Once they get to a certain size, performance goes out the window. We have them store all intermediate program data in work files that sort quickly when well sized. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma Sent: Wednesday, July 23, 2008 10:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? I've been experimenting and discovered something. Instead of waiting until you have all (say) 100,000 elements to sort at once, why not sort them in blocks of (say) 5,000. So I wrote this little subroutine that takes two parameters, a relatively small un-sorted table and the larger sorted table and sorts the un-sorted into the sorted table. The calling program accumulates the unsorted ITAB and when it reaches a certain watermark, say 5,000 elements, this subroutine is called and those 5,000 get inserted into the master sorted OTAB, which initially is null. My experimentation discovered this method to run extremely quickly compared to waiting for the entire 100,000 element table to be built before starting the sort. Try it out! SUBROUTINE HUB.SORT.B (ITAB,OTAB) X2= DCOUNT(ITAB,@AM) FOR X = 1 TO X2 ELEM = ITABX LOCATE ELEM IN OTAB BY AL SETTING PLACE ELSE NULL OTAB = INSERT(OTAB,PLACE;ELEM) NEXT X RETURN END David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office:810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services, and Innovative Solutions -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Marcos Sent: Tuesday, July 22, 2008 7:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? We had the same issue back in the 90's. So a clever guy (Ed) that worked with us wrote a small C program (on Unix) to do the sort. This also included controlling/dependants fields. Any universe program could call it, passing in the variables and returned the items sorted. Speed is incredible. To this day it's still used and blitzes any universe program methods in sorting large arrays. Regards, Jeff Marcos -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, 23 July 2008 6:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Hey, and don't forget to do a speed test. You know, because LOCATE is coded as part of the OS it just *might* be faster than bubble or speed sort options. In fact, this was a topic on this list about 3 or 4 years ago and someone doing the speed test concluded LOCATE was in fact faster. And no I don't remember who it was, or have a link to the thread (sorry) :-) Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:26 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? Note that if the array is big, you would get much better performance by loading it into a DIM array, so the sort of sort below, then put the results back into a dynamic array. Dynamic arrays are much easier to use, but when used wisely, dimensioned arrays can be MUCH faster. This is true for any application, esp. looping through multi-values. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DAVID WADEMAN Sent: Tuesday, July 22, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Basic SORT() Function not avail in UniVerse? This is a UniData subroutine, but should work SUBROUTINE B42.SORT.ARRAY(SORTED,ARRAY) * Bubble sort the elements of a dynamic array * Created by: David Wademan * Creation Date: 01/05/05 SORTED= VALUES = DCOUNT(ARRAY,@VM) LOOP CHANGES = 0 FOR X = 2 TO VALUES * For each adjacent pair ELEMENT1 = ARRAY1,X-1 ELEMENT2 = ARRAY1,X IF ELEMENT2 ELEMENT1 THEN * Swap if pair out of sequence ARRAY1,X = ELEMENT1 ARRAY1,X-1 = ELEMENT2 CHANGES = 1 END NEXT X WHILE CHANGES DO REPEAT SORTED=ARRAY RETURN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker ---
RE: [U2] Basic SORT() Function not avail in UniVerse?
I guess my point was a little off topic, as I was really calling attention to performance issues with dynamic arrays in general and not about sorting keys. When dynamic arrays can out perform work files, we will use them. We have seen processes that used dynamic arrays run for a week. Even with doing REMOVE and using concatenation to build the array. Changing the logic to use a work file resulted in the same process finishing in hours. The other aspect is that a lot dynamic arrays in programs do more that just hold keys. Doing a locate on one array may result in multiple data elements being inserted into corresponding arrays. With this type of intermediate data, writing and sorting a work file will run circles around internal arrays. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: Wednesday, July 23, 2008 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Basic SORT() Function not avail in UniVerse? I've done research on sorting in the past, working with 100,000 to 1,000,000 element lists. Allen: LOCATE's are faster, but only when you're dealing with less than 100 elements. Because LOCATE's must start at the beginning of a string and traverse the entire length, they get slower and slower. Bubble sorts are also useless when dealing with a large number of elements. Jeff: Yes, a C program is the fastest (at least it was at my last job where we used GCI to integrate it with the universe shell.) As for writing out ids to work files just to sort them, it adds unnecessary overhead to the whole process. I wish universe had an intrinsic sort() function. Since they don't I wrote my own and posted it on PickWiki. You could also use the QuickSort sample posted in this thread. Once you standardize on a particular sorting program, you'll be amazed at the number of times it comes in handy. http://www.pickwiki.com/cgi-bin/wiki.pl?Sorting http://www.pickwiki.com/cgi-bin/wiki.pl?ShellSort http://www.pickwiki.com/cgi-bin/wiki.pl?QuickSort Another handy function is to be able to flip fields to values and vice versa. See http://www.pickwiki.com/cgi-bin/wiki.pl?Row2Col and again it's optimized for a large number of elements. rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] File Sizing for Unidata on Windows
We are on UNIX, but this gives you an idea of what we do. We have a 'cron' that looks at the date/time stamp on files at a Unix level (UNIX 'find' command using -mtime -1). If the file was updated in the last 24 hours, then we have a Unidata program go through and figure out if the file is a Unidata file. If it is a Unidata file, it puts it in a UNIX flat file called 'guide.input. Then a 'guide -i guide.input -d3 -r /usr/ud/RAW/STAT-FILE' is run to build a database of Unidata file stats in STAT-FILE. Once a month we have an 8 hour outage to do sever maintenance and any file resizing is done at that point based on what 'guide' recommends. That works fine for static files. Dynamic files are a different issue, as 'guide' does not help much with recommendations with dynamic files. I usually look at a UNIX level to see how many 'overxxx' parts I have in the file directory. If I have more than 1 or 2, I look at recreating the file. I don't use 'memresize' for dynamic files, as it has a number of short comings. It works, but it does things like create an 'overxxx' part for every 'datxxx'. I have one file that has 31 'dat' segments and just one 'overxxx' part, over001. If I used memresize, I would also have 31 'overxxx' parts. memresize also does not allow for use of the TMPPATH parameter. So you need to be able to hold 2 copies of the file you are resizing in the file system where it lives. So I instead create a new file in another file system with the MOD and Blocksize that I want. Then we have a verb called PHANTOM.COPY. PHANTOM.COPY will use a Unidata list to do the copy. It breaks the list up into how many ever PHANTOMS I specify to use. So the statement in Unidata would look like: PHANTOM.COPY FILEA FILEB LIST.NAME 12. This would take LIST.NAME, break it up into 12 lists and pass each list into another PHANTOM that would copy 1/12 of FILEA into FILEB. So I have 12 simultaneous copies running building the new file. It turns out to be almost as fast as 'memresize' and I don't have all the extra 'overxxx' parts in the file directory. Which in turn makes it easier for me to monitor whether my dynamic files need attention. Since you are on Windows, this maybe does not help much. But maybe there are ways on Windows to do something similar. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Laura Hirsh Sent: Friday, February 15, 2008 11:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] File Sizing for Unidata on Windows Hi all, I'm working on a project, and wanted to get some feedback regarding others experiences. The issue is resizing files for a substantial database. Im curious about what tools and experiences people use when trying to do the same thing. What rules of thumb are being used to calculate modulo and block size? How often do people schedule file resizes? Is it system wide, or on a subset of files? How do folks manage scheduling resizes in a 24x7 shop? Some folks recommend FAST, other folks have suggested using the information available via !guide or file.stats, and then do a !memresize. The interesting thing is that each of these methods seems to come up with a different new size recommendation, and as a result, there is a lot of trial and error. Anyone want to share their experiences? Id love to hear them. Thanks in advance, Laura --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and Shadow copy on Windows 2003
We have a UNIX script that does a 'wall' warning people that they will be logged off in 6 minutes and 2 minutes If they are not off: /usr/ud/bin/listuser | egrep 'udt|phantom|unijdbc' | awk '{print deleteuser $2 }' | ksh and they usually are gone. Sometimes on Solaris, the UNIX Pid will be gone, but listuser will still show the process. So we end up having to do a stopud -f as a last resort. So, what is the best way to log users off cleanly in mass? === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === Sometimes I wake up grumpy. Other times I let her sleep. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Downed filesystems killing 'udt' sessions
We have also seen this situation where the machine almost goes into a panic when the NFS mounts don't respond. I think we made the problem less severe with a Solaris mount option. These are the options I currently see when I look at our NFS mount on our production box. The 'soft' option may be the one that made the difference. But I am not the UNIX admin who figured this out either. remote/read/write/setuid/soft/bg/xattr/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Pflueger Sent: Thursday, September 06, 2007 10:22 AM To: U2 User Group Mailing List Subject: [U2] [UD] Downed filesystems killing 'udt' sessions There have been several occasions where on our Solaris machine (which hosts both Oracle Unidata 7.1.0 simultanously! -- yeah, don't get me started there, lol) that some NFS mounts may go offline and become responsive. This interrupts momentarily our new active 'udt' sessions while this mounted filesystem is unresponsive. I guess my question is, has anybody else encountered this and know of a good workaround to preventing 'udt' sessions from seeming to freeze until these filesystems become available? Is there a way to have Unidata configured to only check pre-determined filesystems ignore others? TIA, Andy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Replication under Windows
I am glad to hear someone using replication and having a success story. Is anybody using it on UNIX? The only site I know of that tried it on UNIX did not have enough horsepower on subscribing side and had stop using it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Wolverton Sent: Thursday, September 06, 2007 3:48 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Replication under Windows --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sacred Licence Seat - A Challenge
Does this work for Unidata also? Does it have the same name? - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sara Burns Sent: Tuesday, August 21, 2007 4:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sacred Licence Seat - A Challenge 4) To my knowledge, VB UniObject and UniJava sessions do not go through LOGIN or UV.LOGIN. We use the UVCS.LOGIN paragraph to set variables like the European Date format. I believe this gets called for uvcs sessions. I cannot remember how we found out about this. Sara Burns Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] AIX Argument list too long
I usually us the 'find' command with the '-mtime' to pare down the list of files in the directory that I am dealing with. For Instance, if I wanted to look at all files over 30 days, I would: (I am assuming that I have do a 'cd' to the directory. Otherwise the '.' in the command needs to be a directory path) find . -type f -mtime +30 -exec ls -l {} \; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 21, 2007 8:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] AIX Argument list too long Hi all. This is a bit off-topic, but I believe the expertise is here. . . I have routines that parse through Unix files in a directory and remove them based on age. If the number of files exceeds some limit I've not been able to narrow down, I get a response from the scripts that it can't do the job because there's too many files in the directory. Does anyone know: 1. what I'm talking about and what causes it? 2. how to solve this through some tunable parameter, preferrably not requiring a kernel rebuild? TIA, -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Binary data corruption on copy
Why don't you just put in a 'DIR' type file, or a number of DIR types if there will be a lot of files in there? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: Tuesday, August 21, 2007 12:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy That $ trick is probably specific to pi/open. I normally convert this kind of file to hex before storing in unidata. If there's a better way, I would like to know about it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Tuesday, August 21, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Binary data corruption on copy A question for the group: I have JPG format records which I wish to copy from unix level into a Universe file but am having trouble with it getting 'corrupted' during the copy. We are converting from pi/open to universe. I can do this business in pi/open by changing the name of the source file, prepending it with a $, then copying at TCL level into the pi/open file. For example, if the record at unix level is named 1234.jpg and is in the directory SOURCE I run this command at unix level: mv 1234.jpg \$1234.jpg which changes the name. Now at TCL level in pi/open I can issue the command COPY FROM SOURCE TO IMAGE_FILE $1234.jpg After that, I can change the name back within the pi/open file: CNAME IMAGE_FILE $1234.jpg 1234.jpg and the copy is complete. Pi/open knows that if the record name starts with a dollar sign that it is binary and should not be changed. Once the copy from a unix directory into the pi/open dynamic file is done I can use it successfully. In Universe I attempt to do the same thing. The 1234.jpg name is changed to $1234.jpg and then copied into the Universe file UNIV_IMAGE_FILE, a dynamic (type 30) file. But it doesn't work very well - the image is corrupted, the binary file was messed with during the copy. I know the jpg record is intact before I start the copying. I wouldn't need to bother with a copy to a Universe file, in fact, except that we have over 130,000 images now and I can't believe a unix directory could successfully handle that many records. Any suggestions on copying so that the binary remains intact? Thanks- Harold Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to use LOCATE in an I Descriptor
I think you can use INDEX or FIELD or EXTRACT. I don't know that I have ever seen LOCATE. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Doug Farmer Sent: Thursday, August 09, 2007 1:44 PM To: u2-users@listserver.u2ug.org Cc: Vicki Gabler Subject: [U2] How to use LOCATE in an I Descriptor I have someone asking me how to use a LOCATE statement in an I Descriptor. I have never done that and would not know if it is possible, or what the syntax is. Does anyone know if you can do this, and what the syntax would be to use the resultant location? Thanks Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Converting static to dynamic
We have a dynamic file that is 65 gig. I would recommend that you invest some time experimenting with split/merge params and even possibly KEYDATA to see what works best with your file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan Leckie Sent: Tuesday, July 24, 2007 3:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] Converting static to dynamic We have two very large files from which I often have to remove data to stop the files reaching the 2GB limit, much as I enjoy removing this data my colleague has suggested that changing these files to be dynamic would mean we could allow them to hold more data and choose when to remove old data rather than be forced to. Does any one have any experiences that they wish to share regarding changing files in this way, e.g. file performance before and after, any practical steps required after conversion etc.? We are running red hat enterprise Linux 3 and unidata 6. -- A Striker is the same as a Keeper. -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Converting static to dynamic
KEYONLY would not work for us for the most part. We have File Keys that were 10-15 characters. Our record sizes would be 300-800. So we would never get enough Keys in a group to cause splitting. KEYDATA works fine in 90% of our files. But we have files that have meaningful keys that do not hash well. Keys like this do poorly with hashing in Unidata: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] And they are a disaster with KEYDATA. Splitting happens continuously as the hashing causes records to hash to the same groups even after the split. So I had to go back to KEYONLY and I manually have to resize these files with meaningful keys on a yearly basis. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Davis Sent: Tuesday, July 24, 2007 8:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Converting static to dynamic Use hash type 1. Use KEYONLY splitting. Choose a reasonable starting modulo Experiment with SPLIT.LOAD and MERGE.LOAD. The file will probably be twice as slow as a perfectly sized static file but who cares. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Leckie Sent: Tuesday, July 24, 2007 4:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] Converting static to dynamic We have two very large files from which I often have to remove data to stop the files reaching the 2GB limit, much as I enjoy removing this data my colleague has suggested that changing these files to be dynamic would mean we could allow them to hold more data and choose when to remove old data rather than be forced to. Does any one have any experiences that they wish to share regarding changing files in this way, e.g. file performance before and after, any practical steps required after conversion etc.? We are running red hat enterprise Linux 3 and unidata 6. -- A Striker is the same as a Keeper. -- * This message has been scanned for viruses and dangerous content by * Blairs MailScanner, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs * via email at [EMAIL PROTECTED] * * Name Registered Office: * -- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unix cat help
Maybe some UNIX guru has a more elegant way than this. I do a lot of shell scripting. So the easiest way to do this was with a script. I am using korn shell for this. Most U2 people I know avoid shell scripts. I wrote a quick somewhat generic script to do it called rod.test. You give it the two file names that you are combining. Here is the script: # cat rod.test #!/usr/bin/ksh -x #script to combine and sort two unix files script=`basename $0` newfile=newfile if [ $# -lt 2 ]; then echo \n Usage: ${script}: file1 file 2\n exit 1 fi cat $1 | awk ' { print file1* $1 } ' $newfile cat $2 | awk ' { print file2* $1 } ' $newfile sort $newfile -t* -k2 The -x in line one will run it in debug mode so you can see each line as it executes: ./rod.test file1 file2 + + basename ./rod.test script=rod.test + newfile=newfile + [ 2 -lt 2 ] + awk { print file1* $1 } + cat file1 + 1 newfile + awk { print file2* $1 } + cat file2 + 1 newfile + sort newfile -t* -k2 file1*line1 file2*line1 file1*line2 file2*line2 file1*line3 file2*line3 If you want to put the output in a third file, add sortedfile to the last line: sort newfile -t* -k2 sortedfile Hope this helps. Also hope I understand what you wanted. If not let me know. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 4:37 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unix cat help Hi all, Hopefully there is a way to do this... I have 2 unix flat files that I want to merge into 1 file. I know that I can do something like cat file1 file2 | sort -o newfile. The problem is that once I have newfile loaded, I need to know where each line in newfile came from. I am hoping that unix has something similar to the REUSE() function so I can prefix each line with the filename. Here is an example of what I would like to get done. before... /sws/scott/temp: pg file1 line1 line1 line1 line1 line1 line2 line2 line2 line2 line2 line3 line3 line3 line3 line3 /sws/scott/temp: pg file2 line1 line1 line1 line1 line1 line2 line2 line2 line2 line2 line3 line3 line3 line3 line3 after... /sws/scott/temp: pg newfile file1*line1 line1 line1 line1 line1 file2*line1 line1 line1 line1 line1 file1*line2 line2 line2 line2 line2 file2*line2 line2 line2 line2 line2 file1*line3 line3 line3 line3 line3 file2*line3 line3 line3 line3 line3 Thanks in advance for any thoughts you may have. Scott Thompson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate V6 break key woes
I did get Crtl-C to work. But it took some experimenting. So I am not sure that I know all the steps that I did to get it working. I gave someone else the settings that I had and they say it still does not work. The setting that finally allowed me to use Crtl-C was to go into Setup, Keyboard and define my break key as Crtl-A. When I am in Unidata and press Crtl-A, I end up at UNIX. But Crtl-C does now get me into the Unidata debugger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Pflueger Sent: Wednesday, June 13, 2007 7:26 AM To: U2 User Group Mailing List Subject: [U2] wIntegrate V6 break key woes Hello, Recently, I have installed wIntegrate Version 6.0.4 on my WinXP Pro machine for evaluation use. So far, I really like its enhanced features but have noticed one difference between the previous version which I had loaded. My defined break key is reacting differently. Always before I could use Ctrl-Pause/Break to break a program to the debugger. Now, with the new 6.0.4 version, neither Ctrl-C or Ctrl-Pause/Break will break a program to invoke the debugger. Moreover, the Ctrl-Pause/Break will abort the connection with the server altogether. Has anybody seen or encountered this issue before and how can I change the behavior of the Ctrl-Pause/Break to NOT close the host connection but instead just break the program for the debugger? Thanks in advance, Andy Pflueger Ivy Hill Corporation Louisville, KY Unidata 7.1.0 Solaris 8/9 wIntegrate 6.0.4 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Union Query
MERGE.LIST has a UNION option. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Ed Sent: Wednesday, May 16, 2007 9:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Union Query Has anyone developed or know of a way to do the equivalent of a UNION query in UniData? I have 2 files, one is a daily file and the other is a monthly file. At night the daily records get moved into the monthly file and the daily file gets cleared. At month-end, the monthly data gets moved into a history file and the monthly file gets cleared. You know the drill. Both files are structured identically and share the same dictionary. I would love to do something like: SORT DAILY.FILE AND MONTHLY.FILE WITH DATE = 5/1 BY DATE DATE PART.NUMBER DESCRIPTION BIN TOTAL QTY I stared writing a program called UNION.SORT that I would use instead of SORT. Parsing the Uniquery statement started to get hairy (and I don't have that much time to devote to this) so I put it down. If REFORMAT or SREFORMAT had a way to move the entire record into the new file instead of just the dicts listed, I'd be home free. I also don't want to re-write our application to populate the monthly file at the same time we populate our daily file (then just clear the daily file at night). Any ideas, suggestions? Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 973-615-9880 cell [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UOLOGIN
Can you tell me where the UOLOGIN documentation is? I search the Unidata manuals for 7.1 and can't find any reference. - Thanks Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 11, 2007 4:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] UOLOGIN All Is the UOLOGIN feature for UniObjects supported on UniVerse, or is it UniData only? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case and Editors
You could put an IF @LOGNAME = and fix it in the LOGIN Paragraph for yourself. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Arnold Bosch Sent: Thursday, March 15, 2007 4:56 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case and Editors Thanks Craig - I'm aware of PTERM -CASE INVERT. Unfortunately updating the LOGIN paragraph is not an option, as it impacts 75+ other users. The best I can do is to manually issue the command each time I get to TCL. So sometimes one has to suffer at the expense of others :-) Regards Arnold -- Craig Bennett [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 15/03/2007 11:54 Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] Upper Case and Editors Hi Arnold, I haven't really been following this thread -- I gave up and learned to love THE BOMB years ago (despite coming to UV from a C background). With all the above (and more!) happening, I find it annoying having to switch caps-lock all the time - what happens a lot is that I switch to another window and start typing away merrily, only to realise after a couple of words that everything is cASE iNVERTED, or that the help I'm trying to give to a user is not working because of case inversion. If you are running UV then issuing PTERM -CASE INVERT at TCL or in your LOGIN paragraph will apply case inversion just to the session you are logged into. It might make life simpler for you. Sorry if this was covered elsewhere in the thread. regards, Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] CALL @progname
If you were going to cover all the possible bases, you would need to do the: 1. VOC 2. OPEN 'CTLG' and read that. This covers 'LOCAL' catalogs 3. CREATE a temporary VOC entry where att1 is 'DIR' att2 is @UDTHOME/sys/CTLG/(first letter of program name) OPEN this file and read using program name as the Key Hoepfully somebody will come up with something simpiliar. But these are the three places I know of where object code can live. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Wolverton Sent: Thursday, March 15, 2007 9:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] CALL @progname I am writing some code that will execute a variable passed in progname using CALL @progname. Question - what is the 'best' way to know that progname exists before I attempt the CALL. I thought about reading the VOC, but if it's globally cataloged, that won't work. I could read the VOC and then the CTLGTB -- but that was two reads just to 'know' the routine wasn't going to blow up. Is there a more efficient or systemic way to do this? **Typically** progname will reference a real program, so this testing is 'overhead' for 99.9% of the time - but if someone were to pass in a bad 'progname', I want to be more graceful (and secure!) just falling over. Since some of the calls will come from 'web connected' clients, and some of the clients may not know for sure that the host cannot handle the request - if the client has a different function list than the host at that point and time... I'm just trying to plan for 'worst case'. How do others handle CALL @ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Guide
Don't forget to use the -r option so that it builds a database of your guide statistics. Then you can run uniquery reports off the stats. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn Sent: Tuesday, March 13, 2007 1:25 PM To: u2-users@listserver.u2ug.org Subject: [U2] Guide Hello again group. Now I'm trying to sort out guide and other tools that one might use to examine and evaluate ones file system. I can find help on GUID in the HELP GUIDE from TCL and I can find it in the admin manual. But when I type it, nothing happens. Do I need to install something? Somewhere I found the suggestion to run FILE-STAT, which I can do. But it doesn't offer anywhere nearly the level of detailed information that I see documented in guide. I'm on windows, is guide a unix only thing or something? All help appreciated. (Still plugging away on the file pointer issue, thanks again to everyone who had an idea on that.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Just to add one more possible complication to your scenario. Depending on the software or the UNIX admin people, you may need to worry about symbolic links at a UNIX level. For example, lets say you are in Unidata in the directory /usr/ud/ROD. In the VOC for this directory is a file called RODS.FILE, where the VOC entry looked like: 1. D 2. RODS.FILE 3. D_RODS.FILE It would appear that this file lived in the current directory where the VOC is. But at a UNIX level, there could be a symbolic links that says: lrwxrwxrwx 1 root udtgrp 34 Mar 6 20:18 ROD.FILE - /usr/ud/SUSAN/RODS.FILE So RODS.FILE is really lives in another directory called SUSAN. The person doing this should have changed the VOC pointer. But a lot of times UNIX (Unidata phobic) types will move the file to keep a file system from filling up and create a symbolic link to where it lives now. Just thought I would throw that scenario out there just in case you had not thought about it. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Help with File Pointers Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe vs. Unidata
On Unidata, I saw a Unibasic tips write up from long ago. It said concatenation was faster than using a -1 to build an array. The speed came from the fact that Unidata knew where the end of a variable was. So using concatenate, the process could jump to the end of the variable to add an element to the array. Where as -1 had to traverse the entire array from the beginning every time. I don't know if this still holds true. But I still use the practice. ARRAY = '' DELIM.VALUE = '' FOR VC = 1 TO SOME.VALUE.COUNTER (some processing to get a THE.NEXT.VALUE set) ARRAY := DELIM.VALUE:THE.NEXT.VALUE DELIM.VALUE = @AM NEXT VC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Monday, March 05, 2007 11:12 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe vs. Unidata Please share what you consider 'Good Programming Practices'. I've inherited thousands of programs during my decades with MV and I have some methods that I like and many that I don't. I'm interested in another programmers opinions. In particular, I thought that EXTRACT was not taught anymore as the nomenclature works as well. I use the construct incredibly often except when I know that I am dealing with a dynamic array to parse through and it may contain 10,000's of rows. Then REMOVE is by and large the more effecient. I would not want to use REMOVE for simple data field extractions. I use REMOVE for EDI or other parsing projects. REMOVE proved incredibly faster than or EXTRACT with large files. That was on a D3-W2K system if you're keeping score. Thanks Mark Johnson BTW, I wrote a utility that will convert the functions EXTRACT, DELETE and REPLACE with their equivilent forms in any source code. I leave INSERT alone as its replacement is too platform specific. - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 05, 2007 11:13 AM Subject: RE: [U2] Universe vs. Unidata Thanks, Drew. My bet's riding on REMOVE. I hope some have found this information helpful. If I get the chance, I'll try to do a more thorough testing of the various dynamic array extraction methods (EXTRACT vs REMOVE, primarily) on each platform to help identifiy good programming practices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] anonymous ftp commands
You could do a ping server and see if it is alive. We also do a post ftp process after we 'put' a file on another server. We go back to the other server via ftp and do a 'dir' on the directory looking for the file so we can capture the size to make sure the whole thing made it. That all gets put into an email and sent to the person responsible for the ftp. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 27, 2007 3:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] anonymous ftp commands Hi all, There is an external application that sends data to our system via ftp that I want to monitor. I would like for this user to execute a unix touch on a file in their home directory using the ftp quote command (quote SH -C touch ./myfile). This would tell me that their server is up even though there is no data to send. The problem is (i am guessing) that they do not have authority to the touch command. I thought I could copy the touch command into the users home directory to get it to work but it did not. I looked at a file called /etc/ftpd/ftpaccess but nothing jumped out at me in there. Can anyone tell me if what I am trying to do is feasible and if so what I am doing wrong? Thanks
RE: [U2] Universe vs. Unidata
We have taken to using work files on Unidata rather than dynamic arrays. Whatever you are doing the locate on to build the array becomes the key to the work file. We cut processing time on some of our large programs from days to hours switching from dynamic arrays to well sized work files. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Drew Henderson Sent: Tuesday, February 27, 2007 5:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe vs. Unidata Hello, all. We are in the process of moving to a new ERP solution which runs on Unidata. Our legacy system runs on Universe. In running some processes on each system, we are seeing some performance differences; in particular, running programs which make liberal - though not particularly efficient - use of dynamic arrays on our legacy (Universe on Linux) system run orders of magnitude faster than the same programs on a much larger system (Unidata on AIX). In the process of determining the origins of these problems, I want to rule out any Universe vs. Unidata issues. My question is this: does Universe handle the random searching of dynamic arrays (such as VAR1 = VAR2x) better than Unidata? Thanks, Drew -- -- Drew Henderson There are two types of people - Dir. for Computer Center Operations those who do the work and those [EMAIL PROTECTED] who take the credit. Try to be in the first group, there is 110 Ginger Hall less competition. Morehead State University Indira Ghandi Morehead, KY 40351 Phone: 606/783-2445 Fax: 606/783-5078 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData Application Monitor
I wrote a 'cron' that running a Unibasic program that wakes up every 5 minutes and does a 'sbcsprogs' The program parses up the 'sbcsprogs' output updates a Unidata file to keep track of program usage. But if something runs really fast, I have a chance of never catching it in the shared basic code server. And if you are not using the global catalog, this does not help. I am not sure how you would track CPU usage for a program. Unidata profiling is good for seeing where a program execution spends it's time. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gordon J Glorfield Sent: Friday, November 03, 2006 4:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData Application Monitor Gee! That would be nice to have. I've never heard of anything like that though. If you find something please share with the rest of us. Here at our shop we added some monitoring to our menu system. That gives us the frequency of use for the programs in the menu but it does not go as deep as what you want. Good luck. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 11/03/2006 04:11:37 PM: Hello all, I am trying to search for a monitoring tool for UniData UniBasic applications and am getting no results at indexinfocus.com. The search engine appears to be hosed. Anyone have any suggestions? Specifically, we want to know things like, how often a subroutine is called, how much cpu programs use (top is ok for this but uses a lot of computer just to provide the results), what applications are cataloged globally and have not been used at all for a specified timeframe. Things like that. We run on unix. I'm on digest, so I won't see your answer(s) right away. TIA! Shaun P. Ferguson Sr Program Analyst Ferguson Enterprises, Inc. This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata dynamic file tuning
I have had some good experiences with KEYDATA. But I think KEYDATA will use slightly more disk space. The only time I had problems with KEYDATA was when the keys to the file did not hash well (meaningful keys with a '#' separator followed by a 2 digit number). If you have sequential keys, this should not be a problem. I think KEYDATA works better for dynamic files that have a small number of characters for a key and a large record. I don't see your key size info here. I don't think your current configuration will result in splitting. You probably never get enough keys into a group to cause a split. I like to look at the UNIX listing of a dynamic file to see the relation of datxxx to overxx files. I have one KEYDATA dynamic file (our largest), that has 22 datxxx files and one over001 file. The size of the over001 file is 746 meg. So 99% of the data is in the dat portion of the file where the hashing should be able to get to it quickly. When I first converted this file to KEYDATA, the result of the rebuild had 19 datxxx files and one over001. So splitting has added 3 more dats, dat020, dat021 and dat022. The file pre KEYDATA was 8 dat's and 8 over's. Performance was not good prior to the KEYDATA conversion. It is very good now that I have it as KEYDATA, as almost none of the file is in overflow. But that said, KEYDATA can have it's pitfalls. The bad file I had would split and split continually. It was sucking up major disk space. And when I looked at the GROUP.STAT, I would see chunks of groups with zero records in them. The meaningful keys would never hash to the new groups that we added to the file. I tried HASH TYPE 1, but that was even worse. So I went back to KEYONLY for those files. One other thing I have found with dynamic files. (I guess this would apply to large static files as well). Indexes that grow a lot need to be rebuilt from scratch periodically. The file from above with 22 dats was just rebuilt. It started out with 7 idx segments. After the rebuild of the indexes, there were only 5 idx files. So the indexes compressed down and saved me close to 4 gig in space. I would experiment with KEYDATA with the file you sent info on. I think it looks like a good candidate. Especially if the file has a lot of data in the overxxx part of the file vs. the datxxx. The trade off is performance vs. more disk space used. This probably has gone on long enough. I could branch into a discussion about why I don't use memresize on dynamic files. But I think I covered that a while ago. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeffrey Butera I' Sent: Monday, October 23, 2006 8:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata dynamic file tuning I'm seeking advice on tuning a dynamic file in Unidata. In short, the file has a numeric (sequential) key and contains only about 10 small fields: date, time, user, etc and a single 'large' field: a block of text. The text can be anywhere from one sentence to pages in length, hence I know this is going to be a lumpy file as the records will vary wildly in size. Records will never be deleted, and we add about 4000 new records/month. I converted this from static to dynamic knowing I'd hit the 2gig limit in a couple of years. The file is behaving fine, I'm just trying to see if I can find some better parameters for it, and a dynamic files are my weakest area in Unidata. Here are the current parameters: File name(Dynamic File) = H08.CR.FF.TEXT Number of groups in file (modulo) = 15511 Dynamic hashing, hash type= 0 Split/Merge type = KEYONLY Block size= 4096 File has 15294 groups in level one overflow. Number of records = 133578 Total number of bytes = 180532137 Average number of records per group = 8.6 Standard deviation from average = 1.1 Average number of bytes per group = 11639.0 Standard deviation from average = 6392.6 Average number of bytes in a record = 1351.5 Average number of bytes in record ID = 6.4 Standard deviation from average = 2080.9 Minimum number of bytes in a record = 51 Maximum number of bytes in a record = 105864 Minimum number of fields in a record = 14 Maximum number of fields in a record = 14 Average number of fields per record = 14.0 In particular, I'm curious about better choices for split/merge loads: Dynamic File name = H08.CR.FF.TEXT Number of groups in file (modulo) = 15511 Minimum groups of file= 15511 Hash type = 0, blocksize = 4096 Split load = 20, Merge load = 10 Split/Merge type = KEYONLY Any insight or comments appreciated. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 ...our behavior matters more than the beliefs that we profess. Elizabeth Deutsch
RE: [U2] [UD] Compilation Failed...
Where do you have TMP pointing to? There is a default for TMP in udtconfig. In UNIX the default can be overridden by setting the environment variable TMP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Wolverton Sent: Monday, October 23, 2006 3:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Compilation Failed... I am at a client site today... Oddest thing - UniData 7.1.6 on Windows One sign on can compile - all is well. Another one cannot - it looks like it is compiling, but always ends with 'compilation failed' - No line number errors, nothing to give me a direction -- I compile the same program using a different signon and it works... So I know it's security reasons... I can write to the VOC, and to the BP -- what permission magic shouild I ask the user to fix for me? Where else must I need access to do a 'compile'? This is the first time I've run into this one! Thanks - David W. === Sunset Programming, Inc. Developing Today for a Productive Tomorrow P 214.337.8204 F 469.442.1368 E [EMAIL PROTECTED] === 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 email or by telephone at (214) 337-8204 and immediately destroy all copies of the original message. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Any have a Sun Sparc Box
We run both our production and our development off Sun Sparc Boxes. It is the 32 bit implementation of the OS: SunOS 5.9 Generic_118558-09 sun4u sparc SUNW,Sun-Fire-880 We have been on Solaris for about 4 years and currently are on Unidata 7.1.0. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of george r smith Sent: Thursday, September 14, 2006 11:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Any have a Sun Sparc Box All, Anyone have any experience with Sun Sparc boxes as development boxes for Unidata. Anyone heard if IBM might certify Unidata on the Solaris AMD boxes. thanks grs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Debugging a program using distributed files causes core dump
When running in Visual mode, what is the last program statement you see before the blowup? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Thursday, September 14, 2006 12:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump Not that either. The process will run completely through without any bumps along the way as long as you don't try to debug it while processing the whole file. Originally that is what I thought was happening but it would never blowup on the same record. Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, September 14, 2006 10:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump How about a bad data record? If I was the one running this, I'd be putting in a number of DISPLAY statements at key points, like a before and after message on statements like WRITEs or CALLs. Probably on READs, too, ensuring you show the record key in the before message. Then let it rip! If you put the displays in correctly, you should be able to pin down where in your program you're hitting your bump in the road. I use things like POINT 1, KEY=xxx and POINT 1, EXIT You just increment the 1 for each pair. Be sure to keep in mind when you complete a loop that you may not get to your EXIT message. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Thursday, September 14, 2006 7:13 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump This happens in 2 different programs. Straight compile and local catalog, no options with DEBUG statements embedded in the code. Then the program is executed, processing stops when it hits the debug, I step through the program until I get to where I want to it continue and hit C to continue. Sometimes it is am immediate dump, sometimes a few seconds later. If I am only working with a small list of items, then it does not happen. If I have selected the whole file it does. I do not use RAID to run the program. In one program the indices are turned off when I am debugging it. The other program just reads the records in the file and does calculations on the data as it is verifying the conversion data. The first program builds the data in the DF files, reads and writes. The second does a sort select of one of the files, then readnext loops. Brenda -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 13, 2006 8:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Debugging a program using distributed files causes core dump Does the process continue through a program where the source file is pointing to the object file ... like the DF algorithm ... the debugger could maybe be trying to display or traverse binary where it expects source? Or through a program compiled with source symbols suppressed or raid suppression on or source code removed?? Just some random thoughts. Stuart Boydell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Select with Multiple Indices Not Working
Try using NO.INDEX and see if you get the results you are looking for. If that is the case, you need to rebuild the index. Have you had any system crashes lately? select ORDERS NO.INDEX WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Tuesday, August 29, 2006 8:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select with Multiple Indices Not Working We have a file that has the customer number and invoice date indexed. When we execute at TCL SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05' no items are selected. We are running Unidata 6.0.6. Is anyone aware of any issues ? - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
I am not sure if I agree with the term 'dumped'. The former owners bought the company back and it flourished again in my opinion. But as former employee, you can take that for what it is worth. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Thursday, August 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [U2C] FW: Opening I'm just wondering how many vendors have purchased M2k to resell it...Once upon a time ADP had purchased it, then dumped it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, August 10, 2006 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unix equivalent of FNAME = FIELD( PATH, '/', DCOUNT( PATH , '/' )
cut -d/ -f7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Friday, July 14, 2006 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] unix equivalent of FNAME = FIELD( PATH, '/', DCOUNT(PATH, '/' ) A Quick Friday afternoon question. I'm writing a script and I have a fully qualified path in $path. I want the final filename in that path. fname=`some_command $path` I *know* there is some command for this, but I cant find it. So if path is /twas/brillig/and/the/slithy/toves, then I want toves in standard out. TIA, cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
What does sar say about your wait i/o? On Solaris, I use sar -u. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] client ip
If you are on UNIX, you could PCPERFORM who -u and grep for the login of who ever you are searching for. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Peterson Sent: Tuesday, June 06, 2006 1:43 PM To: u2-users@listserver.u2ug.org Subject: [U2] client ip Is there a Unidata command for determining a client IP address? CONFIDENTIALITY NOTICE: This is a transmission from American Physicians Service Group (APS), its subsidiaries, affiliates or other entities authorized to be represented by the APS group. This transmission is intended only for the personal and confidential use by addressee(s) named above. This message may contain information which is confidential and/or proprietary. If you are not the addressee or intended recipient of this message, you are hereby notified that you have received this transmission in error and that any review, dissemination, disclosure, copying or distribution or use of the contents of this message is strictly prohibited. If you have received this transmission in error, please delete the original message and notify the APS Network Administrator immediately at 1-800-252-3628. Internet and e-mail communications are APS property and APS reserves the right to review any message that is a product of its network. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1 1 1158318 2 0 0 3 1210922 4 0 0 5 964717 6 0 0 7 1221520 8 0 0 9 1033819 10 0 0 11 1077619 12 0 0 13 1028118 14 0 0 15 1047119 16 0 0 17 1211522 18 0 0 19 1081219 I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 05:27 PM - Bill Haskett [EMAIL PROTECTED] os.netTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata logging of BASIC 05/10/2006 04:07 Runtime errors PM Please respond to [EMAIL PROTECTED] er.u2ug.org Dave: UniData does not have logging for BASIC runtime errors (IBM got back with me on this). There aren't enough requests for this feature to include it in UniData. :-( Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of pic00485.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
Some of that is due to the KEYDATA causing splits. And when the records in the group gets rerun through the hashing algorithm using the new modulo, they hash into groups that already have a lot of records in them. And the new groups get nothing. So the hashing algorithm never puts any records into some of these groups. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Doug Miller Sent: Thursday, May 11, 2006 10:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata logging of BASIC Runtime errors Have you tried undersizing the file to force data into the other groups? From the sample, it looks as if your groups with data are not overflowing and consequently, the file may be oversized. Of course I am not looking at the entire stats so I could be off base. At 09:07 AM 5/11/2006, Baakkonen, Rodney A (Rod) 46K wrote: How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata logging of BASIC Runtime errors
The minimum modulo is not that bad. The current mod is 529447, and the minimum 482029. Primary File Head (dat001): modulo -- 122069 hashtype 96 version - 3 blksiz -- 15 (16384) idxinf -- 10 bproof -- 1 multi-over file - 0 rm -- 255 prt_at -- 192 nullv -- 129 beg_modulo -- 0 file_limit -- 20 Overflow File Head (over001): modulo -- 0 (not used) hashtype 0 (not used) block size -- 0 (1024) (not used) next_block -- 0 (block 0) block_count - 0 max_blk_cnt - 4077 file_logical_end -2070724608 current_modulo -- 529447 min_modulo -- 482029 split_factor 95 merge_factor 40 grp_fre_blk_cnt - 5 file_limit -- 20 total_free_blk -- 0 p_file_cnt -- 5 o_file_cnt -- 1 Free Block List: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert DunnMiller Sent: Thursday, May 11, 2006 11:42 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] Unidata logging of BASIC Runtime errors I have seen this happen before when the minimum.modulo is too small (usually the original size of the file). As to the # delimiter in the key, that will contribute to poor hashing, but I would recommend the first step to be resizing, and resetting the minimum.modulo to the same size as the resize modulo. HTH --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Thursday, May 11, 2006 09:07 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Unidata logging of BASIC Runtime errors How about some other hashing algorithms like Universe has. I have some files that have compound keys, where the separator is a '#' and the hashing is awful. This is what GROUP.STAT looks like: File = AUTHORIZATION modulo=529314 hash type=0 blocksize=16384 Split/Merge type = KEYDATA Grp# Bytes Records 0 770 1 1 1158318 2 0 0 3 1210922 4 0 0 5 964717 6 0 0 7 1221520 8 0 0 9 1033819 10 0 0 11 1077619 12 0 0 13 1028118 14 0 0 15 1047119 16 0 0 17 1211522 18 0 0 19 1081219 I have experimented with blocksize, KEYONLY, HASHTYPE of 1 and this was the best I could do. I am sure that if I brought this file over to Universe, I could find an algorithm that could handle this compound key a lot better. If you need sample data for files that don't hash well, I have some good examples besides this one. The developers seem to love intelligent keys, and sometimes what they come up with does not hash worth a damn. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wally Terhune Sent: Wednesday, May 10, 2006 10:38 PM To: u2-users@listserver.u2ug.org Subject: Fw: [U2] Unidata logging of BASIC Runtime errors So - we are starting our planning cycle for the next release of UniData now. Is this something that there is a ground-swell of support for? If so - what would it look like? All or nothing switch? UDT.OPTIONS? udtconfig setting? environment variable? All users? Just selected users? New log name - eg unibasic.errlog vs udt.errlog? Some limit to the number logged before shutting it off? (concern about log size and filling disk?) ALL UniBasic run-time errors or warnings logged - regardless of fatality? Just some class of errors? Is so - how would you define the ones you want logged? Collect your thoughts and funnel them thru the U2UG Better and Better committee... That is likely a better way than flooding this list. Just my recommendation. Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] - Forwarded by Wally Terhune/Denver/IBM on 05/10/2006 05:27 PM - Bill Haskett [EMAIL PROTECTED] os.netTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Unidata logging of BASIC 05/10/2006 04:07 Runtime errors PM Please respond to [EMAIL PROTECTED] er.u2ug.org Dave: UniData does not have logging for BASIC runtime errors (IBM got back with me on this). There aren't enough requests for this feature to include it in UniData
RE: [U2] gunzip
Did you get this via ftp? Are you sure the ftp was in binary mode? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glen Batchelor Sent: Thursday, April 20, 2006 9:09 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] gunzip Looks like a corrupted file. --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Wronkiewicz, Terrie Sent: Thursday, April 20, 2006 9:00 AM To: u2-users@listserver.u2ug.org Subject: [U2] gunzip Hi All, I am trying to unzip the file a2ps-4.13b-sol8-sparc-local.gz. It is SUN freeware. I am doing: gunzip a2ps-4.13b-sol8-sparc-local.gz I get the message: gunzip: a2ps-4.13b-sol8-sparc-local.gz: unexpected end of file Since the file is zipped I can't read it to see what the unexpected end of file is. Does anyone know how I get past this error message to get the file unzipped? Thanks, Terrie *** Terrie Wronkiewicz Columbus, OH 43219-2099 *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Shell Escape
I am not sure when it became available, but it is in my 7.0 manuals: SETENV Syntax SETENV(var_name, value) Description Use the SETENV function to set an environment variable from UniBasic. Parameters The following table describes each parameter of the syntax. Return Codes The following table describes the SETENV return codes. Parameter Description var_name The name of the environment variable. value The value of the environment variable. SETENV Parameters Return Code Description 0 Setting the environment variable was successful. -1 Setting the environment variable was not successful. SETENV Return Codes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ken Wallis Sent: Thursday, March 30, 2006 5:01 PM To: 'U2Users' Subject: RE: [U2] Shell Escape Excellent idea, but I can't find this documented Rod. What version? Which pdf? Cheers, Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, 31 March 2006 9:01 AM To: 'Ron Sharcott'; 'Stewart Leicester'; 'U2Users' Subject: RE: [U2] Shell Escape How about the SETENV verb. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Shell Escape
How about the SETENV verb. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ron Sharcott Sent: Thursday, March 30, 2006 3:33 PM To: 'Stewart Leicester'; 'U2Users' Subject: RE: [U2] Shell Escape To answer point #1 This is true except if the script is 'sourced' in csh the command is 'source' in Bourne (sh) and Korn (ksh) it sources using a dot (.) and runs the script as if it was part of the existing shell. To add to point #2 It is quite possible that UniData is scanning the UNIX environment and then storing the variables. The real question is, are they stored in a UDT file somewhere that they can be edited and thereby altering the UDT environment? The original entry into UDT ran something like this: 1) log into UNIX 2) .profile runs (not sourced) the menu 3) menu can source the printer set up 4) select database (path to voc) The new setup causing this trouble: 1) log into UNIX 2) .profile detects Terminal or Other application if Other application stop at UNIX prompt and let Other application initiate VOC if Terminal then send to menu system, allow printer setting, then on to VOC Ron Sharcott (3635) -Original Message- From: Stewart Leicester [mailto:[EMAIL PROTECTED] Sent: Thursday, March 30, 2006 12:29 PM To: 'U2Users' Subject: RE: [U2] Shell Escape I don't know the particulars of these scripts, but 2 things: 1) When you shell out of an application you're creating a separate shell process below the current one which inherits the environment of the creator. Any changes you make to the environment in the sub-shell are not propagated back to the parent shell. 2) Most applications, when first invoked, copy the state of environment variables to some internal structure. So even if you could change the environment variables in your own process, it wouldn't change the copy your application (UniData in this case) is using. I suspect you're being tripped up by one or both of the above. Now, if you're executing your scripts *before* starting the UniData process, I don't know what's wrong. Good luck! Stewart -Original Message- From: Ron Sharcott [EMAIL PROTECTED] Date: Thu, 30 Mar 2006 08:09:59 -0800 I can't believe this. The results I'm getting are showing UniData only allowing a shell for the environment variable and won't allow it to be sourced. ... Ron Sharcott (3635) -- Stewart Leicester | JenSoft Technologies, LLC Per Ardua Ad Astra | mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Justification for removal of savedlists
We would run out of disk space if we did not clean this stuff up. We have a UNIX file system just for SAVEDLISTS, _PH_ and _HOLD_ items. That way if the file system does fill up, it will not cause file corruption on Unidata files. We run a UNIX 'find /mccdata/spool -mtime +15 -exec rm {}\;'. So we only keep 15 days of these types of data around on our production machine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Pizer Sent: Monday, February 06, 2006 8:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] phantom COMO file message
Here is one we get when some one does not correctly code a program running as a Phantom: at line 528 illegal terminal input request for background job PHANTOM process 27830 has completed. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Horn, John Sent: Thursday, February 02, 2006 1:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] phantom COMO file message On Behalf Of [EMAIL PROTECTED] Sorry, I was not clear, I know where the _PH_ records are and how to view and create them, I was asking for a listing of various messages that Unidata would write to them, not just what is captured by the PHANTOM or COMO ON commands as out put. Thanks! For example, when is this message written out?: PHANTOM process 392716 has completed. I only recall seeing the has completed message, even if the process aborted or was killed. There might be an error message above it but there's no guarantee of that. - jmh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
I would recommend keeping your files static right up to the point that they hit 2 gig. A well sized static file will run faster and have less overhead in my opinion. Also, if you do go the dynamic route, I would recommend resizing them once a year as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 31, 2006 8:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dynamic Files As someone who's not a newbie, but has some newbie questions from time to time... I need some decent info on Unidata dynamic files. I've got the IBM/U2 docs as well as a couple of Fitz Long PDFs on file hashing. In short, we use static hashing on most files and have no trouble, resize weekly (or more often) and keep great tabs on modulos, overflow and the like. However, we have a couple that are approaching 1Gig in size and I don't want to wait until I get any closer to the 2Gig limit before moving some of the large ones to dynamic hashing. However, the few files I have moved to dynamic hashing are rediculous in size. I'm obviously setting some file parameters wrong, but would like insight from anyone who has good luck... The file STC.HIST as a dynamic file takes up 4.3Gig of disk space. It has around 944,000 records, a blocksize of 1024 but a modulo of 4,000,000+ When I convert this to a static file, I can properly size it with a modulo of around 94,000 which takes up a mere 75Meg. I've tried changing split/merge loads from the default of 60/40 to 20/10. I've tried playing with the minimum modulo. I'm clueless on dynamic files and would love any insight. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 We make moral decisions everyday even if we don't know it. Scott Simon (NPR) on the death of 20,000 coal miners annually in China. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 and MAC
Macs have been Available on the Intel platform for about two weeks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claus Derlien Sent: Monday, January 23, 2006 3:37 AM To: u2-users@listserver.u2ug.org Subject: SV: [U2] U2 and MAC mac os x is based on bsd, but remember that its a ppc processor, so you will need the version of universe/unidata compiled for a ppc, or wait until os x is released on an intel platform. best regards from denmark Claus Derlien -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] vegne af Raymond DeGennaro II Sendt: 23. januar 2006 05:24 Til: u2-users@listserver.u2ug.org Cc: u2-users@listserver.u2ug.org; Mark Johnson Emne: Re: [U2] U2 and MAC At 14:14 -0500 2006/01/21, Mark Johnson wrote: Isn't the underlying OS either Linux or Unix. That should be a start. In a nutshell, it's the best of FreeBSD, NetBSD and OpenBSD. Ray Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata core dump
Do have one record that is humongous? We accidentally got a record out in a file that was 9 meg and we blew shared memory trying to manipulate it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, January 19, 2006 9:11 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata core dump I have a file (static hashed) in Unidata that I can read and write to without a hitch. If I access (read/write) any field in any record, things are good. However, if I list the entire contents of the file with: :LIST FILENAME ALL It core dumps at the same field regardless of which record(s) are being listed. I have: 1) Checked the file for corruption. 2) Checked the dictionary for corruption. 3) Checked all records for weird ascii values and stripped them out. 4) Rebuilt all indicies. All to no avail - it core dumps reguarly on the same field. If I try listing just the field where it core dumps like: :LIST FILENAME FIELDNAME I have no problems and the entire file lists fine. I've tried the DICT elements that occur just before and after the fieldname where the core dump occurs and there's no problem with them either. In short, there's something with ALL that's causing the core dump on this file alone. Did I mention that this is in a production account, and the same file in a development account has no issues? Both accounts are on the same server (ie: running under the same unidata). We were leaning towards configuration parameters as we had to rebaseline some changes a few weeks ago - but problems with udtconf should affect all accounts on the server, not just selected one. Likewise, the problem (to out knowledge) is with this file alone. Any advice appreciated. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 We make moral decisions everyday even if we don't know it. Scott Simon (NPR) on the death of 20,000 coal miners annually in China. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Referencing remote file directly
Sure, you can use full paths in attribute 2 or 3 of Unidata VOCS. We make extensive use of @UDTHOME on our dev box. We have a development env, Systems and Acceptance, End To End and a training environment on the same server. We have a UNIX shell script that prompts a logged in user which environment they want to go to. From a maintenance stand point, the VOC's for all these environments are the same, using @UDTHOME. But the shell script sets a different $UDTHOME, so each environment has its own unique sets of the files. To see what your UDTHOME home is set to, do a !echo $UDTHOME at ECL. Hardcoded paths would make the maintenance of these environments a major headache. So I see @UDTHOME as a major blessing. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Preece Sent: Thursday, January 19, 2006 2:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Referencing remote file directly I think not. This is often mentioned as one of the differences. I assume you'ved used indexinfocus to search? From: Bill Haskett [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Referencing remote file directly Date: Wed, 18 Jan 2006 20:57:32 -0800 I can't find the old discussions of this but can one reference a remote file directly in UniData. For instance, can I: :LIST D:\IBM\ud71\sys\VOC instead of needing a link like: 001 F 002 @UDTHOME\sys\VOC 002 @UDTHOME\sys\D_VOC ? Any help would be appreciated. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Make your dream car a reality http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fcarpoint%2Eninemsn%2Ecom%2Ea u_t=12345_r=emailtagline_m=EXT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Referencing remote file directly
Sorry late night. I did not see you want to do a LIST using the full path. You do need a VOC pointer in Unidata. Even ecltype u says a direct reference is not a file name list /mccdata/mcc13/CLM.DETAIL Not a filename : /mccdata/mcc13/CLM.DETAIL Sure, you can use full paths in attribute 2 or 3 of Unidata VOCS. We make extensive use of @UDTHOME on our dev box. We have a development env, Systems and Acceptance, End To End and a training environment on the same server. We have a UNIX shell script that prompts a logged in user which environment they want to go to. From a maintenance stand point, the VOC's for all these environments are the same, using @UDTHOME. But the shell script sets a different $UDTHOME, so each environment has its own unique sets of the files. To see what your UDTHOME home is set to, do a !echo $UDTHOME at ECL. Hardcoded paths would make the maintenance of these environments a major headache. So I see @UDTHOME as a major blessing. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mike Preece Sent: Thursday, January 19, 2006 2:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Referencing remote file directly I think not. This is often mentioned as one of the differences. I assume you'ved used indexinfocus to search? From: Bill Haskett [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Referencing remote file directly Date: Wed, 18 Jan 2006 20:57:32 -0800 I can't find the old discussions of this but can one reference a remote file directly in UniData. For instance, can I: :LIST D:\IBM\ud71\sys\VOC instead of needing a link like: 001 F 002 @UDTHOME\sys\VOC 002 @UDTHOME\sys\D_VOC ? Any help would be appreciated. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Make your dream car a reality http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fcarpoint%2Eninemsn%2Ecom%2Ea u_t=12345_r=emailtagline_m=EXT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Separate catalog space 2 instances of Unidata ins talled
Research @UDTHOME. We have 6 separate instances of Unidata environments on one box. After a user logs in, a shell script asks them what environment they want to go to. Then the shell script sets $UDTHOME at a UNIX level before executing udt. The VOC pointers in each environment are identical using @UDTHOME. So you can have the exact same file structures underneath a different starting point. For instance, our development environment has /mccbase1/udthome1 as $UDTHOMME. Our Systems and Acceptance environment has /mccbase2/udthome2. Our training environment has /mccbase4/udthome4. Each environment has its own 'sys' directory for the Global Catalog. But the 'bin' is symbolically linked in every environment to the same place /unidata/ud71/bin. We have a 'cron' process that delivers software to each of these environments on an hourly basis. We use the GLobal Catalog for all production software. So when something gets checked into production, it also gets delivered to the Global catalogs for each environment. Programs that are being worked on use DIRECT catalogs in the VOC. That way we can easily identify what programs are not production versions in any of the test environments. When a programs gets checked into production, the process to deliver that program to the Global Catalog, also removes and Direct catalog references in all environments. Let me know if you need more help. - Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Pflueger Sent: Thursday, January 19, 2006 5:00 AM To: U2 User Group Mailing List Subject: [U2] [UD] Separate catalog space 2 instances of Unidata installed Hi, We are in the early planning stages of building a new dev/test box and would like some feedback on how best to setup Unidata with 2 instances (dev test) with separate catalog spaces as an ultimate goal. Is this even possible on the same box? Oh, and we're planning to goto Unidata 7.1.0 on this new box as well which will run Solaris 8. I was hoping someone out there has done this and could send some simple procedures on how to make this happen...or should I just RTM as I haven't honestly done that yet. :-) Thanks in advance, Andy Pflueger Application Developer Ivy Hill - Louisville, KY -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Freeing up AIX disk space
We have had a similar circumstance and not gotten the space back until we kicked all the users off. I am on Solaris, not AIX. I have a little UNIX script that I try and run before doing an 'rm' on a file: #!/bin/ksh #getting names on fuser command filename=$1 if [ $filename = ];then echo Usage $0 file name to check for in use exit 1; fi if [ ! -f $filename ];then echo $0: Unable to Open $filename exit 1; fi for x in `fuser -u $filename 21 | tr )o( \n | cut -d\( -f2` do grep $x /etc/passwd|cut -d: -f5| sort -u done To use it, I do: file.in.use /mccbase3/udthome3/MCC.MP/VOC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Backup, dbpause 24/7 operation
We only DB Pause the system long enough to sync up a parallel copy of the database on our SAN. The parallel copy then gets unmounted off the production server. It is mounted on the backup up server and a tape backup is done. You need enough disk for another copy of your production files. We mount the backup file system on another machine because tape processes slowed our production box down, so we setup a special server just for backups. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell Sent: Friday, January 06, 2006 4:15 AM To: u2 users group Subject: [U2] Backup, dbpause 24/7 operation As our company grows we are getting more pressure to extend our operation through the night. We have maintained a nightly backup that does a dbpause to suspend unidata. This irritates our night shift people since they can no longer use the system. How do those companies who operate 24/7 get around this and perform backups? Thanks, SB 5.3.8 Unidata 6 AIX 5.3 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] openseq question
Is it a permissions problem? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell Sent: Wednesday, January 04, 2006 8:31 AM To: u2 users group Subject: [U2] openseq question Happy New Year. I am having trouble with the openseq function in UniData. We are operation in Pick mode. Openseq can't find the specified file at path,filename. Is there an assumed prefix? Here is the code frag that is failing. MTR.FILE.PATH='/tmp' OPENSEQ MTR.FILE.PATH, MTR.REC TO F.MTR.ROW.FILE ELSE EXECUTE '!touch ':MTR.FILE.PATH:/:MTR.REC OPENSEQ MTR.FILE.PATH, MTR.REC TO F.MTR.ROW.FILE ELSE CALL SB.DISP(3,TROUBLE OPENING :MTR.FILE.PATH:/:MTR.REC: [E:STATUS():]) GO PGM.EXIT END END Thanks, Jeff --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse
Will there ever be a similar offering for Unidata? I struggle with performance issues every day and would look forward any advice possible. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Tuesday, December 27, 2005 11:45 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: [U2] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse For those of you who have been around The List for the 9 or so years I hosted it, you know I rarely give endorsements. This is one of those exceptions that pleases me. My friend and colleague, Mark Baldridge, has his first article published on IBM's Developer Works. The topic is profiling (benchmarking) UniVerse. For those of you who do not track Developer Works, this is a good time to start. http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge- i.html?S_TACT=105AGX11S_CMP=FP I encourage everyone to access this article. U2 is getting more visibility within IBM. This is the kind of article that fulfills two purposes: first, it gives those of us in the U2 community much needed expertise and information; second, our support of this kind of article demonstrates to IBM our fervor for our database model and our U2 product loyalty. Good on yer, Mark! We look forward to the next article in your series. -- Regards, Clif President, International U2 Users Group --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Travels with Mark:
Thanks for the link Wally. I will look through it. Well, I have recently published another article that may be of interest to you (Rod regarding RFS and deciphering sm.log messages. There is a link to it on the U2 home page within developerWorks: http://www.ibm.com/developerworks/db2/products/u2/ There are a number of other U2 articles available there, as well. Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using Esc
We looked at a product called WIN.FAST. But it only got us about 90% where we needed to be. They scan each row looking for specific characters to tell them where headings begin and end, where input fields begin and end. So if you have very consistent screen content and format, this might work for you. We have had too many fingers in the pie over the last 20 years. So consistency is not as good as it should be. In particular, we had some lookups that occupied multiple rows for one item. Some items had three rows, others had four rows. There were other anomalies in the display. So they had trouble figuring out what the user should be allowed to select from this lookup to bring back to the primary screen. It also is only pseudo-gui. The mouse can only be used in certain instances. You still are trying to keep the display in sync with the Unibasic code behind the GUI. Since it is not really event driven, you can only use the mouse in certain places. But it did do a good job of making screens that were consistent look much better. Menus converted easily. You could setup a terminal type for WinFast users. So you could put Winfast specific statements in your existing Unibasic code and still allow green screens to use the same program. There was a lot of functionality that they could provide on the client machine to call windows and web apps from the Unix server (Unibasic programs). There was little to deploy when you wanted to introduce changes to screen. Most all manipulation was handled on the server. The client side just needed to recognize certain characters to trigger GUI like presentation and execution. It did not fit for us, but it might for others. http://www.gowinfast.com/product.htm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Keith W. Roberts Sent: Tuesday, December 20, 2005 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Using Esc Somebody out there has a product for sale which allows you to turn green-screen apps into gui apps with little to no effort. They still have a gs look, so the transition's easy for the user, but you get all the advantages of being able to do the standard editing in a gui input box, etc. I can't remember what it's called or who puts it out, and I can't get to the web to research it right now ... but someone else should recognise what I'm talking about. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, December 19, 2005 7:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using Esc Despite the progress made with conversions from green screen to GUI, my client base for example is virtually 100% green screen. I've been adding a few Accuterm GED programs but not to any huge extent. I believe that the providers should catch up with the times, especially Raining Data and IBM. They should recognize that the conversions from green screen to GUI do not happen overnight and it is truly an extremely large undertaking to consider re-writing legacy code for a gui interface. I'm not talking about re-developing the apps, just trying to make them a little more modern. One client would like their legacy Order Entry app re-written in a GUI interface. I'm truly afraid that my cost for this project will be prohibitive and that it may never happen. Thus adds another frustration. Nothing embarrasses me more than having to explain to a client's new employee that they have to re-type the whole answer if they spelled Apt 4B instead of Apt 4A on a long address line. That tiny piece of time starts off their relationship on a tremendous backwards note. Granted we know that the apps are sophisticated underneath. But the employee's shrugging shoulders speaks volumes. Perhaps what I'm hearing is that RD IBM will turn their back on this concept and, like many things, it's in my hands. So I'll re-deploy my GET.ANS() subroutine and try to tweak it for my different client's environments. Most users are not cut paste oriented. They just want to get to the end of 123 East South Street NW, Apt 4B and replace the B with an A. I don't blame them for condemming the application (and thus the database) with such a tired user interface. MS QuickBasic didn't provide any HomeEndDelInsert kind of INPUT statement. It actually provided too many INPUT formats so I had to write my own. Fortunately there were no terminal emulations or other 'environments', just DOS. Now, anyone programming with VB doesn't concern themselves one bit with these shortcomings. It's part of the environment. My 2 cents. Mark Johnson - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, December 20, 2005 7:22 AM Subject: Re: [U2] Using Esc Mark, AFAIR UV does provide cursor driven input - see the Input @, KeyEdit and KeyTrap statements. It is however pretty horrible.
[U2] Rebuilding indexes on files on Unidata
Over the weekend, I rebuild the indexes for our largest file for claim details. This file has about 41 million records in it. The directory for the dynamic file says it uses 35 gig of space. So it is a pretty good sized file. Prior to rebuilding the indexes, they were contained in 8 separate files idx001 - 8. After the rebuild, the indexes were contained in 5 parts, idx001 - 5. So I got back more than 4 gig of space back by doing the rebuild. We are trying to evaluate now if selects using indexes are any faster after the rebuild. I am not sure of how the internal structures of the B-Tree index could get more than 4 gig of extra infrastructure doing balancing or whatever. We never delete anything out of this file. I guess the bottom line for us will be regularly scheduled rebuilds of our large indexes on a rotating schedule. Below is the picture of the Unix Dir before the rebuild and after that the structures after the rebuild Before # cd /usr/ud/mcc13/CLM.DETAIL # ls -l total 78538312 -rwxrwx--- 1 root mcc 194880 Dec 14 10:25 dat001 -rwxrwx--- 1 root mcc 194880 Dec 11 18:41 dat002 -rwxrwx--- 1 root mcc 194880 Dec 11 19:23 dat003 -rwxrwx--- 1 root mcc 194880 Dec 11 17:05 dat004 -rwxrwx--- 1 root mcc 194880 Dec 11 19:19 dat005 -rwxrwx--- 1 root mcc 194880 Dec 11 19:12 dat006 -rwxrwx--- 1 root mcc 194880 Dec 11 18:07 dat007 -rwxrwx--- 1 root mcc 394174464 Dec 11 19:22 dat008 -rw-rw-rw- 1 root mcc 198976 Dec 14 12:15 idx001 -rw-rw-rw- 1 root mcc 198976 Dec 11 18:55 idx002 -rw-rw-rw- 1 root mcc 198976 Dec 11 16:12 idx003 -rw-rw-rw- 1 root mcc 198976 Dec 11 18:06 idx004 -rw-rw-rw- 1 udtcron mcc 198976 Dec 11 16:11 idx005 -rw-rw-rw- 1 epopsmcc 198976 Dec 11 17:04 idx006 -rw-rw-rw- 1 udtcron mcc 198976 Dec 14 13:06 idx007 -rw-rw-rw- 1 cjhedl is 65200128 Dec 14 13:06 idx008 -rwxrwx--- 1 root mcc 194880 Dec 11 19:12 over001 -rwxrwx--- 1 root mcc 1969758208 Dec 11 18:41 over002 -rwxrwx--- 1 root mcc 1514889216 Dec 11 19:23 over003 -rwxrwx--- 1 root mcc 1485086720 Dec 11 17:05 over004 -rwxrwx--- 1 root mcc 1527906304 Dec 11 18:43 over005 -rwxrwx--- 1 root mcc 1481752576 Dec 11 19:12 over006 -rwxrwx--- 1 root mcc 1470455808 Dec 11 18:06 over007 -rwxrwx--- 1 root mcc 302186496 Dec 11 19:22 over008 Now the After: total 70523120 -rwxrwx--- 1 root mcc 194880 Dec 19 16:18 dat001 -rwxrwx--- 1 root mcc 194880 Dec 19 16:18 dat002 -rwxrwx--- 1 root mcc 194880 Dec 19 16:17 dat003 -rwxrwx--- 1 root mcc 194880 Dec 19 16:17 dat004 -rwxrwx--- 1 root mcc 194880 Dec 19 16:17 dat005 -rwxrwx--- 1 root mcc 194880 Dec 19 16:18 dat006 -rwxrwx--- 1 root mcc 194880 Dec 19 16:17 dat007 -rwxrwx--- 1 root mcc 394174464 Dec 19 16:16 dat008 -rw-rw-rw- 1 root mcc 198976 Dec 19 16:12 idx001 -rw-rw-rw- 1 root mcc 198976 Dec 19 16:18 idx002 -rw-rw-rw- 1 root mcc 198976 Dec 19 16:18 idx003 -rw-rw-rw- 1 root mcc 198976 Dec 19 16:16 idx004 -rw-rw-rw- 1 root mcc 1912913920 Dec 19 16:18 idx005 -rwxrwx--- 1 root mcc 194880 Dec 19 16:17 over001 -rwxrwx--- 1 root mcc 1983873024 Dec 19 16:18 over002 -rwxrwx--- 1 root mcc 1521885184 Dec 19 16:17 over003 -rwxrwx--- 1 root mcc 1490575360 Dec 19 16:15 over004 -rwxrwx--- 1 root mcc 1531142144 Dec 19 16:17 over005 -rwxrwx--- 1 root mcc 1486102528 Dec 19 16:18 over006 -rwxrwx--- 1 root mcc 1475420160 Dec 19 16:17 over007 -rwxrwx--- 1 root mcc 303702016 Dec 19 16:16 over008 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6.1.3 upgrade
What about your Global Catalog, udtconfig, part table for dynamic files, DICT.DICT if you have revised? Also if you copy your global catalog from 6 to 6.1, you might want to copy your CTLGTB file into 6.1. Also the INSTALLUDT might need to be run if you copy the GLOBAL catalog. Thos are a couple of thing I can thing of to watch out for off the top of my head. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Schoby Sent: Friday, November 11, 2005 11:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 6.1.3 upgrade Usually pretty straightforward. Get everyone off the box. Shut down unidata. Extract the bin.tar file in $UDTHOME/bin and run updatesys. Just a few questions answered and you're done. -Jeff [EMAIL PROTECTED] 11/11/05 10:19 AM I'm making preparations for an upgrade from Unidata 6.0.8 to 6.1.3 on AIX 5.1. As a new Unidata administrator, I've never performed an upgrade on a live system before. I just upgraded our test box with no apparent problems, although I can't really test the apps because our 4GL is not licensed on that box. Have any of you encountered any problems that I should be aware of? Thanks in advance, Caleb Ng Systems Analyst Sweetwater Authority [EMAIL PROTECTED] (619) 409-6763 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/