Sorry if this is a bit thick, I'm a UV guy rather than a UD guy. But when you said "I've tried changing split/merge loads from the default of 60/40 to 20/10" wouldn't that make the file much bigger?
I don't know if UD works differently but in UV this would mean a new group was created every time the actual file load hit 20%.... so setting it to 20/10 in UV I'd expect the file to be about 5x bigger than the amount of data in it... How you've gone from 75MB to 4.3GB I can't explain though!! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 01 February 2006 02:15 To: [email protected] Subject: [U2] Dynamic Files As someone who's not a newbie, but has some newbie questions from time to time... I need some decent info on Unidata dynamic files. I've got the IBM/U2 docs as well as a couple of Fitz & Long PDFs on file hashing. In short, we use static hashing on most files and have no trouble, resize weekly (or more often) and keep great tabs on modulos, overflow and the like. However, we have a couple that are approaching 1Gig in size and I don't want to wait until I get any closer to the 2Gig limit before moving some of the large ones to dynamic hashing. However, the few files I have moved to dynamic hashing are rediculous in size. I'm obviously setting some file parameters wrong, but would like insight from anyone who has good luck... The file STC.HIST as a dynamic file takes up 4.3Gig of disk space. It has around 944,000 records, a blocksize of 1024 but a modulo of 4,000,000+ When I convert this to a static file, I can properly size it with a modulo of around 94,000 which takes up a mere 75Meg. I've tried changing split/merge loads from the default of 60/40 to 20/10. I've tried playing with the minimum modulo. I'm clueless on dynamic files and would love any insight. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "We make moral decisions everyday even if we don't know it." Scott Simon (NPR) on the death of 20,000 coal miners annually in China. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ********************************************************************** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ********************************************************************** ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
