Re: [U2] [UV] Hash.Help
Bill, You aren't able to resize files that are open -- since you are in the account whose VOC you are trying to resize, it is open by default. So resizing the VOC becomes a little tricky; here's a recipe: 1) Logout or quit to UNIX and then get to the UniVerse prompt in another account. Make sure that no other users are doing anything in the account whose VOC you want to resize. *** MAKE SURE YOU HAVE A BACKUP OF THE VOC *** 2) Set a file pointer to the VOC you want to resize. SETFILE pathname_to_the_VOC QFILE 3) Do the resize using the pointer, as in: RESIZE QFILE 17 1237 4 Hope this helps, Jeff Fitzgerald Fitzgerald Long, Inc. http://www.fitzlong.com On 2/17/10 4:48 PM, Brutzman, Bill bi...@hkmetalcraft.com wrote: Our UniVerse system has been slow over the last few weeks. It seems to take approx one second to launch any program. It just hangs there for a second. So... I tried to resize VOC... and obtained the following error (at the bottom). Help would be appreciated. --Bill *--- --- HASH.HELP VOC File VOC Type= 17 Modulo= 1237 Sep= 2 06:42:48pm 17 Feb 2010 PAGE1 Of the 5053 total keys in this file: 5 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 4479 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 560 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their entirety. The smallest modulo you should consider for this file is 859. The smallest separation you should consider for this file is 4. The best type to choose for this file is probably type 17. RESIZE VOC 17 1237 4 RESIZE: Error on VOC. File not resized. ___ 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] [UV] Hash.Help
Thanks to Charlie, Jeff, John and especially Will. I expect to punt and reboot the box later today. It is valuable that Will is back on the list after perhaps a one year hiatus. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Wednesday, February 17, 2010 7:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Hash.Help Bill from your stat report, it's doubtful that this is your problem. Your VOC appears to be more or less sized fine. Even were it very badly sized, one second seems long. I would consider that something in your system is eating CPU like a wild hog. That's more likely to be the culprit. Will Johnson ___ 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] [UV] Hash.Help
In a message dated 2/18/2010 7:44:36 AM Pacific Standard Time, bi...@hkmetalcraft.com writes: Thanks to Charlie, Jeff, John and especially Will. I expect to punt and reboot the box later today. It is valuable that Will is back on the list after perhaps a one year hiatus. Yes like Dolly says, I've been away from the lights of 14th Street and into my personal haze. Now that I'm back in the lights of 14th Street, tomorrow will be brighter than the good old days. I swear I'm not wearing a wig and a big hat well maybe the hat. Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Hash.Help
Our UniVerse system has been slow over the last few weeks. It seems to take approx one second to launch any program. It just hangs there for a second. So... I tried to resize VOC... and obtained the following error (at the bottom). Help would be appreciated. --Bill *--- --- HASH.HELP VOC File VOC Type= 17 Modulo= 1237 Sep= 2 06:42:48pm 17 Feb 2010 PAGE1 Of the 5053 total keys in this file: 5 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 4479 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 560 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their entirety. The smallest modulo you should consider for this file is 859. The smallest separation you should consider for this file is 4. The best type to choose for this file is probably type 17. RESIZE VOC 17 1237 4 RESIZE: Error on VOC. File not resized. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Hash.Help
Resizing the VOC is only for the non quiche eating real manly admins. I have found that the only way to do this is remotely via q-pointers from another account - and make sure you have triple backups, belts, braces (suspenders) and safety nets, parachutes and back-doors easily accessible. Cheers JR -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, February 17, 2010 6:50 PM To: U2 Users List Subject: Re: [U2] [UV] Hash.Help We are running UV 10 on HP-Ux Itanium. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, February 17, 2010 6:48 PM To: U2 Users List Subject: Re: [U2] [UV] Hash.Help Our UniVerse system has been slow over the last few weeks. It seems to take approx one second to launch any program. It just hangs there for a second. So... I tried to resize VOC... and obtained the following error (at the bottom). Help would be appreciated. --Bill *--- --- HASH.HELP VOC File VOC Type= 17 Modulo= 1237 Sep= 2 06:42:48pm 17 Feb 2010 PAGE1 Of the 5053 total keys in this file: 5 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 4479 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 560 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) The keys in this file are more unique in their entirety. The smallest modulo you should consider for this file is 859. The smallest separation you should consider for this file is 4. The best type to choose for this file is probably type 17. RESIZE VOC 17 1237 4 RESIZE: Error on VOC. File not resized. ___ 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] [UV] Hash.Help
Bill from your stat report, it's doubtful that this is your problem. Your VOC appears to be more or less sized fine. Even were it very badly sized, one second seems long. I would consider that something in your system is eating CPU like a wild hog. That's more likely to be the culprit. Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV HASH.HELP error
Sorry I forgot the subject line the first time. I've also tested this on our Linux system running the same revision with the same results. Jerry -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- 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] UV HASH.HELP error
Actually, this could be a VERY OLD feature ... :-) I seem to remember it being documented that HASH.HELP and HASH.HELP.DETAIL (or similar) had a habit of disagreeing with each other on Prime INFORMATION. Now that's going back some ... ! Anyway, the advice always was don't trust HASH.HELP. Suck it and see Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 20 June 2007 15:12 To: u2-users@listserver.u2ug.org Subject: [U2] UV HASH.HELP error Sorry I forgot the subject line the first time. I've also tested this on our Linux system running the same revision with the same results. Jerry -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- 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] UV HASH.HELP error
HASH.HELP has improved over the years, but I sure wouldn't accept its results blindly! The most interesting part of your post, to me, is the variation in type recommendations -- type 10 v.s. 18. As you suggest, the modulo should be made a prime whether it's calculated by HASH.HELP or some other source. For the type, the basic problem with HASH.HELP is that it uses only an analysis of the record key patterns. This is inferior to a simulation approach. Of the available Universe tools I'd choose HASH.AID, testing all the types 2 through 18, and then looking at the resultant data (LIST HASH.AID.FILE) for smallest overflow and tightest hashing. HASH.AID isn't perfect as it doesn't report empty groups but at least it is a simulation rather than just eyeballing the record keys. Of course, the main thing is to keep those files sized! An implemented non-optimum resize is better than a theoretical perfect solution. Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- 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] [UV] HASH.HELP
Hi all, UV9.6 HPUX11 Anyone seen this before? Program /dbms/uv/uv/bin/hash.help terminated. [SIGSEGV] segmentation violation What does it mean? The file that I was using HASH.HELP was not enormous. Number of records = 3800854 Number of physical bytes= 569976832 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] HASH.HELP
My first guesses would be that either the file is corrupt or that it was being resized and the resize was aborted. I'd suggest running uvfixfile against the file (or FAST if you are using it.) HTH Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, May 26, 2005 10:37 AM To: u2-Users Subject: [U2] [UV] HASH.HELP Hi all, UV9.6 HPUX11 Anyone seen this before? Program /dbms/uv/uv/bin/hash.help terminated. [SIGSEGV] segmentation violation What does it mean? The file that I was using HASH.HELP was not enormous. Number of records = 3800854 Number of physical bytes= 569976832 --- 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/