Re: [U2] File size (5538816) is not a multiple of block size(16384).
Charles, sorry I did not see your earlier message until just now. If the remaining guide errors were about records in the wrong group, fixfile cannot remedy those, but a memresize would have taken care of them. But your vendor's approach should also have worked - just a few extra steps. Susan Lynch F.W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, September 06, 2013 2:41 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] File size (5538816) is not a multiple of block size(16384). Here's what I ended up doing. I couldn't get rid of the GFEs that I was seeing when I ran guide so followed these instructions fromour vendor. It didn't recover the lost items, but it got rid of he guide errors.. If you have corruption on only a few files or if the fixfile does not clean up all corruption: FILE.STAT badfile(make a note of the modulo) CREATE.FILE holderfile modulo COPY FROM badfile TO holderfile ALL (You should see some number or records copied) COUNT badfile(hopefully, you will see the same number) CLEAR.FILE DATA badfile If you need to resize, do that now: RESIZE badfile newmodulo COPY FROM holderfile TO badfile ALL When finished DELETE.FILE holderfile Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] File size (5538816) is not a multiple of block size(16384).
Charles, yes, first you have to fix the damaged file, then you can use the UniData utilities to resize it any way that you want. The modulo and block are both in the first block of a static file size (in your case, I believe you would see a 0F in byte 17 of that first block for your 16384-byte block). Dynamic files are more complicated... Susan Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, September 06, 2013 1:17 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] File size (5538816) is not a multiple of block size(16384). Thanks Susan. i use UltraEdit which would allow that. You just explained something for me. I kept recreating the file with a block sie that would work, but when I copied that data back in, it would revert. That is because the block size is contained in the data. Charles Shaffer Senior Analyst NTN-Bower Corporation From: Susan Lynch To: U2 Users List , Date: 09/06/2013 12:03 PM Subject:Re: [U2] File size (5538816) is not a multiple of block size(16384). Sent by:u2-users-boun...@listserver.u2ug.org Charles, What I have done in similar situations is stop UniData, open the file in a hex editor (there are free hex editors on the web - Cygnus has always worked well for me), and trim back the last block (in your case, the last 1024 bytes), since that block has been damaged. Then change the modulo in the first block of the file to what your file would then be, which is 337 (which is hex 0151, so the first 2 bytes of the file would become 5101, since UniData stores the modulo in reverse order). At that point, you should be able to start UniData, run guide on the file, do a fixfile for any damage, resize it (so that things will hash properly, which might not be true with the modulo you replaced), and then compare the file to your most recent backup and any audit logs that you have for data added/changed since that backup to help you find any records that might have been chopped off at the end of the file. Not fun, but it should work... Susan Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, September 06, 2013 12:40 PM To: u2-users@listserver.u2ug.org Subject: [U2] File size (5538816) is not a multiple of block size(16384). We had some file corruption last night and I am trying to recover a file. The file was so badly corrupted this morning that it wasn't recognized as a Unidata file. What I have tried is copying the data and dictionary to SAVE files at the system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back over the originals. The dictionary portion is OK, but I get the message "File size (5538816) is not a multiple of block size(16384)." I had hoped that recreating the file with a block size of 1 would have made this work since 5538816 is divisible by 1024. But it did not work. It still thinks the block size is 16. Can anyone tell me how to recover this data? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This email was Virus checked by UTM 9. http://www.astaro.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] File size (5538816) is not a multiple of block size(16384).
Charles, What I have done in similar situations is stop UniData, open the file in a hex editor (there are free hex editors on the web - Cygnus has always worked well for me), and trim back the last block (in your case, the last 1024 bytes), since that block has been damaged. Then change the modulo in the first block of the file to what your file would then be, which is 337 (which is hex 0151, so the first 2 bytes of the file would become 5101, since UniData stores the modulo in reverse order). At that point, you should be able to start UniData, run guide on the file, do a fixfile for any damage, resize it (so that things will hash properly, which might not be true with the modulo you replaced), and then compare the file to your most recent backup and any audit logs that you have for data added/changed since that backup to help you find any records that might have been chopped off at the end of the file. Not fun, but it should work... Susan Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, September 06, 2013 12:40 PM To: u2-users@listserver.u2ug.org Subject: [U2] File size (5538816) is not a multiple of block size(16384). We had some file corruption last night and I am trying to recover a file. The file was so badly corrupted this morning that it wasn't recognized as a Unidata file. What I have tried is copying the data and dictionary to SAVE files at the system level. Then I did a DELETE.FILE of the file and then a CREATE.FILE STRUCTURE-HEADER_MA 13,1. Then I copied the data and dictionary files back over the originals. The dictionary portion is OK, but I get the message "File size (5538816) is not a multiple of block size(16384)." I had hoped that recreating the file with a block size of 1 would have made this work since 5538816 is divisible by 1024. But it did not work. It still thinks the block size is 16. Can anyone tell me how to recover this data? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Dynamic File Splitting Question
Cinda, wow! When that 'file' is opened, at the Unix level, I believe it has to open 39 files, which is a lot of I/O - rather than a single static file - it looks like the data would be about 3,578,880 bytes plus the empty space at the end of the groups - nowhere near big enough to have to be dynamic. Your minimum number of records per group is zero, so you do have some empty groups, and your maximum number of records per group is 27, which, at an average record size of 44 bytes and a 1 K block size, would definitely put you into level 1 overflow on the groups with large numbers of records. Since the file hashes unevenly, if you are keeping the current key structure, I would increase the blocksize so that you can fit more records per group, and my personal preference would be to make the file static, with sizing something like 3733,2. You could try creating a file that size and copying the data into it - that should not take long, and then you can see how it fits. It should have ample room for growth, and you would not have the overhead of splitting groups all the time, which it seems to be doing. I did not see whether your file was KEYDATA or KEYONLY - the way it has split, I am guessing KEYDATA, but I might be wrong about that. You might try changing your split type, if you are determined to keep the file dynamic. Susan Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cinda Goff Sent: Tuesday, July 23, 2013 12:05 PM To: U2 Users List Subject: Re: [U2] UniData Dynamic File Splitting Question Sorry for the delayed response. Posting was bad timing on my part because I did not have access to the college files last week. I have a copy of UI.LOG.INFO file that I last posted about. Below are 1) the unix level 2) partial GROUP.STAT and 3) guide -d3 I have also been looking at hash type 1. This file hashes about the same but I'm checking with the vendor to see if I can convert a couple of the college's files to hash type 1 to see if it prevents the splits. Thanks for any insight. C. Unix Level of UI.LOG.INFO. $ ls -al total 10370 drwxrwx--- 2 datatel users 1024 Jul 11 07:52 . drwxrwx--- 637 datatel users 34304 Jul 23 10:52 .. -rwxrwx--- 1 datatel users1073152 Jul 22 15:41 dat001 -rwxrwx--- 1 datatel users 204800 Jul 22 15:15 dat002 -rwxrwx--- 1 datatel users 94208 Jul 22 14:23 dat003 -rwxrwx--- 1 datatel users 454656 Jul 22 15:51 dat004 -rwxrwx--- 1 datatel users 82944 Jul 22 14:51 dat005 -rwxrwx--- 1 datatel users 84992 Jul 18 17:36 dat006 -rwxrwx--- 1 datatel users 109568 Jul 22 09:27 dat007 -rwxrwx--- 1 datatel users 20480 Jul 22 09:59 dat008 -rwxrwx--- 1 datatel users 23552 Jul 16 16:24 dat009 -rwxrwx--- 1 datatel users 78848 Jul 22 11:55 dat010 -rwxrwx--- 1 datatel users 150528 Jul 22 14:50 dat011 -rwxrwx--- 1 datatel users 3072 Jun 17 17:28 dat012 -rwxrwx--- 1 datatel users 24576 Jul 18 16:28 dat013 -rwxrwx--- 1 datatel users 273408 Jul 22 15:01 dat014 -rwxrwx--- 1 datatel users 10240 Jul 22 14:04 dat015 -rwxrwx--- 1 datatel users 43008 Jul 22 14:32 dat016 -rwxrwx--- 1 datatel users 205824 Jul 22 13:34 dat017 -rwxrwx--- 1 datatel users 45056 Jul 22 13:06 dat018 -rwxrwx--- 1 datatel users 139264 Jul 22 15:23 dat019 -rwxrwx--- 1 datatel users 174080 Jul 22 15:35 dat020 -rwxrwx--- 1 datatel users 77824 Jul 22 09:05 dat021 -rwxrwx--- 1 datatel users 15360 Jul 22 15:23 dat022 -rwxrwx--- 1 datatel users1735680 Jul 22 15:35 over001 -rwxrwx--- 1 datatel users 2048 Mar 7 21:17 over002 -rwxrwx--- 1 datatel users 2048 Nov 28 2012 over003 -rwxrwx--- 1 datatel users 2048 Jul 9 12:11 over004 -rwxrwx--- 1 datatel users 2048 Jun 26 07:42 over005 -rwxrwx--- 1 datatel users 2048 May 9 14:35 over006 -rwxrwx--- 1 datatel users 2048 May 14 16:57 over007 -rwxrwx--- 1 datatel users 2048 Jul 1 18:19 over008 -rwxrwx--- 1 datatel users 2048 Apr 30 10:21 over009 -rwxrwx--- 1 datatel users 2048 Apr 16 16:28 over010 -rwxrwx--- 1 datatel users 2048 Jul 22 13:19 over011 -rwxrwx--- 1 datatel users 2048 May 29 09:32 over012 -rwxrwx--- 1 datatel users 2048 Jun 6 12:06 over013 -rwxrwx--- 1 datatel users 2048 May 15 14:32 over014 -rwxrwx--- 1 datatel users 2048 Jul 11 21:17 over015 -rwxrwx--- 1 datatel users 2048 Jul 9 15:20 over016 -rwxrwx--- 1 datatel users 2048 Jul 17 09:14 over017 -- --- GROUP.STAT - I have the entire output but thought I would start with a partial listing. I did verify that the file looks pretty much th
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: https://sas.elluminate.com/m.jnlp?password=M.BDCC127B096D131E11EAC16A0F947 3&sid=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 Wjhonson Sent: Friday, July 12, 2013 12:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData Dynamic File Splitting Question Instead of trying to keep recreating these dynamically every night, why not switch to a non-dynamic form ? -Original Message- From: Cinda Goff To: u2-users Sent: Fri, Jul 12, 2013 9:36 am 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/PERSON>165-$ 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 users 4096 Nov 5 2011 idx007 -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx008 -rw-rw-rw- 1 jlevister users 4096 Nov 5 2011 idx009 -rw-rw-rw- 1 rcox users 4096 Nov 5 2011 idx010 -rw-rw-rw- 1 gmoore users 4096 Nov 5 2011 idx011 -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx012 -rw-rw-rw- 1 tbozeman users 4096 Nov 5 2011 idx013 -rw-rw-rw- 1 pperry users 4096 Nov 5 2011 idx014 -rw-rw-rw- 1 kconner users 4096 Nov 5 2011 idx015 -rw-rw-rw-
Re: [U2] UniData Dynamic File Splitting Question
Cindy, when some of our customers began having problems with dynamic files, I spent several months working after hours experimenting with dynamic files and doing hex dumps to see what precisely was happening. I would be glad to provide you with a copy of the documentation that I wrote up for our clients as a result of that research, if you contact me offline. Unfortunately, there is no one-size-fits-all response to your question - you will need to look at your record sizes and block sizes, but my write-up will give you the under-the-hood version of how it all works, and you can do the analysis from there. Susan Lynch sly...@fwdco.com -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:35 PM 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/PERSON>165-$ 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 users 4096 Nov 5 2011 idx007 -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx008 -rw-rw-rw- 1 jlevister users 4096 Nov 5 2011 idx009 -rw-rw-rw- 1 rcox users 4096 Nov 5 2011 idx010 -rw-rw-rw- 1 gmoore users 4096 Nov 5 2011 idx011 -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx012 -rw-rw-rw- 1 tbozeman users 4096 Nov 5 2011 idx013 -rw-rw-rw- 1 pperry users 4096 Nov 5 2011 idx014 -rw-rw-rw- 1 kconner users 4096 Nov 5 2011 idx015 -rw-rw-rw- 1 pperry users 4096 Nov 5 2011 idx016 -rw-rw-rw- 1 gmoore users 4096 Nov 5 2011 idx017 -rw-rw-rw- 1 sbarnes users 4096 Nov 5 2011 idx018 -rw-rw-rw- 1 jjacobs users 4096 Nov 5 2011 idx019 -rw-rw 1 datatel users113200128 Jul 1 12:57 over001 -rw-rw 1 whardwic users 19456 Jun 20 08:26 over002 -rw-rw 1 ijackson users 18432 May 16 08:04 over003 -rw-rw 1 gmoore users 18432 May 14 12:09 over004 -rw-rw 1 sbarnes
Re: [U2] OT: Monitoring Program: Can This Be Done?
UniData has a TIMEOUT command that we sometimes put in the VOC LOGIN for clients whose users let their sessions tie up licenses while sitting idle. Susan Lynch F. W. Davison & Company, Inc. -Original Message- From:] On Behalf Of Ed Clark universe has an AUTOLOGOUT command. I think unidata has something similar. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RESIZE - dynamic files
Chris, 10 years ago, when I was administering a UniVerse system, the answer would have been "minimize both to the best of your ability". But I don't know how UniVerse has changed in the interim, during which time I have been working on UniData systems, which are enormously different in their handling of records in groups from any other Pick-type system I have ever worked on (all of which were much more similar to UniVerse at that time). And when last I administered a UniVerse system, there were no dynamic files.. With that caveat, here are the factors: 1) a record in a UniVerse file that is stored in overflow is going to take 2 or more disk reads to retrieve if you are retrieving it by id. However, in a Basic select (structured as in Will's example, with no quotes, no "WITH" criteria), the system will walk through the file group by group, and will read each record, so yes, it will take 2 (or more, depending on how deeply that group is in overflow) reads to get the data, but it will have done the first read anyway to read those records - so for the Basic SELECT, you probably want to minimize the number of groups read to the extent that you can do so without putting many of the groups into overflow. 2) to add records to the file, you have to access the file by the record id, which means hashing the id to the group, then walking through the group to see if the id is already in use, and if not, adding the record to the end of the data area in use. So for that, you absolutely want to minimize the amount of overflow, because overflow slows you down on the 'adds'. 3) any sort/select or query read of the database will be slowed down significantly by overflow, but you said you don't do much of that anyway. Susan M. Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 07/06/2012 12:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RESIZE - dynamic files So is there a performance increase in BASIC SELECTS by reducing overflow? Some people are saying to reduce disk space to speed up the BASIC SELECT while others say to reduce overflow.. I'm a bit confused. All of our programs that read that table use a BASIC SELECT WITH.. for a BASIC select do you gain anything by reducing overflow? Chris > To: u2-users@listserver.u2ug.org > From: wjhon...@aol.com > Date: Thu, 5 Jul 2012 20:12:21 -0400 > Subject: Re: [U2] RESIZE - dynamic files > > > A BASIC SELECT cannot use criteria at all. > It is going to walk through every record in the file, in order. > And that's the sticky wicket. That whole "in order" business. > The disk drive controller has no clue on linked frames, but it *will* do optimistic look aheads for you. > So you are much better off, for BASIC SELECTs having nothing in overflow, at all. :) > That way, when you go to ask for the *next* frame, it will always be contiguous, and already sitting in memory. > > > > > > > > > -Original Message- > From: Rick Nuckolls > To: 'U2 Users List' > Sent: Thu, Jul 5, 2012 4:43 pm > Subject: Re: [U2] RESIZE - dynamic files > > > Most disks and disk systems cache huge amounts of information these days, and, > epending on 20 factors or so, one solution will be better than another for a > iven file. > For the wholesale, SELECT F WITH, The fewest disk records will almost always > in. For files that have ~10 records/group and have ~10% of the groups > verflowed, then perhaps 1% of record reads will do a second read for the > verflow buffer because the target key was not in the primary group. Writing a > ew record would possibly hit the 10% mark for reading overflow buffers. But > owering the split.load will increase the number of splits slightly, and > ncrease the total number of groups considerably. What you have shown is that > ou need to increase the the modulus (and select time) of a large file more than > 0% in order to decrease the read and update times for you records 0.5% of the > ime (assuming, that you have only reduced the number of overflow groups by > 50%.) > As Charles suggests, this is an interesting exercise, but your actual results > ill rapidly change if you actually add /remove records from your file, change > he load or number of files on your system, put in a new drive, cpu, memory > oard, or install a new release of Universe, move to raid, etc. > -Rick > -Original Message- > rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of Wjhonson > ent: Thursday, July 05, 2012 2:38 PM > o: u2-users@listserver.u2ug.org > ubject: Re: [U2] RESIZE - dynamic files > > he hardward "look ahead" of the disk drive reader will grab consecutive > frames" into memory, since it assumes you'll want the "next" frame next. > o the less overflow you have, the faster a full file scan will become. > t least that's my theory ;) > > > Original Message- > rom: Rick Nu
Re: [U2] RESIZE - dynamic files
Chris, This is why file-sizing is something that requires careful thought. As some of the other responders have indicated, sometimes you want to keep overflow to a minimum (because accessing individual records that are in overflow takes extra disk reads, which slow down your system, and adding new records to a group that is already in overflow will inevitably be slower than adding a new record to a group which is not in overflow), and sometimes you don't (eg if you have a file that is primarily read in a sequential fashion where you do a Basic SELECT, and then loop through the file reading every single record). Because most of the files that I have supported in my career have been read and written primarily as single-record reads, I have always chosen to minimize overflow as my default criteria, and only sized things for sequential reads when the file is rarely written, rarely read as anything but a 'read them all in no particular order' fashion, and that happens rarely in my experience. However, as other responders have written, 'your mileage may vary'! Look at how the file is used. Look at what resources you have. Then decide... Susan M. Lynch F. W. Davison & Company, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 07/03/2012 5:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RESIZE - dynamic files This is why I'm confused.. Is the goal here to reduce 'overflow' or to keep the 'Total size' of the disk down? If the goal is to keep the total disk size down then it would appear you would want your actual load % a lot higher than 37%.. and then ignore 'some' of the overflow.. Chris > But the total size of your file is up 60%. Reading in 60% more records in a full select of the file is going to be much slower than a few more overflows. > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin > Sent: Tuesday, July 03, 2012 2:15 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] RESIZE - dynamic files > > > Dan, > > I changed the MINIMUM.MODULUS to the value of 23 as you suggested and my Actual Load has really gone down (as well as overflow). See below for the results: > > File name .. GENACCTRN_POSTED > Pathname ... GENACCTRN_POSTED > File type .. DYNAMIC > File style and revision 32BIT Revision 12 > Hashing Algorithm .. GENERAL > No. of groups (modulus) 23 current ( minimum 23, 5263 empty, > 3957 overflowed, 207 badly ) > Number of records .. 1290469 > Large record size .. 3267 bytes > Number of large records 180 > Group size . 4096 bytes > Load factors ... 90% (split), 50% (merge) and 37% (actual) > Total size . 836235264 bytes > Total size of record data .. 287394719 bytes > Total size of record IDs ... 21508521 bytes > Unused space ... 527323832 bytes > Total space for records 836227072 bytes > > My overflow is now @ 2% > My Load is @ 37% (actual) > > granted my empty groups are now up to almost 3% but I hope that won't be a big factor. How does this look? > > Chris ___ 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] DICT Whacked in VOC
If you have another account, logto it and check to see what VOC DICT looks like, then set a pointer to the VOC in which DICT got damaged, and copy the correct VOC "DICT" to the VOC with the damaged record. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Bill Brutzman" To: "U2 Users List" Sent: 06/22/2012 6:03 PM Subject: [U2] DICT Whacked in VOC DICT got messed up when I was trying to copy a dictionary... when trying to recover a file. Now... list DICT SOH 0 records listed. "DICT" not found. ED VOC DICT New record. : Q ED DICT SOH Unable to open "DICT", not a file in VOC. File name= I did not yet try to stop and restart UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] User ID of a LOCKED record
Andy, On a UniData system, try the LIST.QUEUE command - it shows you who is holding the lock and who is waiting for it. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Andy Krause" To: "U2 Users List" Sent: 04/30/2012 4:54 PM Subject: [U2] User ID of a LOCKED record I am trying to notify a user of a locked record so they can ask the person locking that record to GET OUT. Is there a simple way to retrieve the user ID given the port number in a BASIC program? The only method I have found is to call !GET.USERS and then loop through the USER.INFO param comparing port numbers until I find the user and pull their user ID from there. Thanks in advance. Andy Krause ___ 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] FAST (File Analysis and Sizing Tool)
Eric, yes, in my experience, they do need resizing, particularly if they are very large files, which are the only ones I generally make dynamic. We have had issues with small dynamic files getting cleared by one user and updated by another user, and the resultant modulo being incorrect (usually off by 2 groups), so I try very hard not to use dynamic files for small files that may be cleared. That does not happen to us with static files, so I make them static and the problem does not recur. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Eric Armstrong" To: Sent: 10/04/2011 4:47 PM Subject: Re: [U2] FAST (File Analysis and Sizing Tool) Thanks for everyone's responses. Regarding dynamic files, my understanding is that even they need resizing from time to time. Is that not correct? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ 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] FAST (File Analysis and Sizing Tool)
Eric, we use FAST to resize over 100 accounts a month, and it works very well for us. It is certainly a lot quicker and easier than manually calculating the proper sizes for over 400 files/account and doing the memresizes! Susan Lynch F. W. Davison & Company, Inc. - Original Message - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job won't run
Not necessarily - if, for example, you have a branch in your VOC LOGIN that varies on usertype or on the login user (eg SYSTEM to avoid having Redback processes run some parts of the LOGIN routine, which is one thing that we do), you might have inadvertantly caused the user id for this process to fail when run by the automated script, but not when run as your user id. Susan Lynch F.W. Davison & Company, Inc, - Original Message - From: To: "U2 Users List" Cc: "U2 Users List" ; Sent: 08/05/2011 11:50 AM Subject: Re: [U2] Job won't run Did anything change in your VOC LOGIN program/proc/paragraph that might be preventing the program from running? Susan Lynch F. W. Davison & Company, Inc. I don't think so. Wouldn't that affect the command line run also? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Job won't run
Did anything change in your VOC LOGIN program/proc/paragraph that might be preventing the program from running? Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: To: "U2 Users List" Sent: 08/05/2011 11:26 AM Subject: [U2] Job won't run I have run into something I have never seen before. We exchange a lot of data with an AS400 in Chicago. For many years we have taken the approach that the AS400 would submit a job to our UNIX box that would run a script. Many of the scripts run a Unibasic program and send the resulting file back to the AS400. This happens several times a day and we have been doing this for many years. One job has started doing something odd. It runs the script and transfers the file, but never runs the Unibasic program, so it has been resending an old version of the file. This seems to have started happening 3 days ago. I can log in manually using the same credentials as the remote job, and run the script by typing it in at the command line. It runs perfectly. Unibasic program runs, new file is sent to the AS400. There is joy. I have checked permissions. Nothing has changed at the AS400 end. Nothing has changed here. (That we know of). I have rechecked the code of he script and the Unibasic program. Looks good. I am stumped. Here is the script code. #!/usr/bin/ksh #Sends FILES_AS400/BOWER_FPO to AS400 as BOWER_FPO LOG="/NTN/DATA/CORPORATE/FILES_LOG/BOWER_FPO.LOG" rm $LOG touch $LOG cd /NTN/DATA/CORPORATE echo `date` "Extracting Firm Planned Orders to BOWER_FPO" >$LOG $UDTBIN/udt<>$LOG RUN GD-BPGM EXTRACT_FPO -N bye EOD echo "Sending Firm Planned Orders to AS400 730" >> $LOG /usr/local/rputj.scr CORP BOWER_FPO FILES_AS400/BOWER_FPO BOWER_FPO echo `date` "Finished sending Firm Planned Orders" >>$LOG This runs perfectly when run from CL, but not when submitted from the AS400. And ideas? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] PICK Systems Administrator position
Or at the very least, on a world-wide list like this, what continent it is on? (unless, of course, it is a tele-commutable opportunity) Susan Lynch - Original Message - From: "Marc Harbeson" To: "'U2 Users List'" Sent: 04/06/2011 11:37 AM Subject: Re: [U2] PICK Systems Administrator position Can you at least say "southern CA" or "northern NY" or something in the ballpark of where on earth it is located? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Joseph Chelston Sent: Wednesday, April 06, 2011 11:22 AM To: U2 Users List Subject: [U2] PICK Systems Administrator position We are seeking a PICK Systems Administrator for a long term contract position. Due to confidentiality, we will not post specific details on this forum. Please email me if you are interested exploring. I'll be happy to give you the full details of this opportunity direct. Regards, Joe Chelston Executive Recruiter Phone: 856.218.1000 Fax: 856.228.8585 Cell: 856.422.4400 Email: j...@bsgstaffing.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata can't build index
Jeff, did you do a CREATE.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID first? Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Jeffrey Butera" To: "U2 Users List" Sent: 01/28/2011 1:32 PM Subject: [U2] Unidata can't build index Can anyone shed light on this (other than the obivous) - I'm unclear about why this is occurring: :BUILD.INDEX H08.PERSON.LOOKUP XPL.PERSON.ID Can not lock index file No indices are built This is a new file so I originally thought perhaps OS permissions where incorrect, but after checking I verified the permissions on the index file are 770. I don't have anything writing to this file so I'm not clear why it can't get a lock on the index file. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 "...we must choose between what is right and what is easy..." Dumbledore ___ 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] receiving error message XX record corrupt on logto
Stuart, I have commented out the WW.SB.RB from the LOGIN on that account, and when we do an MM, we get the menu minus the first system - all the other systems appear to be working normally. At least this way, they can get most of their work done on the account while I am trying to figure this out. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Boydell, Stuart" To: "U2 Users List" Sent: 05/22/2010 6:34 PM Subject: Re: [U2] receiving error message XX record corrupt on logto Susan, Can you try logging into the account using the SYSID parameter to go to the second system. LOGTO ACCOUNT,SYSID2 - does this invoke the corruption message? If not, then it may be the XXCONTROL or other XX item which needs to be checked. Cheers Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Sunday, 23 May 2010 01:48 To: U2 Users List Subject: Re: [U2] receiving error message XX record corrupt on logto Kevin, XX is the first system (first menu option) on the account. Different letters, but that is how U2 TechConnect always refers to this message. I did re-file the menu also, just to be sure it was not confused. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: "U2 Users List" Sent: 05/22/2010 11:38 AM Subject: Re: [U2] receiving error message XX record corrupt on logto To recap: you logged in as the SB user, refiled all of the groups, and you're still getting the XX message corrupt message? XX is a system? user? group? account? Just trying to clear my head and understand what SB+ "thinks" is incorrect. I wouldn't think this would be much of an issue, but if the XX is a system you might bring up the SBSYSMENU menu in /MD and refile that also. ___ 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] re ceiving error message XX record corrupt on logto
I tried this - it did not seem to help. Thanks for the idea, though. And thanks to all who have tried to help on this one. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "inquieti" To: Sent: 05/24/2010 4:26 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan In your logto script try adding CLEARCOMMON then LOGIN so that you go in cleanly. You can add a Logto subroutine in SB+, go to the Admin screen, SB+ Setup, SB+ Control Parameters, F9 Logto Sub. I've experienced this error when logging between accounts from different versions of SB+ (different COMMON blocks). Regards David Susan Joslyn wrote: I have this happening at a client site and I've been all through the re-file everything and it won't quit. It happens *consistently* if I have more than one session open, but still happens intermittently when I don't. If you do come up with a fix for this I'd be very keen to learn it! Thanks, Susan Joslyn SJ+ Systems Associates, Inc. PRC - IT Governance for U2/Multivalue. From: "Susan Lynch" To: "U2 Users List" Subject: Re: [U2] receiving error message XX record corrupt on logto Message-ID: <004b3459d050475daf942cfccd93c...@susanhome> Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison & Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/receiving-error-message-XX-record-corrupt-on-logto-tp28646451p28654669.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
Kevin, I just went into each group that has restricted accounts, into each account, and saved the first menu selection's system record. It did not help, unfortunately. Susan Lynch F. W. Davison & COmpany, Inc. - Original Message - From: "Kevin King" To: "U2 Users List" Sent: 05/22/2010 11:57 AM Subject: Re: [U2] receiving error message XX record corrupt on logto AH what about refiling each of the F5-Accounts with Restrictions screens from /SEC.GROUP.SETUP? Those have checksums as well - and refer to systems. ___ 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] receiving error message XX record corrupt on logto
Kevin, XX is the first system (first menu option) on the account. Different letters, but that is how U2 TechConnect always refers to this message. I did re-file the menu also, just to be sure it was not confused. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: "U2 Users List" Sent: 05/22/2010 11:38 AM Subject: Re: [U2] receiving error message XX record corrupt on logto To recap: you logged in as the SB user, refiled all of the groups, and you're still getting the XX message corrupt message? XX is a system? user? group? account? Just trying to clear my head and understand what SB+ "thinks" is incorrect. I wouldn't think this would be much of an issue, but if the XX is a system you might bring up the SBSYSMENU menu in /MD and refile that also. ___ 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] receiving error message XX record corrupt on logto
Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: "U2 Users List" Sent: 05/22/2010 10:40 AM Subject: Re: [U2] receiving error message XX record corrupt on logto That's interesting, because refiling the group records is usually all it takes. Did you refile the ROOT record? ___ 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] receiving error message XX record corrupt on logto
Kevin, when I was checking to make sure that there were no 'no longer on the machine' accounts in the lists of accounts, I refiled each group record. I have not re-filed most of the user records, although I have re-filed mine and am still having the problem with my login. Do I need to re-file all the user records as well? DMSECURITY has so many different record types that it is hard to know what to include in a project like this and what is safe to omit. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: "U2 Users List" Sent: 05/21/2010 4:51 PM Subject: Re: [U2] receiving error message XX record corrupt on logto Susan, you said "As far as I know, the user did not edit the record, he went through the screens, so the checksum should be ok." Ah, if only it were that simple. In some earlier releases of SB+ (and possibly as late as 5.3, though I thought it was corrected in 5.2) if someone editing something in a security record and wasn't specifically the SB user or in the ROOT group, SB+ could corrupt the checksum. If you can login as SB and refile the suspected records, that might help. ___ 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] receiving error message XX record corrupt on logto
Colin, As far as I know, the user did not edit the record, he went through the screens, so the checksum should be ok. I did verify that the account names are all upper-case - that was one of the tech tips on the U2 Knowledge Base, although it said that that was introduced in 5.3.4 when correcting a different issue in 5.3.3 (which was why I was asking for memories of what was wrong on 5.3.3 - the release notes don't specify!) Thanks for the encouragement on old releases - I do my best to keep our customers on current releases, but sometimes institutional inertia prevents them from making changes. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Colin Alfke" To: "'U2 Users List'" Sent: 05/21/2010 11:42 AM Subject: Re: [U2] receiving error message XX record corrupt on logto It's not that old Susan - most of our clients are still running 5.2.4 with some still on 4.5.4 :) - make sure the DMACCOUNTS record key is all uppercase - try saving the top of the tree in group security when logged in as root. What was changed and how? You can't change most things manually without causing this type of error because of the checksum it keeps. You may be able to change it back though Hth Colin Alfke Calgary, Canada -Original Message- From: Susan Lynch I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch ___ 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] re ceiving error message XX record corrupt on logto
Thanks! I will go check that now! Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "inquieti" To: Sent: 05/21/2010 9:47 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan This is caused by either a missing or corrupt DMSECURITY item(s). We had a customer that couldn't add anything to their menus because when they did, upon saving half the menus would disappear completely. It was all due to the fact that they had removed an account at Unix but everything was still in the DMSECURITY file. When the menus were re-built the 'missing' account caused corruption. It could even be the fact that the Allow Disallow on accounts with restrictions has modules missing. Make sure the DMSECURITY is totally up to date and in line with the actual accounts. Regards David Susan Lynch wrote: I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison & Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Question-about-umask-tp28624993p28633985.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] receiving error message XX record corrupt on logto
I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison & Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Pocket Guide [not-secure]
You do remember correctly - I always thought it was a mistake to let them get away with taking the name! Susan Lynch F. W. Davison & Company, Inc, - Original Message - From: "MAJ Programming" To: "U2 Users List" Sent: 03/28/2010 1:30 AM Subject: Re: [U2] Pick Pocket Guide [not-secure] Only because you mention lawsuit: I recall Pick Systems calling their query language Access, before Microsoft came out with Access. Do I recall correctly? Mark Johnson - Original Message - From: "Hennessey, Mark F." To: "U2 Users List" Sent: Wednesday, March 24, 2010 12:49 PM Subject: Re: [U2] Pick Pocket Guide [not-secure] Heh - name it "Genius" and you invite a lawsuit from Apple... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Tuesday, March 23, 2010 4:26 PM To: 'U2 Users List' Subject: Re: [U2] Pick Pocket Guide I say we name it "Genius" so we can all feel smarter when we go to work! GeniusDB GeniusQuery GeniusCode (Not GeniusBasic that's an oxymoron) Etc. Hey! We've all just been elevated to Genius Programmers! David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Tuesday, March 23, 2010 12:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick Pocket Guide In a message dated 3/23/2010 4:14:07 AM Pacific Daylight Time, br...@brianleach.co.uk writes: > So suggestions welcomed.>> I'm opining that we need a name that is NOT an existing word or acronym of anything else. Something brand new and fresh and unique so no more false positives. Will ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD - Error Logging
Wally, Just because I have not noticed anyone else responding to your question about the saved_logs, yes, please keep that concept - I, for one, end up checking the saved_logs quite a bit when I get calls after the client has already rebooted in order to get their users working again. I would hate to see all that good data go away! I would think that a configurable number of iterations would be optimal, given that your team would be going in and doing a lot of work here anyway. Just my 2 cents! Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Wally Terhune" To: "U2 Users List" Sent: 03/15/2010 10:06 PM Subject: Re: [U2] UD - Error Logging I would be happy to entertain (and formally register) a detailed, coherent proposal for logs, error logs, diagnostic logs - location and management. Do you still want the saved_logs directory concept? (20 or configurable? Iterations saved) What happens at 'startud'? Anything happen at 'stopud'? Is the trunclog command useful? Should the detailed UniBasic run-time error message logging provided by 7.2.0 /usr/ud72/include/msglevelconfig be placed separate from udt.errlog? Should RFS have a separate log for error messages? Should RFS Archiving - have a separate log for offload messages? Client/server debug logs are inconsistent in configuration and activation. What would you propose in this area? Locations must be discoverable by tools that collect information for diagnostics (such as udtdiag). What else am I missing? Whereas I am constantly requesting more usable content of the messages, can we just focus on the overall architecture for this specific proposal? This would be something to be considered by PM for UniData.NEXT and prioritized with the rest of the enhancements. Other venues for proposals such as this are u2-users better and better forum and the UniData CAB (just recently formed by PM). Any takers? Regards, Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ 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] An interesting find....
Where does X get assigned in Program A? (Actually, in program B as well...) Just curious... Susan Lynch F . W. Davison & Company, Inc. - Original Message - From: "George Gallen" To: "U2 Users List" Sent: 12/15/2009 2:23 PM Subject: [U2] An interesting find Here is an interesting tidbit I happened to run across. PROGRAM A: OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1" OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2" * F.FILETOUSE = F.FILE1 (Adding this here will get rid of the compile warning) BEGIN CASE CASE X=1 F.FILETOUSE = F.FILE1 CASE X=2 F.FILETOUSE = F.FILE2 CASE -1 F.FILETOUSE = F.FILE1 END CASE READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA="" The above program when compiled says F.FILETOUSE never assigned a value and when it executes, gives an improper file type error HOWEVER: PROGRAM B: OPEN "","FILE1" TO F.FILE1 ELSE STOP "NO FILE1" OPEN "","FILE2" TO F.FILE2 ELSE STOP "NO FILE2" F.FILETOUSE=F.FILE1 IF X=1 THEN F.FILETOUSE = F.FILE1 IF X=2 THEN F.FILETOUSE = F.FILE2 READ XDATA FROM F.FILETOUSE,"TEST" ELSE XDATA="" Compiles and run just fine, no errors. This is using UV 10.0.2 under the Prime Information flavor 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
Re: [U2] Error logging on
Wyatt, we have seen this a couple of times at our customer sites. From what I have gathered, this message indicates that the underlying operating environment has a lock on an object which requires exclusive use. The first time we saw it, we ended up rebooting the server to resolve the problem. The second time we encountered the problem, they had upgraded UniData to a newer release 60 days before and had not yet authorized the product and that caused the message to occur. They were ok once they authorized UniData and rebooted the server. I would check your udt logs to see if your license has expired as a first thing to check. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Buffington, Wyatt" To: Sent: 11/17/2009 12:06 PM Subject: [U2] Error logging on I am trying to log onto one of our UniData servers and I am unable to. I gives me the following error and I do not where to start looking: U_mutexwait(1), mainId:47, subId:1, errno=28. $ We are using UniData 7.2 running on HP-UX B.11.2. Any assistance would be greatly appreciated. ___ 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] Windows 2003, UniData 7.1.20: Please Explain This Message
Al, it should be the STATIC_GROWTH_WARN_SIZE in section 2.2 your udt.config file. I suspect that the U2 engineers set it low enough that an administrator would have time to schedule sufficient downtime to memresize the file to a dynamic file, even if it is a rapidly growing file. Susan Lynch - Original Message - From: "Al DeWitt" To: Sent: 11/10/2009 11:40 AM Subject: [U2] Windows 2003, UniData 7.1.20: Please Explain This Message I noticed in UDT.ERRLOG the following message: Tue Nov 10 09:25:05 Warning - The size of CFORDER (ino=207201, dno=2154331439, cwd=E:\AVANTE95\FLODATA\LIVE\LIVE.DATA) is approaching system limitation. According to Windows the size is 1,612,720kb in size and I know that the limit is 2-GB.What I'm wondering is; is the message the result of the file expanding beyond a certain threshhold (say 1.5-GB) and it starts this message or does the database thing it's much larger than it's showing? If it's a threshhold situation is there a way of changing the limit to say 1.8-GB so that it's really more if a warning? Thanks. Albert DeWitt Sr. Programmer Analyst Stylmark, Inc. 763.574.8705 (V) 763-574-1052 (F) adew...@stylmark.com <mailto:adew...@stylmark.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] Unibasic: Sample Program
Robert, there you have my favorite phrase "If maintained properly" - no matter what development practices, the key is to maintain the documentation so that the next change request can be reviewed against an accurate understanding of the system (particularly in light of the diverse tools now being used to access the systems - web products, SQL, and a whole host of query tools that make it more complex than ever to identify all the ripple effects from what one might think is a "simple change"). Susan Lynch - Original Message - From: "Robert Porter" To: "U2 Users List" Sent: 10/14/2009 6:04 PM Subject: Re: [U2] Unibasic: Sample Program Agile and Scrum (basically agile 30 days sprint cycles) doesn't mean the system does not get documented. It just means a more iterative process with decisions being made later in the cycle. "Welcoming the change request" does not mean that the change doesn't get documented. It means the documents change with the times. If maintained properly, the docs should be more likely to be correct. For many of us, we have external forces such as accrediting agencies that require us to maintain such documentation. BTW, if you haven't seen it before there's a product called OnTime from http://www.axosoft.com/ that works well in an agile shop. Check out the Scrum in 10 minutes video ... Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
Brenda, I did check it out, and it is interesting, but I still wonder if 3 years later, when the business requirements change, if anyone from the original team will a) be there, and b) remember all the intricacies of the design decisions made, and c) be part of the new team to modify the original stuff. Of course, the 'agile' concept does have a 'design' phase, which to me would mean developing the spec from the user's requests, which I write and save so that 3 years later, when I get called back and asked how to change something, I can hit the ground running rather than reading all the code again. I look forward to hearing back from you in a few years on how well this works in the real world! Susan Lynch - Original Message - From: "Brenda Price" To: "U2 Users List" Sent: 10/14/2009 3:28 PM Subject: Re: [U2] Unibasic: Sample Program Well, when our company gets this fully implemented. You can count over 250 Highlander's Immortals on the list! Seriously, check out "agile" and "scrum", it is interesting. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 3:26 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Ah, it must be lovely to know that you will live forever and will never become ill or incapable of working... Eventually, if the company does not go out of business, or their business needs change so much that all your code is obsolete, somebody else will have to figure out how the system works. A good spec turns into good documentation, which (properly maintained through all the ensuing changes to the system for the changing needs of the users, of course) is a blessing to the person who follows you. Sounds like we have at least 2 of Highlander's Immortals on the list! ;-) Susan Lynch - Original Message - From: "Brutzman, Bill" To: "U2 Users List" Sent: 10/14/2009 3:20 PM Subject: Re: [U2] Unibasic: Sample Program > > John's world is similar to my world here. When I realized that I would > be the only person reading the specs, I stopped writing to myself. At > the risk of no longer being a professional dinosaur, I learned that some > people call it "agile". > > Check out... Eckhart Tolle's book "The Power of Now". > > --B > > ___ > 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] Unibasic: Sample program - to extract data from Table
Mine did too - he came from the Cobol world and didn't think much of multivalue systems until he asked me to do a project, signed off on my spec, and 2 days later had a completed, documentated, ready to fly system up and running. He was stunned - he thought it was a 6 month project (and he became a devout convert to multi-value systems...) Susan Lynch - Original Message - From: "Jeff Powell" To: Sent: 10/14/2009 4:00 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table On the other hand some of us end up spending senseless days re-engineering a product every time management changes it's mind what the product should do. It's a good thing I get paid for doing what the boss says rather than getting paid by completed projects. My boss actually brags about our ability to program on the fly. ___ 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] Unibasic: Sample Program
Ah, it must be lovely to know that you will live forever and will never become ill or incapable of working... Eventually, if the company does not go out of business, or their business needs change so much that all your code is obsolete, somebody else will have to figure out how the system works. A good spec turns into good documentation, which (properly maintained through all the ensuing changes to the system for the changing needs of the users, of course) is a blessing to the person who follows you. Sounds like we have at least 2 of Highlander's Immortals on the list! ;-) Susan Lynch - Original Message - From: "Brutzman, Bill" To: "U2 Users List" Sent: 10/14/2009 3:20 PM Subject: Re: [U2] Unibasic: Sample Program John's world is similar to my world here. When I realized that I would be the only person reading the specs, I stopped writing to myself. At the risk of no longer being a professional dinosaur, I learned that some people call it "agile". Check out... Eckhart Tolle's book "The Power of Now". --B ___ 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] Unibasic: Sample program - to extract data from Table
John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the "wow, this is really cool - could it also do this?" ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: "Israel, John R." To: "U2 Users List" Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that "everyone on the team" understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: "jpb-u2ug" To: "'U2 Users List'" Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ 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] Unibasic: Sample program - to extract data from Table
As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that "everyone on the team" understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: "jpb-u2ug" To: "'U2 Users List'" Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Worst Case/Best Case
Lance, And whether the design was done on the back of a coctail napkin by the end user, as were all the subsequent revisions "documentation" for the development also done by said end-user - the relative ease of revisions in the MV world seems to make this a common scenario! ;-) Susan Lynch . Oh yes you can! Note that Charles said "designed"! The database is irrelevant if the *design* is poor (that's the point of MV - it makes that whole CLASS of DESIGN errors a lot harder to make). We are going to have to agree to disagree here. It is very easy to mess up the design of any database, including MV. I have had my share of cleaning up horrible MV databases, especially with sub-values. At the end of the day, it really comes down to the level of skill by the DBA and knowledge of the product at hand. Regards Lance ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Change is a coming!
It came from the U2BC, with a copy of a letter from Susie Siegesmund: September 15, 2009 Dear IBM U2 Database and Tools Valued Customer, IBM today announced plans to sell IBM's WW U2 Data Servers and Tools assets to Rocket Software. As a global software development company, Rocket Software's R&D platform will enable us to better focus our efforts on developing U2 products that help you grow your business. As valued customers, you understand that our dynamic data record store, Web services capabilities and low total cost of ownership make UniVerse and UniData the right products for building flexible solutions that can capture new markets. This change in ownership is intended to benefit U2 products, customers and business partners and will not affect your current relationship with the U2 business. We will strive to make the change as seamless as possible. I will continue to lead the business with my existing management team. The people with whom you have been working will continue to be your primary contacts. The number you call for Product Support remains the same. No pricing changes are planned, our email will continue to work until we move to a new company network, and we will make sure you know how to contact us throughout that process. Most importantly, the development team will remain focused on the existing product delivery schedule. We will provide you with as much information as possible as the transition progresses. Many of you have been our customers since the days of Unidata and Vmark, and have seen the succession through Ardent, Informix and IBM. We look forward to continuing our strong relationship with you as our new company extends our reputation as the best software infrastructure provider for easily customizable, high transaction, zero administration web applications. Thank you for your continued use of UniData or UniVerse. It's going to be an exciting time for our current and future customers! Sincerely, Susie Siegesmund Director, IBM U2 Data Servers and Tools IBM Information Management Software - Original Message - From: "Israel, John R." To: "U2 Users List" Sent: 09/15/2009 2:23 PM Subject: Re: [U2] Change is a coming! What is your source? It is not on the http://www.rocketsoftware.com/ web site (at least not that I have found). John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Tuesday, September 15, 2009 2:18 PM To: 'U2 Users List' Subject: [U2] Change is a coming! September 15, 2009: IBM has signed an agreement to sell the U2 assets to Rocket Software, a global software development company. Founded in 1990, Rocket is a provider of OEM software to IBM, HP and other Fortune 500 companies. Rocket's R&D focus has the potential to accelerate the growth of U2's business. Please read the attached document from Susie Siegesmund regarding the announcement. Surprise surprise ___ 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] UD: Gathering WHO from another port#?
Good thought, unless you may have to run the logic on a system older than 6.1 (and yes, there are most likely still systems on older releases out there!) 6.1 is the first set of UD manuals I could find that includes the listuser() syntax. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: Sent: 01/12/2009 5:23 PM Subject: Re: [U2] UD: Gathering WHO from another port#? I was thinking the same. Why parse if the information is available in a parsed format already? --- 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: Gathering WHO from another port#?
Kevin, For a list of users, I would execute a PORT.STATUS capturing the output. I use that technique to find ports in use by specific users, parsing the output to limit the display to the group of users I need to see. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Kevin King" To: Sent: 01/12/2009 1:14 PM Subject: [U2] UD: Gathering WHO from another port#? Is there a way in Unidata BASIC to get the (Pick-like) WHO value from another port? On UV, I believe we can do a U50BB with a port# and it'll return the WHO value from that port, but in Unidata, the U50BB user exit ignores the OCONV() parameter. What I'm really after is a reliable way to get a list of ports that are logged in, so maybe this isn't really the right question? -Kevin http://www.PrecisOnline.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] Help!
I replied to the customer and to Laura Hirsch and David Wolverton separately, but just to keep other people from pulling out their hair, we have seen this symptom when the rgwresp.ini file references C:\WInNT rather than C:\Windows - this is a fairly common symptom when changing Windows versions on the db server. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "David Jordan" <[EMAIL PROTECTED]> To: Sent: 08/24/2008 7:46 AM Subject: RE: [U2] Help! Hi Laura Have they check the temp directory access rights, users require read write access to the temp directory. Regards David Jordan --- 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 PROC tip: DB command
Sorry, Clif, I was thinking UD, not UV - I am working in an almost entirely UD environment at this point. I do have a UV proc manual - not as complete as the older Proc manuals but UV proc did, the last time I was on a UV system, behave as the other Proc flavors I had seen in the past. UD, not so much... Susan - Original Message - From: "Clifton Oliver" <[EMAIL PROTECTED]> To: Sent: 08/02/2008 5:55 PM Subject: Re: [U2] UniData PROC tip: DB command UniVerse has a Proc manual, except they call it "ProVerb" these days. It is available for free from the IBM web site in the 10.2 (and before) documentation set. Not vouching for the quality, completeness, or accuracy, however. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Aug 2, 2008, at 10:46 AM, Susan Lynch wrote: Now, not only are there no Proc manuals ( --- 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 PROC tip: DB command
Mark, A simple alternative to the "proc-to-Basic" convertor would be manuals - if IBM would publish Proc and Paragraph manuals with the same level of completeness that the Basic Reference manual has, there would be far less frustration for the inheriting programmers. I 'grew up' on Microdatas and Ultimates and Fujitsus and Sequoias and GA boxes, and never worked with anyone who used Paragraphs until my current position. Now, not only are there no Proc manuals (and procs behave somewhat differently than expected from my past experience), but the Paragraph documentation does not come anywhere near the level of complexity in the Paragraphs that I am supporting, and I find myself frequently wondering what patches of Paragraph code is doing. Why are we dependant on oral tradition (or threads like this) rather than manuals for coding tools that are still functional? Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "MAJ Programming" <[EMAIL PROTECTED]> To: Sent: 08/02/2008 12:57 PM Subject: Re: [U2] UniData PROC tip: DB command Martin: These are some holy grails that would be wonderful if found. One client of mine that was on Results (Microdata) then Universe and is now on D3, still has the original Results PQN procs. Fortunately those procs did not use the extended &, # and ! variable nomenclature but use the % nomenclature very often. Their solution attacked the MV command in this way: Original: MV %1 "Mark" New: HMV %1 "Mark" P whereby they had created a program called MV that would interpret the request. It uses PROCREAD/WRITE. The downside is that this databasic program could not interpet MV &1.4 %10 or MV #1 "SORT MD" as it had no access to those buffers. So one small step for mankind. Regarding "A" correlatives to I Descriptors. One of my clients uses Media Services Group's Advertising billing system and from the looks of the code, it used to be on R90 then Universe then now on Unidata. All of the dictionary items that used to be "A" correlatives had gone through a conversion utility to create the I descriptors. That utility saved on line 10 the original 10 line R90 dict item using IIRC value marks. Thus, the original dict item (for me to more easily understand) exists on the ignored line 10. I never got good at the interpreted version of I descriptors (NEQS, EQS and the nested command structure) so I assumed that the conversion was okay. I write CALL I descriptors if the dict item gets busy. I will offer this though. As a straight programmer for individual clients (not a VAR, reseller or employee at one location), it may not be worth it to 'fix what ain't broke' regarding replacing their working procs with all data/basic. But I think it would be a matter of uniformity and forward compliance for those VAR, reseller or employee-level members of this forum to engage in the project of replacing procs with programs. For the VAR's, it would be a continued investment in their product. For the employees, it would remove one of the legacy entities that may become harder to find younger programmers who can (or want to) understand Procs beyond the bvious jobstreams. My 3 cents Mark Johnson - Original Message - From: "Martin Phillips" <[EMAIL PROTECTED]> To: Sent: Friday, August 01, 2008 2:56 PM Subject: Re: [U2] UniData PROC tip: DB command Hi, > The man (person) who writes a PROC interpreter/conversion utility > that can take a PROC and turn it into either Basic, or a PAragraph, > will > have a product to sell... esp. if it can decipher all the PROC nuances and > tricks that have been introduced over the years. Back in the days when I was working on the development of PI/open, I had a go at this. It is not difficult to produce Basic code that does the same job as the Proc but producing good code rather than a simple step by step interpretation of the Proc is difficult. Also, there are some strange interactions between Procs and the underlying command environment that are different from how Basic programs work so you can never get a true replacement. > Same goes for a tool to convert A correlatives to I-descriptors. This is relatively easy. If you think there is a market, we might even do it. We looked at this as part of the migration process for users moving to OpenQM but we chose to implement correlatives instead as it was easy. Ours are compiled (like an I-type) rather than interpretive for best performance so actually the task of writing the convertor is probably little more than ripping apart our existing correlative compiler. > But pity the wretch that is assigned the task of writing the tool to > convert > F correlatives. This is probably easier than A correlatives. Again, if there is a real market that would pay a sensible price for it
Re: [U2] UniData PROC tip: DB command
Wally, Thank you for that - as far as I recall, this is unique to UniData, and something I have not seen documented anywhere! Always nice to learn something new! Susan Lynch F W Davison & Company, Inc. - Original Message - From: "Wally Terhune" <[EMAIL PROTECTED]> To: Sent: 07/30/2008 7:46 PM Subject: [U2] UniData PROC tip: DB command Kathleene's posting jogged my memory on this... DB (Display Buffers) command works in UniData PROCs. Very helpful for debugging PROC. I think this is unique to UniData? (MV seasoned vetrans care to comment?) DB on a line all by itself will display all buffers (varies for PQN vs PQ proc). Once you see all of the buffer names, you can just display one. For instance, to display the primary input buffer: DB PIB Haven't fielded a support case with PROC questions in years, though. (IIRC) regards, Wally Terhune Mark your U2 Support Architectcalendar! 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 [demime 1.01d removed an attachment of type image/jpeg which had a name of 22457278.jpg] --- 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] static/dynamic file(s) opinions wanted!
I have not used dynamic files on UV, but on UD we have extensive experience with them on very large files. I never recommend UD dynamic files as a way around file-sizing because on the very large files, on UD, the split pointer is inevitably somewhere distant from the group being written, so you go into overflow on the group being written, and then have 2 or more extra writes as another group is split. With high volumes on transactions on very large files, this is a significant impact, and it still results in a file needing resizing. I always recommend FAST from Fitzgerald & Long for our customers - it makes resizing huge numbers of files very easy. I find we get much better performance on systems with properly-sized files, static where possible. And no, this is not an AD, I don't work for Fitzgerald & Long! Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Symeon Breen" <[EMAIL PROTECTED]> To: Sent: 07/22/2008 3:02 PM Subject: RE: [U2] static/dynamic file(s) opinions wanted! We use dynamic files no problem - yes I suppose in certain circumstances there is an overhead, but it would still be faster than a badly sized static file. The conclusion we have is if you are really on top of your file sizes and administrating things daily there is probably less need for dynamic files. If however you have hundreds of accounts and files then dynamic files are easier to admin and hence probably faster in the long term. Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 22 July 2008 16:36 To: u2-users@listserver.u2ug.org Subject: [U2] static/dynamic file(s) opinions wanted! hey all, I have "heard" bad things about using dynamic files versus hashed/static ones. Can anyone share any thoughts on which is better (in particular on a system where the files grow at a fairly steady rate). I always understood that dynamic files were best on files that did not change "that much that fast " as the constant need to resize would outweigh the manual effort of resizing the files manually (or with a program). I am looking for insight (or where to find some insight) on universe and best file practices (right now I am reading the system description manual and its helping but lacks insights that I am sure some of the old pickies on here have) so any thoughts/suggestions/ideas/comments are welcomed! thanks dougc ps universe 10.1 and aix 5.2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.5.3/1565 - Release Date: 7/21/2008 6:36 PM --- 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] open index file ... error(2)
Bruce, I don't remember how UV indexes are set up, but if you are on UniData, did you restore the index along with the file into the other folder? Or copy the one from the original folder into the other folder, delete the indexes, create them and build them again. The reason you are having a problem (again, if on UniData) is that the existance of the index is stored in the data files header block, so you cannot create what it thinks it already has. You can't see the index that is not there, so you are stuck until you get an appropriately named index file in that other folder for the file to look at - then you can delete and recreate as needed (assuming you restored or copied the DICT, of course!) Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Lunt, Bruce" <[EMAIL PROTECTED]> To: Sent: 06/10/2008 5:20 PM Subject: [U2] open index file ... error(2) Hi All, I have restored a file into another folder so that I could compare the file with the same file from another date's backup. When I try to LIST the file I get the error: open index file /path/filename error(2). I don't know how to satisfy it. I thought it must need the index rebuilt. So, I have tried to CREATE.INDEX filename but to no avail. It gives me the same message. I tried BUILD.INDEX filename, same message. Can someone see where I need to go to solve this? 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] Difference between Universe and Unidata
Oh, dear! UniData and UniVerse each come with multiple flavors, and each combination of database and flavor has its ardent (sorry, I could not resist!) fans and people who just as fervently despise it. Not knowing waivic's background in terms of previous exposure to multi-value database environments, it is hard to judge which combination waivic will prefer. Each has its strengths and weaknesses, particularly if you get 'under the hood' and look at the way they handle record storage and other intricacies of the database engine. Both have ample toolsets (either built in or available as add-ons from third-party vendors) to accomplish the necessary tasks for developing applications - again, there are variations between the two, but nothing (that I can think of) that would make your goals unattainable. If we had more specifics about waivic's proposed use of the database, and background in multi-value, we as a community could be more helpful, but I fear that a 'holy war' is about to erupt... Peace, all! Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Louie Bergsagel" <[EMAIL PROTECTED]> To: Sent: Friday, April 11, 2008 6:21 PM Subject: Re: [U2] Difference between Universe and Unidata UniData is like "Clan of the Cave Bears" UniVerse (at least the Prime Information syntax) is like "2001 - A Space Odyssey" Let the db wars begin. -- Louie --- 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] blank lines in code / mixed case
Jerry, no offence taken here - I was in an all-girls college-prep high school, and the nuns refused to offer typing to the honors-track girls on the theory that we were not headed for secretarial jobs. My mother, bright woman that she was, decided that I would need to be able to type my college term papers, and made me take typing in summer school at the local public high school. I have been grateful ever since I first sat down to punch a deck of Hollerith cards! So it was not just a gender-based bias, even back then! Of course, we did not take Shop class either, so I had to learn to use tools by helping my Dad with chores. ;-) Susan Lynch FW Davison & Company - Original Message - From: "Jerry Banker" <[EMAIL PROTECTED]> To: Sent: Monday, March 10, 2008 4:58 PM Subject: RE: [U2] blank lines in code / mixed case I was not trying to offend anyone with that remark but back in the day typing was something that girls took and boys took shop. It was a fact not an accusation. Although I think it would have been a great asset for me today at the time it was hard enough trying to get through all of the social pressures without creating an additional one of my own making. Social norms change and today both genders do and should learn how to type because most of the kids will go into office jobs. Back then most men were likely to end up tightening a nut and bolt. Jerry Banker -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 3:15 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] blank lines in code / mixed case Along with Robert I also took Typing (along with football, tennis, soccer) in High School and am glad I did. Eric -Original Message- From: Robert Houben [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2008 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] blank lines in code / mixed case BTW, to the comment about straight guys not taking typing: I know that they didn't usually, but when I was in high school back in the plasticine epoch (right after the Pleistocene epoch), a bunch of my friends and I took typing because we thought it would be an easy course (and there were girls in it!) Given my career, it was one of the most useful courses I took in High School - one of the few, in fact, where I can say that I still clearly reap the benefits of it every day! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. --- 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] INCLUDE weirdo
Now, now, now - you can write bad code in any language - or you can write good code. I worked with someone who learned RPL first and her RPL code was very easy to read and maintain. She did not want to learn Basic because the Basic programmers who had preceeded us at that site wrote cryptic (and bug-ridden) Basic. When I showed her my code, she was amazed - she had thought that Basic required the unreadable style she had seen from the others. I actually liked RPL! Susan Lynch FW Davison & Company, Inc. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Wednesday, March 05, 2008 12:10 PM Subject: Re: [U2] INCLUDE weirdo When I see difficult UNIBASIC code, I just remember RPL. Charles Shaffer Senior Analyst NTN-Bower Corporation Whatever salary you're making, it's not enough! :) -Dianne Dennis Bartlett wrote: Currently the system uses the following coding structure: OPEN 'HPMAST.FILE' TO F1 ELSE STOP OPEN 'HPCONTRACT' TO F2 ELSE STOP OPEN 'HPTRANS.FILE' TO F3 ELSE STOP READ F1R FROM F1, KEY THEN... READ F2R FROM F2, KEY THEN... READ F3R FROM F3, KEY THEN... F1R<36,X> = F2R<13> / F3R<82> * F1R<8> + F3R<43> Just understanding the code takes a lot of backwards and forwards thru code. --- 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
Laura, !guide gives you an indication of the proper size at the current number of records in the file - someone from IBM can correct me if I am wrong, but it always looks to me like the assumption is that you want 10 records in each group as a goal - and with some files that tend to have larger records, that will put every group into overflow no matter how big you set the blocksize. But it depends on the database you are resizing, and whether the files are expected to grow significantly before the next resize. FAST lets you choose options that allow you to size for expected growth, and does not make the 10 records/block assumption. It allows you to tailor the percentages for different lists of files so that if you know you have files that hash badly due to the structure of the record keys or that have extremely large records, you can allow for additional room to minimize overflow. It has decent reporting options and a stats file that you can write your own reports on if you don't want to use theirs. And you don't have to write your own routines to do the memresize commands or parse the guide_advice record to do them automatically. Of course, you can start at ground zero and write your own (there are people who have done so), and have all the features and custom reporting that you want - but I have found that for sites with large numbers of files, FAST does a good job for me and is worth purchasing. Besides which, as IBM adopts new technologies, if the factors going into the file-sizing decisions changes, Fitzgerald & Long is going to do the work necessary to keep up with any changes to file-sizing needs, where an individual company might not have the resources available to adapt a custom file-sizing software. And no, folks, I do not work for Fitzgerald & Long, so no [AD] brackets required! I just resize large numbers of files every other weekend and use their product. I used to do file-sizing by hand, and would make some decisions differently than what is automatically generated, but on a Saturday when I am resizing 13-14,000 files, I can adjust what I need to with FAST to get a good database performance and not take all weekend to do it. Susan Lynch F.W. Davison & Company - Original Message - From: "Dave" <[EMAIL PROTECTED]> To: Sent: Friday, February 15, 2008 10:42 PM Subject: Re: [U2] File Sizing for Unidata on Windows Fast is a great product and will save you time in resizing files. !guide is a great tool too. You don't need to purchase fast and can use guide instead. that's your choice. Laura Hirsh <[EMAIL PROTECTED]> wrote: 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/ - Looking for last minute shopping deals? Find them fast with Yahoo! Search. --- 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: IBM DOCS was: RE: [U2] phantom ?
Jeff, I don't know why Doug does not want to, but on UniData sites that I support, I usually only have SB Client access, not Remote Desktop to the server, so I need command line tools. UniAdmin is very nice, when you have access. But there are times when you need an alternative. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Jeff Schasny" <[EMAIL PROTECTED]> To: Sent: Thursday, December 13, 2007 1:42 PM Subject: Re: IBM DOCS was: RE: [U2] phantom ? I don't understand. Why don't you just use Uniadmin? I not sure if the old motif (Agh) stuff even exists any more. Besides it was pretty much evil and ugly anyway. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: IBM DOCS was: RE: [U2] phantom ?
Bill, usually we do not load UniAdmin on client machines - only on the servers. But I will remember that if I ever need a feature that is only accessible via UniAdmin. My preference is to just shell out to a command prompt and type in the commands rather than making the client make another port accessible - I don't need pretty graphics, just information. I am not averse to SMIT or UniAdmin or any other nice tools, but I don't see why anyone would necessarily force their use rather than document the commands in addition to providing the pretty interface. Susan Lynch - Original Message - From: "Bill Haskett" <[EMAIL PROTECTED]> To: Sent: Thursday, December 13, 2007 3:06 PM Subject: RE: IBM DOCS was: RE: [U2] phantom ? Susan: You can set up UniAdmin to manage any server from your client machine. They just need to open, and route, port 31438 (or whatever) to the U2 server. I do this with all the servers I manage and don't need remote desktop access. I'm not sure what minimum permissions are required to perform the dbms administration though as I'm normally connecting as an administrator. But then, the dbms server is normally a separate machine so security isn't compromised. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Lynch Sent: Thursday, December 13, 2007 11:24 AM To: u2-users@listserver.u2ug.org Subject: Re: IBM DOCS was: RE: [U2] phantom ? Jeff, I don't know why Doug does not want to, but on UniData sites that I support, I usually only have SB Client access, not Remote Desktop to the server, so I need command line tools. UniAdmin is very nice, when you have access. But there are times when you need an alternative. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "Jeff Schasny" <[EMAIL PROTECTED]> To: Sent: Thursday, December 13, 2007 1:42 PM Subject: Re: IBM DOCS was: RE: [U2] phantom ? I don't understand. Why don't you just use Uniadmin? I not sure if the old motif (Agh) stuff even exists any more. Besides it was pretty much evil and ugly anyway. --- --- 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] Deep and long indentations vs multiple exit points
Ray, at the risk of another 'holy war', please don't encourage the use of "RETURN TO" - particularly with large complex groups of programs with lots of subroutines, this can lead to "return stack overflow" scenarios that are extremely hard to debug (having cleaned up a lot of these as the 'next programmer' on site, I cringed when I read that). I am not an anti-GOTO Nazi, if used sparingly and with good reason, but RETURN TO is, in my experience, a debugging nightmare waiting to happen. Susan M. Lynch F.W. Davison & Company, Inc. 10 Cordage Park Circle, Suite 200 Plymouth, MA 02360-7318 (508) 747-7261 - Original Message - From: "Ray Wurlod" <[EMAIL PROTECTED]> To: Sent: Thursday, November 29, 2007 5:11 PM Subject: Re: [U2] Deep and long indentations vs multiple exit points A third possibility is to allow GOTO ERROREXIT (single exit point) - or even RETURN TO ERROREXIT - in error handling code. This substantially reduces the number of levels of indentation required. --- 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] OCONV Extraction Question - Good Practice
Also, according to the UniBasic Reference Manual, "The FMT function can produce different results based on the BASICTYPE setting." So, if we are going to discuss programming standards, do we have to discuss them for each BASICTYPE flavor? The manual documents what happens with BASICTYPE U, but those of us who are in SB shops are required to use BASICTYPE P, where the documentation does not often specify what the variations will be. Susan M. Lynch F.W. Davison & Company, Inc. - Original Message - From: "Bill Haskett" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 20, 2007 3:14 PM Subject: RE: [U2] OCONV Extraction Question - Good Practice Adrian: I'm not sure about the disaster part. We've moved from D3 to Unidata (a trying experience) and the string handling seems to work fine. We have code like: CRT OCONV(VAR1, 'MD0') "R(#06)" : CRT OCONV(VAR2, 'MD2') "R(#10)" : CRT OCONV(VAR3, 'MD4') "R(#14)" ; ** end of output line ...and it works perfectly. So, since FMT isn't (or at least hasn't been) as portable as the string formating code (FMT wasn't part of the Adds, GA, R83, AdvPick, D3 line of MV), I'd say using FMT violates the guideline of "make it portable". Just a thought... Bill Womack, Adrian wrote: IMO, the only thing wrong with your example is the use of the trailing format strings - everyone (and I mean everyone) should be using the FMT function, making your example: CRT FMT(OCONV(VAR1,"MD0"),"R#6 "):FMT(OCONV(VAR2,"MD2"),"R#10 "):FMT(OCONV(VAR3,"MD4"),"R#14") The old method is a disaster waiting to happen. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Tuesday, 20 November 2007 2:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question - Good Practice Here begins the voting for differences. I actually do not care for the inclusion of the extra Var1.F variables as, mentioned earlier, is that variable used elsewhere? Plus, it implies that it maybe part of a calculation instead of an upcoming, disposable CRT statement. Will I rot as I use this CRT statement? CRT OCONV(VAR1,"MD0")"R#6':" ":OCONV(VAR2,"MD2")"R#10":" ":OCONV(VAR3,"MD4")"R#14". --- 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] OCONV Extraction Question - Best Practises
Actually, that brings up an important point - my preference would be that if you are going to do it once and never re-use that value, then it probably makes sense to do it in one line, and not add the additional variable, but if you are going to need it again, as the OCONV'd value, it makes sense to set a new variable to the OCONV'd value and use the variable, rather than re-doing the oconv. But that requires that a maintenance programmer take the time to know the program rather than look at the surrounding 20 lines or so (and their performance is probably evaluated on how fast they get the changes made rather than on their effect on the quality of the code), which is why most of us have so often seen (particularly in programs generated by a code-generator or in programs maintained by a variety of people over many years) multiple READV's and WRITEV's rather than a single read of the record, or multiple OCONV's of the exact same field with the exact same masking. But making the decision based on the need is my personal preference - others may prefer a standardized approach for ease of training new programmers or may argue that "disk is cheap, memory is cheap" and prefer not to focus on efficiency as one of the criteria for evaluating code. All of which makes the determination of "best practices" rather difficult, since it depends on the criteria you choose for the evaluation - efficiency? Ease of maintenance? Conformation to 'site standards'? Ability to call a logical module from multiple locations in the wider application? Auditability of the results? Various standards of presentation of data for the user interface? Once you get beyond the very simple aspects of programming, everything has to be judged in the context of the application as a whole, rather than on the brilliance (or lack thereof) of small code fragments. Susan Lynch - Original Message - From: "Anthony Youngman" <[EMAIL PROTECTED]> To: Sent: Monday, November 19, 2007 11:19 AM Subject: RE: [U2] OCONV Extraction Question - Best Practises Just DON'T start a few flame wars over this :-) I'd actually vehemently disagree with the original suggestion, for several reasons. The two biggest are: It introduces an extra variable. Any poor maintenance guy coming along has to worry about whether it's used elsewhere. This sort of behaviour is actually frowned on in ANY programming language, I believe. And my personal reason for disliking it, over and above the previous - it takes two lines where one would do. Okay, compressing code for the sake of it can hinder comprehension, but I like tight, compact code with white-space separating small sections, not individual sections full of white space... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 19 November 2007 15:18 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OCONV Extraction Question - Best Practises It's JUST a preference, presently [SNIP] [END SNIP] Speaking of mis-used commands and side-stepping some of the given code craziness... It is better practice to atomize the code into discrete elements such as... Var1.F = oconv(Var1, 'MD0') crt Var1.F 'R#11' rather than to try to kill two birds with one stone by including an oconv statement inside a crt statement such as... crt oconv(Var1, 'MD0') --Bill> --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] resolving udt error message
From: "Christensen, Steve" <[EMAIL PROTECTED]> Subject: [U2] resolving udt error message Can anyone clue me in on how to resolve this error (step-by-step)? When going to the command prompt and starting udt I receive the following error: UniData Release 5.1 Build: (2189) Copyright (C) Ardent Software, Inc. (USA) 1998 All rights reserved. Current UniData home is e:\unidata\ud51\. Current working directory is E:\JENKON\SV\AMI_SQL. Warning: global CTLGTB file path(VOC pointer file) is different than current Unidata home path, cannot global CATALOG/MAP in this udt session. : This is an install of an existing system onto new servers and I am trying to clear up the command line issues. Thanks for any insight you may have on this. Steven R. Christensen DBA, AMSOIL INC. Steven, At ECL (the colon prompt you show above) after you get that error message, type CT VOC CTLGTB, and compare the path in the line after the line with a single F (which will be something like \unidata\ud51\sys\CTLGTB - you want to look at everything up to the \sys\CTLGTB) to the path in the message above (e:\unidata\ud51\). I have found that omitting the drive letter, even if it technically points to the same place, will result in that error message. Example: CT VOC CTLGTB CTLGTB: F \unidata\ud51\sys\CTLGTB \unidata\ud51\sys\D_CTLGTB The system will pull \unidata\ud51, which, when compared to the UDTHOME e:\unidata\ud51, will result in that error message. To change the VOC pointer for CTLGTB, you can AE VOC CTLGTB, hit enter twice to get to line 2, then R2/whatever-the-wrong-path-is/@UDTHOME (eg R2/unidata\ud51/@UDTHOME) After that, you should see something on line 2 like @UDTHOME\sys\CTLGTB and line 3 should be @UDTHOME\sys\D_CTLGTB - type FI to save it, and then type LOGIN to go through the login procedure again and verify that you do not get the error. The advantage of using @UDTHOME in the path is that you will never have to fix the path in the file pointer again if you move machines - it will use the @UDTHOME to pull in the matching path. Susan Lynch F.W. Davison & Company, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Religious Wars
Everyone who is looking forward to no moderator intervention during the next GOTO war or Single Letter Variable war or next Monty Python Quote jamboree, please sound off your approval. All those who want to see personal attacks unsanctioned, sing out. And please take a moment to vote for obscene and inappropriate comments as well. I, for one, would like to thank everyone who has worked to moderate this list throughout its history - it is a difficult job, and frequently thankless. However, I don't think the proposal to merge the 2 lists is a call for no moderator, just to keeping all the discussion together. Closing off the periodic Monthy Python quote orgy, and flagging the end of a GOTO war (did we ever have a single-letter-variable war? I don't remember that one!) are not the same as moving them to another list. I find the historical notes on the development of the product enlightening, so I subscribe to both lists, but I would prefer that the Monty Python threads go to a Monty Python list somewhere, not to this list. And certainly on either list, personal attacks and obscenities should be off-limits - this is a professional forum and the people who post here to share their knowledge and assist others are deserving of thanks rather than disrespect. People going out of their way to help others should be applauded, not sanctioned. The problem for me with having the 2 lists is that I frequently get repeats, which is mildly annoying, but I can live with it since that is what the group decided to do in the past. If the future decision by the community and the moderator is to have one list, I will have one less minor annoyance in life and the people who think that having a discussion sent to the community list is the kiss of death for the discussion will be much happier. However, if the moderator who is donating so much time and effort to the group will be unhappy, let's keep two lists and be thankful for his efforts! Susan Lynch F. W. Davison & Company, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Keys with Value Marks
David, Is there a conversion on UD that strips out unprintable characters? On a generic Pick system, I used to do A correlatives (or Basic programs) that would compare the ID with the ID masked with that conversion code, and if they were not a match, that was a problem id. I think I used to do it in Basic in order to be able to write the records to another file to make it easier to examine them. Susan - Original Message - From: "David Wolverton" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 05, 2007 4:40 PM Subject: [U2] [UD] Keys with Value Marks We all swear we've seen it on the list, but cannot put our hands on it. How do you select keys with "Value Marks" (^253) in the key? We ran into ONE record with this issue, and I want to see if there are any others, so we can trace perhaps a 'cause' -- but we can't seem to SELECT FILE WITH @ID = "[^253]" or the like! A gentle whack up side of the head would be appreciated. David W. --- 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] Clearing a portion of a screen
Tim, Bravo! Well said! Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Timothy Snyder" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 29, 2007 10:43 AM Subject: Re: [U2] Clearing a portion of a screen So today, how do you measure expensive? And with todays flamethrowers, does it really matter? In my mind, performance always matters, especially if there are dozens or hundreds of processes running the logic in question. This has a bearing not only in CPU consumption but also network bandwidth. Always think about the slowest component in the stream, which in this case would be the network. If you make a single request (i.e.: the example provided earlier that put all the @ logic in a single string to be displayed in one CRT statement), that gets tucked into one network packet and is dealt with all down the line as a single entity. If you make a separate request for each field, you're initiating a separate network request and generate separate packets for each of those fields. This could result in many kilobytes of information, in multiple packets, going across the network, interlaced with the individual requests from other users, to update just a few bytes on the screen. But even if you're working on a local PC, you can see the difference between doing things in one CRT versus multiple. It's a much smoother look, which is more appealing to the end user, since the cursor isn't dancing all around the screen. As to flamethrowers, faster hardware often means that little inefficiencies can add up to huge bottlenecks when given the chance. Water always seeks its own level, and computers will always find a way to exploit the slowest component. If you have more or faster CPUs cranking out information for the network to handle, everything on the network will suffer. It's conceivable that could include things totally unrelated to the U2 application or even the server in question, conceivably having enterprise-wide implications. OK - sorry for the rant. That always seems to happen when I talk about performance. Let's try again. And with todays flamethrowers, does it really matter? YES! Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software 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] [UD] Clear File on a Dynamic File
David, If you are doing a BASIC CLEARFILE rather than a CLEAR.FILE from ECL, you have the file open. If you have a dynamic file that is has a dat002 or an over002, those will be deleted when cleared, except that you have them open and Windows will not let you delete them while you have them open. Close the file and execute a CLEAR.FILE from within your Basic program... Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "David Wolverton" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 14, 2007 6:54 PM Subject: [U2] [UD] Clear File on a Dynamic File I'm issuing a CLEARFILE command on a Dynamic File (part of a conversion!) and getting Errno=13: Permission denied Deleting dynamic file c:\unidata\dataaccount\dynfilename\dat002 error I'm guesssing this means this 'dat' file is still floating around on the system after the ClearFile where it normally would be zapped. What's my downside here? Anyone have an idea? Is it 'safe' to proceed? I suspect my Windows permissions don't allow me to 'delete' a file. --- 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] : Cleaner Case Statement
One possible reason why it might be considered less than optimal: From the UniData Basic Commands manual: ...If expr is less than or equal to 1, UniData transfers program control to the subroutine starting at the first label in the list... So if ANS is Q in the code fragment below, you gosub Check.A. (Unless you are using BASICTYPE P or BASICTYPE M, in which case it drops to the next line of code - that is from a note on the previous page to the last quote...) If that is what you really want, ok, but it is certainly not going to be clear to the next poor soul who has to maintain the code! Or who might change the BASICTYPE and not realize the impact that it would have on your logic... Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "gerry-u2ug" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 25, 2007 3:36 PM Subject: RE: [U2] [u2] : Cleaner Case Statement I don't know either - this thread is the 1st time I ever heard that one. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: July 25, 2007 02:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [u2] : Cleaner Case Statement Someone want to explain to me why ON GOSUB is bdd ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: Wednesday, July 25, 2007 1:06 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [u2] : Cleaner Case Statement ON GOSUB..Bad. Bill, that is a bad coding practice - don't go there. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Wednesday, July 25, 2007 12:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] : Cleaner Case Statement Try this ON index('AB2',Ans,1) GOSUB Check.A, Check.B, Check.B Manu - Original Message - From: "Brutzman, Bill" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 25, 2007 5:48 PM Subject: [U2] [u2] : Cleaner Case Statement How can this structure be cleaned-up? begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' ; gosub Check.B case Ans = '2' ; gosub Check.B end case The following is more difficult to read. begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' or Ans = '2' ; gosub Check.B end case I would like something like... begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' case Ans = '2' ; gosub Check.B end case so that the "gosub Check.B" command is not repeated. I have tried a few alternatives without a victory. Suggestions would be appreciated. --Bill --- 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/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2] : Cleaner Case Statement
Kevin, What if the answer is Q? I almost always put in a CASE 1 statement to catch anything that resulted from a later code revision by a colleague or someone who follows me in a job! (The 'almost' is to exclude one-shot programs that nobody should ever run again.) Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Kevin King" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 25, 2007 12:16 PM Subject: Re: [U2] [u2] : Cleaner Case Statement On 7/25/07, Brutzman, Bill <[EMAIL PROTECTED]> wrote: How can this structure be cleaned-up? begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' ; gosub Check.B case Ans = '2' ; gosub Check.B end case If this is all you need, why not: IF (Ans = 'A') THEN GOSUB Check.A END ELSE GOSUB Check.B END Or is your example a simplification? -Kevin http://www.PrecisOnline.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: [AD] [U2] Basic developments "reverse engineering" tool ?
Will, Having spent a lot of my career consulting, I have seen a system where the history was archived in files named with the year eg INVOICES was the current fiscal year, INVOICES2006 was last year's orders, INVOICES2005 were 2 fiscal years back, etc. The same held true for the sales history files. There were programs which were passed the file names, which were opened to INV.FILE, SALES.HIST, etc and the same logic ran on the history files as on the current fiscal year's files. This was many years back, when disk space was more expensive, and history files were archived to removeable media (bulky tapes, usually) and brought back when needed for history reports. The proc for the current year would pass hard-coded file names, while the proc for prior years would prompt for the year and append it to the file names and pass those. But it was not the entire system - probably the one you inherited was written by someone who learned on such a system and thought it was the only way to write code (or a cool way to write code) and who never gave a moment's thought to maintainability or documentation. Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: "MAJ Programming" <[EMAIL PROTECTED]> To: Sent: Friday, June 29, 2007 7:38 PM Subject: Re: [AD] [U2] Basic developments "reverse engineering" tool ? While your examples are not false, they're hardly true either. In my many years of MV programming, I've never seen such alternate files or other methods. The closest I've seen is code within the program to decide which files to use. I think you are implying contemporary intelligence against an old technique. This entire application is written this way so the chances of having EVERYTHING have alternate files is pretty slim. Thanks Mark Johnson - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Friday, June 29, 2007 11:08 AM Subject: RE: [AD] [U2] Basic developments "reverse engineering" tool ? Just to play devil's advocate, there ARE good reasons for doing the code that way: 1. The same program can be used for processing live and historical data if they're in different files. Just create two procs and pass live files in one and historical files in the other. 2. The same program can be used for other file sets - assuming it's a generic routine. 3. Filenames can be changed without having to recompile the program. Although it's a little safer in U2, recompiling code out from under a user isn't a good thing in most flavors of Pick - unless you enjoy sending them to a RIF error. Again, I'm not saying there aren't better ways to do it, but there are legit reasons for this type of code - and who knows how long ago the code was written too. My 1.5" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Norman Morgan Sent: Friday, June 29, 2007 9:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [AD] [U2] Basic developments "reverse engineering" tool ? Joking aside, that looks almost like something written by someone who was accustomed to writing mainframe COBOL where actual file assignments were made outside the program code in JCL. That doesn't excuse the internal naming style, but the technique harks back to my "misspent youth" as a COBOL programmer. > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Timothy > > Snyder > > Sent: Friday, June 29, 2007 8:21 AM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [AD] [U2] Basic developments "reverse > engineering" tool ? > > > > > One of my clients has procs like this: > > > > > > HRUN BP SOP1500 > > > STON > > > HORDER< > > > HCUSTOMER< > > > HPRODUCT< > > > HVENDOR< > > > P > > > > > > whereby the program (BP SOP1500) has the corresponding INPUT > > > statements > > for > > > the file names and opens them as F1, F2, F3 which is a real > > bear when > > > reading the code. > > > > Wow - that's just plan mean! There may have been a thought that it > > was a way to avoid hard-coding file names in case they ever changed > > (though that would be a weak argument), but then they're > hard-coded in > > the PROC, so I can't see any benefit at all, other than > obfuscation. > > The person that created it must have had a future grudge against > > whoever came along to maintain the code. "Take my job from me, did > > you? > > I'll teach you a lesson." :-) > > > > Tim Snyder > > Consulting I/T Specialist > > U2 Lab Services > > Informati
Re: [U2] Basic developments "reverse engineering" tool ?
Tony, there are a number of things that a source code analyzer can do that would be very helpful if you found yourself coming into a company as a consultant or as a new employee and they had no technical documentation: List programs that open each file - useful for verifying that adding an attribute won't blow up dimensioned arrays or confuse the program logic that deals with the last attribute in the current dimension size, depending on your version/flavor of MV - also useful when you are asked to add another code for a field (eg Active/Terminated status field, suddenly users want to add Pending or Sabbatical statuses - where do you need to add logic to handle those new status values?) List programs that write to each file (useful when trying to figure out "how did that attribute get that inappropriate data in there?") List of programs that call a given program (including by a variable name) - useful when you change the list of variables passed to the program Of course, now that we also have paragraphs that can write data, and tools like SB and a variety of others that can store procedural information and write commands in places other than Basic and Proc, it gets a bit trickier to write that sort of automated source code analyzer - gone are the days when you could pass the source code analyzer a list of Basic Program files, a list of Proc files, and let it generate this sort of technical documentation. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Tony Gravagno" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 27, 2007 2:33 PM Subject: RE: [U2] Basic developments "reverse engineering" tool ? Herve Balestrieri wrote: To clarify the inquiry : I am seeking for a tool reading Basic source code modules and producing a technical documentation of an application automatically. This is not the purpose of an object code decompiler. I don't believe there is a way to have a program read code and figure out what it does from a logical perspective. When you say "technical documentation", I'm not sure what sort of info you wish to extract from your code. If you mean file usage, common usage, etc, the only way to get a program to process such information is to make sure you have your code completely consistent - or you need to use meta data as described below. Java and .NET use structured comments with XML for doing this and I've seen a few MV packages do the same with BASIC. I'll make up some sample XML below but this is how I might do it. [Snipped to reduce size ] Tony Gravagno --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] A question of dictionaries.
Mark, In my early days of consulting, many years ago, I had a client whose CFO insisted that anything that I wrote that *could* be written in English (UniQuery under its original Microdata name) be written that way, even if it was less efficient, because then if it needed changing when I was not on-site, he could do it himself. After he was let go, I got a frantic call from his assistant - a million dollar order was "missing" on the system. Turns out he had modified one of my dictionaries and created his own version of a report to only show an order once, not on subsequent months, because the production team did not want to get flak from upper management about orders that had not yet completely shipped. It took me a while to figure out what he had done and fix it so that they did not suddenly find themselves losing track of the huge orders. It also appeared that some reports had been modified (either in the dictionaries or in the selection criteria) so that some cash audit reports were, shall we say, less than clear in terms of what was not reported. So, *that* kind of user (no inhibitions at all!) does need to be constrained, if only so that there will be documentation of what the system is doing after they leave the company! Susan Lynch F W Davison & Company, Inc. - Original Message - From: "MAJ Programming" <[EMAIL PROTECTED]> To: Sent: Thursday, May 24, 2007 11:41 AM Subject: Re: [U2] A question of dictionaries. I should add a comment to your post regarding the user changing a reporting column. This borders on a very slippery topic regarding the user's access to the system. In my travels, many systems prevent their access to TCL. Those that allow access only give the users a very, very limited set of commands like LIST and SORT and perhaps SELECt but never EDIT or BASIC etc. Plus the user's natural inhibitions prevent them from learning (retaining) what they may see us typing. So I guess my question is what kind of 'user' could actually change a reporting column to begin with. In many of my clients' systems there are formal, menu-driven reports with specific indicators in the headings for report identification. The users who make their own English report never, never use HEADING so that would be my first sign of a renegade report. I don't use EVAL or other live dict items and I can't imagine the most serious non-MV user crossing over that line. We programmers, having the keys to the entire castle, sometimes feel that the users are only one small step behind us. Everytime I think that they're near me, I'm reminded of how contained they actually are. For over a quarter of a century I've been trying to show users the simplicity of creating their own reports in English. I've found that you can lead a horse to water but you cannot make them drink. I've seen users decline retaining education after attending Crystal Reports classes, Excel Classes, Powerpoint classes and even MS Access classes. I don't think they will take a liking to our dictionaries. My 2 cents Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Redback on Windows 2003 Server
Jan, Given that the earliest release of Redback that shows W2003 in the Product Availability matrix is 4.2.3, and 3.2.3 is not even on the Product Availability list, I think you probably want to upgrade Redback. Susan Lynch - Original Message - From: "Jan Darr" <[EMAIL PROTECTED]> To: Sent: Friday, January 19, 2007 5:31 PM Subject: [U2] Redback on Windows 2003 Server I'm attempting to install Redback, version 3.2.3 onto a Windows 2003 Server, will this load properly? Is there something different that needs to be done, once installed to allow it to run? I've noticed that the scripts folder did not get created, in addition to the Redback programs not getting installed. Do I need a later release? Any and all help is greatly appreciated. Thanks, Jan --- 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] Compilation Failed...
Folks, All that is well and good if it is a single program that is the problem - you can copy and rename, or add dummy lines as a workaround. I had worked with David on the problem he was having before he submitted it to the group, and it was actually most of the programs in the (large!) file. Any other ideas? Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Bob Wyatt" <[EMAIL PROTECTED]> To: Sent: Tuesday, October 24, 2006 12:08 PM Subject: RE: [U2] [UD] Compilation Failed... > Mark Johnson can tell a story (well, another story) about UniData doing the > same thing; UniData 5.1, to be exact. Mark and I worked on that for quite > some time before Mark just gave up and left the useless stuff in there to > make the program work. At least, to the best of my recollection, that was > how it was handled in the end. > > I worked with the support team (UniData/Ardent/Informix) in place at that > time; it wasn't readily reproducible, and there never was a fix (at least, > that I knew of). > > Regards, > > Bob Wyatt > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Tuesday, October 24, 2006 11:20 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Compilation Failed... > > I have a wild one for you. In Universe, not Unidata, twice I've had > programs that would not compile properly. I found that if I added a > statement to the source code then it would compile. It doesn't matter > what the statement is as long as it affected memory usage. These two > times, I just added the line Z="JUNK MESSAGE" and that fixed whatever > the compiler was doing. > > But you already have a fix. You've copied the program so delete the > original and rename the copy to the originals filename. > > YMMV, > > BobW > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton > Sent: Monday, October 23, 2006 4:22 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] Compilation Failed... > > Well ... It does not appear to be TEMP related... > > Example: > > TEST>BASIC BP IMPORT.CLIENTS > Compiling Unibasic: \STUFFHERE\BP\IMPORT.CLIENTS in mode 'p'. > > compilation failed > > TEST>COPY BP IMPORT.CLIENTS > TO: TESTING2 > > 1 records copied > > > TEST>BASIC BP TESTING2 > Compiling Unibasic: \STUFFHERE\BP\TESTING2 in mode 'p'. > compilation finished > > > SO... I cannot compile the EXISTING program, but if I copy the source it > to > a new name, I **CAN** compile it. So there is some permissions settings > on > the EXISTING object code (_progname) file that is the issue -- the > problem > is figuring out what. > > I guess I'll just have the user compare the security of the two object > codes > to see what is different - as bad as I hate that! > > If this extra information rings bells, please let me know... > > > David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Client interested in using Dynamic Connect with application software written with SBPlus
Thank you, everyone, for the help on this - as always, the people in this group are a tremendous resource! I will work with the client and let you know how things go! Susan Lynch F. W. Davison & Company, Inc. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, May 18, 2006 9:39 PM Subject: RE: [U2] Client interested in using Dynamic Connect with application software written with SBPlus > I use Dynamic Connect in preference to SBClient. I have NO issues with it > using it against SB+/UV in VT220 mode. > It is less powerful than say, bNettermb (another well-loved emulator I have > used) but it is free and quite serviceable for the price! > As others have mentioned, it wonbt do SB+ downloads, smart client, tu.xxx > routines and their ilk but it does have some SB+ smarts for printing boxes > and the like. > Setup: In SB+ in the terminal definition screen (/TERM.DEFN), start by > creating a new emulation by copying one of the Wintegrate emulations > supplied with SB+. Make sure the OE Term type is vt220 and PC Terminal type > is set to 2 (aka Termite mode). This will give you a good colour emulation > right off the bat. > In the Setup /Terminal dialog of DC make sure that you have the sb and > sb_keys extensions highlighted. > Cheers. > > > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of "Susan Lynch" > <[EMAIL PROTECTED]> > Sent: Friday, 19 May 2006 03:09 > To: > Subject: [U2] Client interested in using Dynamic Connect with application > software written with SBPlus --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Client interested in using Dynamic Connect
Bill, the problem is that everything we do is very SB-dependent. It is not just the screens. We download accounting files to the client PC using the SB file transfer subroutine calls, we email invoices using the SB calls to the TU.MAPI logic, etc. However, your point about the correct emulation mode is interesting. The client now tells me that the only thing (that she has tested) that is not working for her is the F5 key. I checked the Dynamic Connect manual and the Function keys in general mapped exactly to the SB key definitions. The F5 key appears to be the one key that was not mapped, according to the documentation - I will send her directions for mapping that key the way that SB Client has it mapped and see if she can use Dynamic Connect successfully. Thanks for the help! Susan Lynch - Original Message - From: "Brutzman, Bill" <[EMAIL PROTECTED]> To: Sent: Thursday, May 18, 2006 2:34 PM Subject: RE: [U2] Client interested in using Dynamic Connect > We use Dynamic Connect and (for what it is) we like it a lot. > > On our legacy HP-Ux 9000 E45 we use "addsvp" emulation. > > On our new HP-Ux Itanium server, we use "VT-100". > > Determining the correct emulation mode is important; strange characters > appear when in the wrong mode. > There are maybe two dozen modes available in DC. > > Rather than insane, I would consider the client to be fiscally prudent. > > The SB source code may need to be tweaked in order to run with DC. Consider > sending over sample code. > > --Bill > > Bill Brutzman, Mgr IT > > HK MetalCraft Mfg Corp > PO Box 775, 35 Industrial Rd > Lodi NJ 07644 > > 973.471.7770 x145 > 973.471.9666.fax > > [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Susan Lynch > Sent: Thursday, May 18, 2006 1:09 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Client interested in using Dynamic Connect with > application software written with SBPlus --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Client interested in using Dynamic Connect with application software written with SBPlus
Folks, OK, before anyone asks if I am insane, my first response to the client was in the negative because SB Plus and SBClient are a team - even having different versions can cause odd behaviors, especially in things like downloads and email. But the client is both persistent (Dynamic Connect is, after all, free!) and not good at giving details, and she wants a recommendation on terminal emulation because she is having trouble with determining a good setting. I told her vt220 was probably her best bet, since that is what we use in SBClient. However, I am asking here in case someone else has already been down this road, and can give me some guidance on what issues she is likely to encounter. (And yes, I know there is an sbsolutions list, but this list seems more likely to know Dynamic Connect...) Eagerly awaiting your ingenious workarounds and 'war stories'... Thanks in advance! Susan M. Lynch F.W. Davison & Company, Inc. 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. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic Files
- Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, January 31, 2006 9:15 PM Subject: [U2] Dynamic Files ... > 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 > > Jeff Butera, Ph.D. > Administrative Systems > Hampshire College > [EMAIL PROTECTED] Jeff, A couple of questions: UD or UV? If UD, dynamic KEYDATA or dynamic KEYONLY? And what is your average record size in the STC.HIST file? Also, I am guessing that as a history file, it is going to continue to grow, so how about GROW as the minimum modulo? Susan Lynch F.W. Davison & Company, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PROC question
Bob, If A1 gets overwritten in PROD.PL PROG1.PROC, then it won't be 1 when you come back to the menu proc. Are you being careful to preserve the value in A1 when you are in the called proc? Susan M. Lynch F.W. Davison & Company, Inc. (781) 340-9255Support fax # (508) 437-0093 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. - Original Message - From: "Bob Woodward" <[EMAIL PROTECTED]> To: "U2-Users List" Sent: Wednesday, January 25, 2006 2:54 PM Subject: [U2] PROC question > Hi folks, > > Maybe I'm just missing the finer points of PROC processing. I've got a > MENU proc that's structured like this: > > PQ > 10 C Top of Main Menu > OA number of lines that display the available menu choices > ... > OEnter choice + > IP: > IF # A X > IF A = 1 [PROD.PL PROG1.PROC > IF A = 1 G 10 > ... > IF A = 99 [PROD.PL PROG99.PROC > IF A = 99 G 10 > O > O That is not a valid menu choice. > OPRESS [ENTER] + > IP > G 10 > > My problem is when I come back from one of the PROGxx.PROC's, I'm not > getting the menu choice value back to execute the G 10 command. Instead > it displays the error message at the bottom. The PROGxx.PROC is > structured like this: > > PQ > 10 C Top of this PROC > Ha number of things stuffed into the output buffer > P > Hmore things happen in the output buffer > P > RTN > P > 999 C should never get past this point > OI never see this message > X > > Now keep in mind that I've trimmed down the PROC's to keep this message > fairly short. Everything is working as expected EXCEPT the falling > through on the MAIN.MENU.PROC into the invalid menu choice message. > Anyone have any insight to my problem? > > TIA > > BobW > --- > 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] Translate question
Mark (and George), the technique was widely (and badly) used back in the old days when memory was expensive and machines were a lot slower. I responded to your email, Mark, because I was thinking of your older, slow systems; I wanted to remind you of the inefficiency because I remember that when I rewrote one invoicing application that had used the OCONV(Tfile) form extensively, and did a single Open and Read of the necessary records, the procedure went from taking 1 hour to under 15 minutes. The only change in the program logic was the elimination of the multiple OCONVs, and the batch sizes were relatively consistent, so it was processing the same number of records. I was told at the time that the ENGLISH process implemented the Open/Read logic differently and was much more efficient, so OCONV(Tfile) in a dictionary was ok, but should not be used in a Basic program. I am delighted to hear that the implementation of the OCONV(Tfile) in Basic has been improved - and if it has been improved in _a_l_l_ current versions of Pick, I withdraw my objection to it. Until then, I will avoid it on the off chance that my code will be put on a box where the implementation is not geared toward optimizing that particular construct. Bottom line: even if hardware and O/S software are much faster now, and the difference between good and bad code is not so easy to detect in terms of speed for various processes, why waste resources the stockholders have spent good money on by not optimizing the code (unless it greatly increases the cost of development or maintenance)? Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "George Smith" <[EMAIL PROTECTED]> To: Sent: Friday, October 21, 2005 9:45 AM Subject: Re: [U2] Translate question > My understanding is that any contemporary platform caches files opened with > an OCONV so that, with sufficient memory, there is basically no performance > hit. This is certainly true on the mvBase and REALITY systems I support. The > old MCD systems didn't have 'sufficient memory' of course, so we worried > about it. > byw, the current version of REALITY is very nice, and if you actually still > have clients on MCD/McDonnell Douglas hardware, you might want to suggest a > migration. Reality to Reality is painless. > George Smith > Phoenix, AZ > > On 10/20/05, Mark Johnson <[EMAIL PROTECTED]> wrote: > > > > Oddly enough I learned this back in the day on microdatas (I used to work > > for MCD in the late 1970's) and have been using it ever since. > > > > I find it much easier to program than the OPEN/READ for the simple > > purposes. > > I'm obviously effeciency oriented and wouldn't OCONV more than 1 field. My > > brain detects the need for the second field and I program OPENs and READs. > > > > I spent 2 days with my MCD clients last week and it's getting painfully > > obvious how slow it is. The absense of indexing is perhaps the greatest > > loss. I have to be far more concerned for effeciency. > > > > On D3 and U2 systems, one doesn't have to be perfectly effecient. Before > > everyone gets on their soapbox and flames me for not being perfect, > > understand that people like me have lived on both sides, native and > > contemporary. > > > > The native systems never had the speed and were about 30% less on other > > advanced features. I can honestly say that upgrading to a faster box > > brings > > with it more application opportunites that may have been declined on the > > prior system. There are things you can do on a current system that would > > be > > a burden on an older system. But effecient methods brough forth from a > > system with less resources to a current system wins both times. > > > > I've not felt the delay during these past 25 years of using OCONV for > > single > > readv's, old or new systems. That's just my experience. > > > > Thanks > --- > 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] Translate question
Glenn, Sorry, I missed that thread, but thank you for the information! Mark does not work solely on UV systems - he has a lot of older Microdata sites, so the warning may still help him! Susan Lynch F.W. Davison - Original Message - From: "Glenn Herbert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; Sent: Tuesday, October 18, 2005 11:47 AM Subject: RE: [U2] Translate question >I believe this issue was addressed in a previous thread just last week >- trans operations, whether with TRANS, XLATE, or Tfile conversion, >utilize both a file and record cache to help alleviate these >concerns.If you issue multiple statements against the same file >and/or record, the open/read hit is only taken against the first >statement. This does NOT alleviate the speed of field lookup >traversal, only file/record open/reads > >In summary, the universe implementation is fairly efficient. > >Hope this helps. > >__ > >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of "Susan Lynch" ><[EMAIL PROTECTED]> >Sent: Tuesday, October 18, 2005 11:28 AM >To: >Subject: Re: [U2] Translate question > >Has the internal implementation of this changed, or is this still as >horrifically inefficient as it was back in the Microdata days? Except >in a >condition where you were doing a READV from a file that was not >otherwise >read in a Basic program, this was always strongly discouraged - as I >found >out when I asked Jon Sisk about it at a convention, and he literally >fell on >the floor laughing that someone was actually using this syntax. At >that >time, Chandru Murthi got up and helped him answer (both were laughing) >- >this syntax actually did a file open and then a READV, so that if you >use it >for more than one field in a record, or for multiple reads on a file >in a >Basic program, the OPEN being repeated was a killer in terms of >performance >(our software vendor did both, constantly!) >I am surprised that no other responders raised the efficiency issue! >Susan Lynch >F.W. Davison >- Original Message - >From: "Mark Johnson" >To: >Sent: Monday, October 17, 2005 11:16 PM >Subject: [U2] Translate question >> I've always used the OCONV(ID,"TFILE;X;15;15") form for translates. >What >is >> the difference between the first and second '15's. I've seen "X;;15" >work >and >> "X;15" not work. >> >> Thanks in advance. >> Mark Johnson >> --- >> 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] Translate question
Has the internal implementation of this changed, or is this still as horrifically inefficient as it was back in the Microdata days? Except in a condition where you were doing a READV from a file that was not otherwise read in a Basic program, this was always strongly discouraged - as I found out when I asked Jon Sisk about it at a convention, and he literally fell on the floor laughing that someone was actually using this syntax. At that time, Chandru Murthi got up and helped him answer (both were laughing) - this syntax actually did a file open and then a READV, so that if you use it for more than one field in a record, or for multiple reads on a file in a Basic program, the OPEN being repeated was a killer in terms of performance (our software vendor did both, constantly!) I am surprised that no other responders raised the efficiency issue! Susan Lynch F.W. Davison - Original Message - From: "Mark Johnson" <[EMAIL PROTECTED]> To: Sent: Monday, October 17, 2005 11:16 PM Subject: [U2] Translate question > I've always used the OCONV(ID,"TFILE;X;15;15") form for translates. What is > the difference between the first and second '15's. I've seen "X;;15" work and > "X;15" not work. > > Thanks in advance. > Mark Johnson > --- > 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] Are there any UniVerse / U2 Basic Language Self-Study materials? {Unclassified}
Have you looked at http://members.aol.com/mbtraining/ ? There are self-training courses available there, which sound like what you need. Susan - Original Message - From: "HENDERSON MIKE, MR" <[EMAIL PROTECTED]> To: Sent: Monday, September 19, 2005 4:45 PM Subject: [U2] Are there any UniVerse / U2 Basic Language Self-Study materials? {Unclassified} > Listers, > > I have a less-experienced member of my staff who needs to pass the "IBM > Certified Solutions Expert -- U2 Family Application Development" [i.e. > U2 Basic Language] exam. There are no practice exams available from IBM, > and it seems very unlikely that the relevant training course will ever > be offered in New Zealand, there just aren't enough people interested in > attending. > > So, how does the poor guy get up to speed? > * The PDF User Reference Manuals are not designed as instructional > guides, > and aren't particularly helpful from that point of view. > * His supervisor (that's me, unfortunately for him) is not one of > the > world's great instructors either > > > Are there any UniVerse / U2 Basic Language Self-Study materials out > there in the market? CBT? Books? > Yes, we would actually *pay* *actual* money* for something useful! :-) > > > Any help would be very gratefully received > > > Thanks > > > Mike > The information contained in this Internet Email message is intended > for the addressee only and may contain privileged information, but not > necessarily the official views or opinions of the New Zealand Defence Force. > If you are not the intended recipient you must not use, disclose, copy or > distribute this message or the information in it. > > If you have received this message in error, please Email or telephone > the sender 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]UD Login User
Hope that helps!(You can check out acronyms like that at http://www.ucc.ie/cgi-bin/acronym/acro.html) Susan - Original Message - From: "Marilyn Hilb" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 14, 2005 11:00 AM Subject: RE: [U2]UD Login User > Ok. I have to ask.. What does hth mean?? > > HTH, > > Jeff Fitzgerald > Fitzgerald & Long, Inc. > --- > 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 in Unidata
Jeffrey, For dynamic files with records where the record size is large relative to the key size, I would go with KEYONLY rather than KEYDATA. We have had clients whose files (as KEYDATA) have split repeatedly with large records, so that a file that was 7 gig on Monday would be 19 gig by Thursday, which made their backups take a huge amount of time. Setting the split type as KEYONLY, the same files increased in size, but nowhere near a gig, let alone 12 gig. Susan Lynch - Original Message - From: "Jeffrey Butera" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 24, 2005 10:18 AM Subject: [U2] Dynamic files in Unidata > I have a few questions for those more comfortable with dynamic files in > unidata. Currently I have a statically hashed file: > > File name = H08.CR.FF.TEXT > Number of groups in file (modulo) = 13331 > Static hashing, hash type = 0 > Block size= 16384 > Number of records = 88030 > Total number of bytes = 119079718 > > It's got a 16K blocksize because the size of the records is all over the place > (from a few words to many pages of free form text). We're dumping in about > 5 new records per year so the file size isn't bad now but in the next few > years I anticipate growth (1Gig+) that will most likely lead me to a dynamic > file for this application. > > My questions: > > 1) Can anyone shed insight on 'reasonable' split/merge loads? By reasonable, > I guess I mean I'd like something a little more aggresive than the defaults: > > SPLIT_LOAD=60 > MERGE_LOAD=40 > KEYDATA_SPLIT_LOAD=95 > KEYDATA_MERGE_LOAD=40 > > I've had someone in the past suggest a split/merge load of 20/10, but have no > basis for that suggestion. > > 2) Thoughts about KEYDATA/KEYONLY? I've read the documentation, but I'm > looking for real-world insight from those who have used dynamic files in > unidata. > > 3) Anything else I'm not thinking about but should? (Arguments to not use a > dynamic file are welcome.) Currently, my biggest headache is that resizing > is taking about 45 seconds - I can only imagine how long it would take if I > had 1,000,000 records in there. > > -- > 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 Earle > --- > 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!
Dana, Dumb suggestion, perhaps, but could you temporarily install UD on a separate server, to get the udtconfig file? Then uninstall the UD on the second server, so you aren't in violation of the license agreement. Susan M. Lynch - Original Message - From: "Dana Baron" <[EMAIL PROTECTED]> To: "U2-Users (E-mail)" Sent: Saturday, August 13, 2005 8:17 AM Subject: [U2] Help! > Hi folks, > > Here's your worst nightmare come true: your production system crashes with a > bad system disk. You find that the backups you've been doing every day don't > backup the system, only the data. Now you have to get up and running - fast. > Well, that's where I'm sitting right now. I think I'm going to need some > help from UniData, but it may be hard to reach them on a Saturday so I > thought I'd try the list. Here's what I have: > > There is a new hard disk in the system. > I'm installing a clean OS (Tru64 Unix) right now. > The data, including most of the Unidata install, is on a disk array and > appears to be safe for now. > After the OS install finishes, I need to get UniData up and running. > > One component I will be missing is the stuff in /usr/ud511, which includes > udtconfig. > > Anything else I might need? Anyone know where I can get a good udtconfig for > this? I have the UniData CD, but I don't want to re-install this unless I > have to. > > Thanks in advance. > > I am a most embarrassed... > Dana Baron > System Manager > Smugglers' Notch Resort > --- > 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
Marty, Please go to http://www-306.ibm.com/software/data/u2/pubs/library/52unidata/ and take a look at the Unidata Commands reference manual. You will need to get all users off any account that touches that file, including any web users (if you are running Redback, for example, stop the Redback scheduler), go to a command prompt at the Windows level, in the folder that the corrupted files is in, and run the guide command, but at release 5.2, you probably want to run guide_51 (same syntax). Once you have run guide_51, run the fixfile command as noted in the manual. Then run guide_51 again and check the guide_errors.lis file to make sure that the file is ok. This does not guarantee that you will get all your records back, but it will put the file in a condition where you can read and update records again. Unfortunately, the changes you were trying to write back to the file were lost, so you will have to take a look at that record, and at any others that were listed in the first guide_51 results (the guide_errors.lis file). Hope that helps! Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Monday, April 11, 2005 9:31 AM Subject: [U2] Unidata file corruption > I have a file used in testing whcih I must have copied while a lock was on. > When I try to delete or save a record in the file I get this error: > In D:\UNIDATA\sys\CTLG\a\AE_AE at line 2204 2:block error error in writeshort > fo > r file 'LF', key ' ', number=204537856 > In D:\UNIDATA\sys\CTLG\a\AE_AE at line 2204 1:block error error in > modify_record > for file 'LF', key '292180400101001', number=29802496 > In D:\UNIDATA\sys\CTLG\a\AE_AE at line 2204 1:block error error in > U_append_strt > uple for file 'LF', key '292180400101001', number=1818 > [AE] UniBasic WRITE failed, STATUS=1, check triggers. > > I can edit the record but can't save it or delete it. The same error > appears. > The file is not in L2 overflow and other records are okay. > > Anyway to correct the record without replacing the file? > Win2000/Unidata 5.2 > > thanks in advance, > > [EMAIL PROTECTED] > > > This e-mail may be > privileged and/or confidential, and the sender does not waive any related > rights and obligations. Any distribution, use or copying of this e-mail or the > information it contains by other than an intended recipient is unauthorized. > If you received this e-mail in error, please advise me (by return e-mail or > otherwise) 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] UDT dynamic files
Chuck, if you have records that are relatively large compared to the block size on a Unidata dynamic file that is KEYDATA, even though the record size is not the split-level percentage of the block size, it will trigger a split. I found that a single record written to an empty group, where the record size was about 65% of the block size, would trigger a split, even with the split load set to 95%. Please note: this is from observation of file behavior only - I have not read IBM's code and can not be giving away any trade secrets! I just needed to be able to explain file-sizing to our client companies, and the only way to ensure that I was telling the truth was to experiment a lot and record the results. So, for records with a relatively large average record size, I would recommend KEYONLY, or, if you insist on KEYDATA, at the very least, max out your blocksize in order to minimize splitting. We had a client whose file was mushrooming every week, shrinking every weekend when it was resized, and mushrooming again each week. It was Dynamic Keydata with a large average record size, and it was extremely slow. Making it Dynamic Keyonly improved their performance markedly. Your mileage may vary, of course, but I would advise experimentation! For optimal performance, I tell our clients to stick with static files and to use FAST monthly to resize their files, rather than rely on dynamic files to size themselves properly. The only time I advise dynamic files is when the file approaches 2 gig - at that point, there is no choice. (And, no, I don't work for FAST, so this is not an Ad, just my recommendation based on experience as their customer.) Again, from experimentation, not an official pronouncement from anyone who has read the code, Dynamic Keydata seems to work very well with an average record size of about 100 bytes, in a 2k block size - unfortunately, none of the files in our application meet that criteria. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: "Chuck Mongiovi" <[EMAIL PROTECTED]> To: Sent: Thursday, March 17, 2005 2:20 PM Subject: [U2] UDT dynamic files > Does anyone know what kind of a perfomance hit you take for using dynamic > files? .. I had thought that it was pretty minimal, since splitting > shouldn't occur too much, and merging almost never happens .. > > Anyway, I was archiving data off of a dynamic file today and noticed that a > COPY command was taking a really long time .. I re-wrote the copy in BASIC > so I could put in display counters and got the same results .. I did some > testing and found that doing the same process (READ/COPY/DELETE) using a > STATIC file is faster by a factor of about 10 .. > > Any ideas? > -Chuck > --- > 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] Unique Ids
Aha - the 'same term of experience', but apparently not the same level of understanding! Reminds me of a description by Jane Austen of a person whose university experience had consisted of keeping the necessary number of terms, but forming no useful acquaintance there... Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, March 08, 2005 3:25 PM Subject: RE: [U2] Unique Ids > Susan, > > This is the approach I took with the speaker. There was a period of > time 'in the good old days' where the has could go goofy either through > corruption or keys containing system delimiters .. > > But as the speaker (supposidly with the same term of experieince as I) > was teaching the benefits of MsSql Server and the wonders of sql .. > > DSig > David Tod Sigafoos > SigsSolutions, Inc. > > > > ---- Original Message > > Subject: Re: [U2] Unique Ids > > From: "Susan Lynch" <[EMAIL PROTECTED]> > > Date: Tue, March 08, 2005 11:54 am > > To: u2-users@listserver.u2ug.org > > > > I don't recall an MV implementation that intentionally allowed non-unique > > primary keys. Were the people in the meeting thinking of secondary keys > > (aka indexes) in which non-unique keys are quite possible? > > > > The only other thing I can think of would be the old (and non-intentional!) > > problems with traditional native Pick in which a group in overflow could > > have one of the linked frames written back to disk and another linked frame > > in the group not written back to disk (eg. during a system crash), in which > > case a record which shifted position in the group could end up in both > > frames, and thus in the group twice. In order to get rid of one of the two, > > we used to edit that record in the file, which would bring up the first one > > in the group - look at it to see if this is a complete and up-to-date > > version of the record and either save it to move it to the back end of the > > group or delete it if it was obviously a damaged or partial copy. If we > > did not delete that record, we would then edit the record with that key > > again, which would bring up the one that used to be second and was now the > > first in the group, and decide which one to keep. I haven't seen this on a > > UD system, due to the way that the keys are stored in a table at the > > beginning of the group, and I don't recall having seen it on the UV system > > that I managed for a few years, but I did see it a lot in the earlier days > > in Pick. > > > > Susan Lynch > > F.W. Davison & Company, Inc. > > > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "U2 Users List" > > Sent: Tuesday, March 08, 2005 1:37 PM > > Subject: [U2] Unique Ids > > > > > > > I just came out of a meeting where it was stated that MV databases allow > > > non-unique keys. > > > > > > Now I have been working in the VM world since 1983 and although I can > > > remember a time when some of the implementations had 'problems' with > > > hash and specific data in keys .. i can not think of a time when MV > > > tables allowed non-unique keys. > > > > > > 'Say it aint so Joe' .. > > > > > > If anyone knows of any implementation which specifically allows > > > non-unique ids .. please let me know .. show me the light. Have I be > > > in the back room eating twinkies too long? > > > > > > thanks > > > > > > DSig > > > David Tod Sigafoos > > > SigsSolutions, Inc. > > > --- > > > 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] Unique Ids
I don't recall an MV implementation that intentionally allowed non-unique primary keys. Were the people in the meeting thinking of secondary keys (aka indexes) in which non-unique keys are quite possible? The only other thing I can think of would be the old (and non-intentional!) problems with traditional native Pick in which a group in overflow could have one of the linked frames written back to disk and another linked frame in the group not written back to disk (eg. during a system crash), in which case a record which shifted position in the group could end up in both frames, and thus in the group twice. In order to get rid of one of the two, we used to edit that record in the file, which would bring up the first one in the group - look at it to see if this is a complete and up-to-date version of the record and either save it to move it to the back end of the group or delete it if it was obviously a damaged or partial copy. If we did not delete that record, we would then edit the record with that key again, which would bring up the one that used to be second and was now the first in the group, and decide which one to keep. I haven't seen this on a UD system, due to the way that the keys are stored in a table at the beginning of the group, and I don't recall having seen it on the UV system that I managed for a few years, but I did see it a lot in the earlier days in Pick. Susan Lynch F.W. Davison & Company, Inc. - Original Message - From: <[EMAIL PROTECTED]> To: "U2 Users List" Sent: Tuesday, March 08, 2005 1:37 PM Subject: [U2] Unique Ids > I just came out of a meeting where it was stated that MV databases allow > non-unique keys. > > Now I have been working in the VM world since 1983 and although I can > remember a time when some of the implementations had 'problems' with > hash and specific data in keys .. i can not think of a time when MV > tables allowed non-unique keys. > > 'Say it aint so Joe' .. > > If anyone knows of any implementation which specifically allows > non-unique ids .. please let me know .. show me the light. Have I be > in the back room eating twinkies too long? > > thanks > > DSig > David Tod Sigafoos > SigsSolutions, Inc. > --- > 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] RedBack Performance
Brian, Since you say that the database server is old and slow, have you checked their file sizing on the database server? If poor, that could be contributing to the slowness on both the web and the local applications. Also, does anyone run the Redback Garbage Collection utility periodically? (if it existed on that release - I started dealing with Redback on the 4.0.3 release, where it does exist, and it does help) Susan M. Lynch F.W. Davison & Company, Inc. 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. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, February 15, 2005 9:06 AM Subject: [U2] RedBack Performance > Hi all, > > I'm on a site doing some work enhancing a web site running RedBack. > > Except that is not running: it is crawling, and I've never seen RedBack > so slow. Their server *is* fairly slow and old (running 9.2 uv on AIX) > but on top of the time taken to actually run the subroutines, it seems > that virtually every method call seems to add an extra 2 seconds > overhead, so the cumulative effect is horrible. > > It's not their web server: I've pointed the same web server to a dev > account on my laptop and it flies. Same RBOs, same code. No delays. > > I've also checked the other direction: running a gateway and IIS on my > laptop to access their uv server. Slow. So it isn't anything specific > to networking between their web server and uv server. > > They are running RedBack 3.5.x. Does anyone recall any performance > issues/fixes around that time? Helpfully, the performance monitoring > option doesn't work. > > Any help greatly appreciated. > > 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] Printing different
Harold, There are PCL code sequences that you can send to set a font and a typeface - your printer manual (see HP website if you can't find it) should have the specific codes for your printer, or you can look at standard manuals for PCL5 or PCL6 codes, or check the HP website or websites like http://printers.necsam.com/public/printers/pclcodes/pcl5hp.htm (picked that one because it is relatively straightforward - no association with that company, so, nobody yell "AD" at me! ;-) Susan M. Lynch F.W. Davison & Company, Inc. 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. - Original Message - From: "Oaks, Harold" <[EMAIL PROTECTED]> To: Sent: Friday, February 11, 2005 3:11 PM Subject: [U2] Printing different > Does anyone know if there is an 'easy' way to create a print file, sent > to a standard HP laser priner, and get the printer to print various > fonts and sizes when desired. What I really would like is to have the > output be normal size, then include very large letters when desired in, > say, Arial font size 24, then revert back. Obviously Word etc. can send > some string to the printer from which it understands to print the next > characters in the desired font and size. Is there some string > "Esc-something-something-something..." which I can embed in the file > which will make this happen? I am running under pi/open. > > Thanks- > > 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/
Re: [U2] Universe full screen editor
Scott, Suggestion 1: if you have no UniVerse documentation, go to the IBM website and download yourself some UniVerse manuals! http://www-306.ibm.com/software/data/u2/pubs/library/ Suggestion 2: take a look at the UniVerse Guide to the UniVerse Editor (from that IBM website) - page 1-24 and the following pages discuss replacing system delimiters with the editor. Suggestion 3: UniVerse accounts, like UD accounts, can have flavors, which affect the way that the various commands run. Take a look at the documentation to see which version you will be most comfortable with. Also from those manuals, uv -version should tell you which UniVerse Version you are running, which will help you find the correct set of manuals. I thought I remembered WHAT or VERSION giving similar information, but don't see if those in the manuals, so I may be confusing it with other Pick variants. I never used a full-screen editor when I was working on UniVerse systems - the editor is similar to AE on UD, but there are some differences. Susan M. Lynch F.W. Davison & Company, Inc. - Original Message - From: "Scott Land" <[EMAIL PROTECTED]> To: Sent: Monday, February 07, 2005 12:49 PM Subject: [U2] Universe full screen editor > I am working on a client's Universe server with no documentation. The > client is using software they purchased. I need to update a few records > that have multivalues and the ED help doesn't say how I can insert or > replace values. > > Does a full screen editor come with Universe? Or is there some way to > call a full screen editor from the operating system? > > Typing listu gets me a user named "NT AUTHORITY\system". While logging > off and back on I get the following text "Vmark Universe" and "Universe > Command Language 9.4". > > I am normally a Unidata programmer so this is a bit of a struggle. > > Thank you for your assistance, > Scott Land > Senior Programmer > USA 800, Inc. > --- > 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] Pyramid HR [AD]
Steve, I work for the company that developed and sells HR Pyramid in the Tech Support department. Please feel free to contact me for information on the product! Susan M. Lynch F.W. Davison & Company, Inc. (781) 340-9255 DON'T MISS THE 5TH ANNUAL HRPYRAMID USER CONFERENCE! September 15-16, 2004 - Register now at http://www.fwdco.com/services/uconf04/default.shtm 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 (508) 747-7261 and immediately destroy all copies of the original message. - Original Message - From: "Steve Kunzman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 05, 2004 9:06 AM Subject: [U2] Pyramid HR > Has anyone worked on a package called Pyramid HR? It uses Unidata for its > database. Any details would be appreciated. > > TIA > > Steve Kunzman > Minneapolis, MN > (612)750-3899 cellular > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2UG Needs You
Thanks, Chuck! Once it is out there, we will be including it, probably on our 'technical' page where we talk about the database. Susan M. Lynch F.W. Davison & Company, Inc. - Original Message - From: "Results" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 14, 2004 7:13 PM Subject: Re: [U2] U2UG Needs You > Susan, > There will be a sticker. It has been designed, but not approved. We > should have it in about a week. There's also talk about forming a web ring. > > - Chuck "Sticker Shock" Barouch > > Susan Lynch wrote: > > >In a recent email from Dana Baron, we were all asked: > > > >>. U2 Promotion - We need people who are willing to put a U2UG member > >>sticker and link on their home pages (personal and corporate) and > >> > >>otherwise promote these powerful products. > >> > >> > > > >I went to the website - is there a link to download the member sticker? I > >did not see one! Where should we all be looking in order to do this and > >promote U2? > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2UG Needs You
In a recent email from Dana Baron, we were all asked: > 5. U2 Promotion - We need people who are willing to put a U2UG member > sticker and link on their home pages (personal and corporate) and otherwise > promote these powerful products. I went to the website - is there a link to download the member sticker? I did not see one! Where should we all be looking in order to do this and promote U2? Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How create list of uv files from VOC?
In response to: "LeRoi Keiller" <[EMAIL PROTECTED]> > Wondering if any of you programmers could tell me how to output the paths of > UniVerse files that are listed in the VOC - ie files of type F - to a text > file? (I wish to use the generated list from and for a unix script.) > It has been a while since I was on a UniVerse system, and I am currently on a Windows system, but something like this should work (it just worked for me on UniData on Windows, and these commands are similar on both U2 versions, afaIk): SSELECT VOC WITH F1 = "F" "DIR" BY F2 F2 SAVE-LIST FILEPATHS COPY.LIST FILEPATHS TO:(BP or to some other directory file where you can then retrieve it in Unix. Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Proc
Steve, Try http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html for the UniVerse Guide to ProVerb, Version 10.1 (G251-1922-00), which is a reasonably complete Proc manual - IBM calls it "ProVerb" rather than Proc! Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. - Original Message - From: "Steve Mayo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 23, 2004 4:42 AM Subject: [U2] Proc > I know it's a dirty word, but I am in the need of a "proc" manual. My > client has over 200 procs of which some are very esoteric. > > Any help would be appreciated. > > Steve Mayo > Oasis Automation > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] relative speed of Retrieve SELECT vs Basic SELECT, LOOP READNEXT,READ.
In response to Charles Stevenson, who said: IIRC, UD routinely (usually? often? always?) stores data more like UV's "large records". - Unidata stores a key/displacement table at the beginning of each group, and does not store the key physically with the data in the record for any record (other than the first record in the group, since the key list begins at the back end of the table and is stored in reverse order). UniVerse's large record handling, if I read the documentation correctly, stores the ID in the main body of the group at the position where the record would normally be stored, but places the data in an overflow area. The differences between the two U2 products are interesting if you are into optimizing file-sizing, or if you find a particular technique in your programming tends to work better or worse on one than on the other, as this thread seems to have demonstrated. I suspect the 'better' and the 'worse' are evenly distributed, though, so please, no 'flavor' (or 'flavour', depending on your location when you learned to spell) wars! ;-) Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Printer Question
In response to: "Walker, Dave (Ivy Hill)" who asked: > Is there a way to assign TWO printers to a single print job. I.E., we want a > report to print both on the shipping floor and in the shipping manager's > office. The only thing I could come up with was to run the report once for > each printer. Any way to generate it once and send it to both printers at > the same time? If you are on Unidata, the Unidata commands manual indicates that you can do it this way, if your report is being generated by a Basic program: ---Submitting Concurrent Print Jobs With SETPTR, you can define up to 31 logical printer units per UniData session. You can use this functionality to submit concurrent print jobs fom a UniBasic application. One common implementation follows: - Define two logical printer units (for instance, 0 and 1) that point to different physical print devices. - Direct all lines of a report to one printer with the UniBasic PRINT ON command (for instance, PRINT ON 0 PRINT.LINE). - Direct summary (break) lines to the second printer (PRINT ON 0 PRINT.LINE followed by PRINT ON 1 PRINT.LINE). In this way, you can print a summary report and a detail report at the same time. --- Or, in your case, print each line to each printer, so that you don't have to run the same job twice with 2 different destinations. Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Cost of Oracle vs PICK
In response to a posting from "Jeff Flynt" <[EMAIL PROTECTED]> in which he stated: "...In this modern day who really cares how many bits a piece of data requires? Bits are cheap! Have two! Is the relational database slower? You can bet on that! But it is also doing a lot more. More work requires more time! Even if the internal structures are very inefficient the hardware today can help compensate. ..." In my early days as a programmer, working for a consulting firm, one of my very successful customers said to me, "Take care of the pennies and the dollars will take care of themselves!" That philosophy built him a business that took care of him and his family and a large number of employees for his entire working career, and has stuck with me throughout my career. Later on, when running my own consulting business, I know that I always wanted the most 'bang for the buck' from every piece of equipment that I bought for the business - and that means not wasting disk storage that I paid good money for, just because some programmer did not think it was worth his/her time and effort to choose the most efficient database product, design the file structures sensibly (and with the hashing algorithm in mind!), and write (and document) maintainable and efficient code - which are not mutually exclusive goals. And, as other responders have noted, it is possible to write modern functionality and excellent security into an mv product - and I would expect that it would run faster and use far less resources in hardware and labor than the corresponding big-name database products. One can complain about some of the design and development decisions made on some of the older applications, but should differentiate between shortcomings in the application code and shortcomings in the database product. While disk is cheaper now than it was then, and memory is cheaper, and labor is more expensive, as a business owner or stockholder, I would still expect any manager to be able to cost-justify any practice that uses more resources than were absolutely necessary, whether that be application design, database selection, or leaving all the lights on in an empty building at night. "Take care of the pennies, and the dollars will take care of themselves!" Jeff also said: "...Truth be told, I want a black box database. I do not care how the grand designers implemented the internal structures, i.e., records composed of delimited strings, hashed files... If I have to know that then I have to know to much. Knowing it may have its advantages. ..." If you don't know how it works, you will never know how to tune it to perform efficiently. More importantly, when it breaks, you won't be able to repair it (and yes, I have seen an Oracle database exhibit symptoms that I would call data corruption - I forget what euphemism our Oracle VAR used for it - and we had to restore from a backup, because nobody had the necessary skill set or tool set to repair it, including our VAR and their tech support backup, and we lost data!). I prefer being able to look at a hex dump and make sure that I have done everything possible to ensure the integrity and wholeness of the data entrusted to my care. No black boxes for me, thank you very much! Although it is harder and harder these days to find products where you can look under the hood, sigh... Susan M. Lynch F.W. Davison & Company, Inc. 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 (508) 747-7261 and immediately destroy all copies of the original message. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] SB Problem - Urgent
In response to a message from: kafsat taiyus First, the problem looks like data corruption, given the error messages shown. Second, how to fix it: - Make sure all the users are logged off. - Go to the SB directory and run guide_51 DMCONT This will produce a guide_errors file that will show you the errors and will allow the fixfile command to repair them: - Run the fixfile command fixfile -dDummyfile -f where Dummyfile is a file name that is not used in your application - it will hold some output from the fixfile command when finished. - Run another guide_51 DMCONT, and check the guide_errors file to be sure that there are no errors this time. - Repeat fixfile and guide_51 if errors occur again. Users can get on after you stop seeing errors in the guide_errors file. Third, what causes data structure errors? There are a number of possible causes, including, but not limited to, system crashes, hardware and power problems, someone using a DOS or Windows or Unix text editor to change something in a UniData file without understanding the underlying file and record structure issues, a static file hitting the 2 gig limit, a file being restored from a damaged backup medium, etc. Given that it is DMCONT, and not likely to be maintained by your application programs, I suspect that some of the other possible causes can be ruled out, like users updating the file without proper locking, one user doing a clear-file while someone else was updating the file. Good luck getting the system back up for your users! Hi, No body can log in to SB+ error Current UniData home is /usr/ud52/. Current working directory is /data1/rtime/SBPlus/SB. 2:blk check error in U_post_read for file 'DMCONT', key 'SB.ACCOUNTS', number=33 1:block check error in modify_record for file 'DMCONT', key 'SB.ACCOUNTS', numbe r=34816 1:block check error in U_append_strtuple for file 'DMCONT', key 'SB.ACCOUNTS', n umber=33 Fatal error: WRITE error Any idea why this is happening and how to fix it? Regards Kafsat