In UniData there is no such animal as a distributed file. You only have the choice of static hashed or dynamic hashed. Dynamic files in UD are how you get past the 2 gig limit because the UD implementation of dynamic files breaks the file into different pieces. How many pieces and what goes into each 'piece' is decided by the hashing algorithm (no control by the user).
In UniVerse dynamic files are much the same as UD with the exception that they don't have different 'pieces'. That's why in UV dynamic files do not get you past the 2 gig limit. UV has a different animal called a distributed file. In a UV distributed file the number of pieces and what goes into each piece is set by the user. HTH, Gordon Gordon J. Glorfield Sr. Systems Analyst MAMSI 301-360-8839 -----Original Message----- From: HENDERSON MICHAEL MR [mailto:[EMAIL PROTECTED] Sent: Thursday, January 29, 2004 2:52 PM To: 'U2 Users Discussion List' Subject: UNCLASSIFIED RE: [UV] Resize - Dynamic or 64 bit? Dynamic files are no help in your situation, they are 2GB or 64-bit just like hashed files. You need either 64-bit or a DISTRIBUTED file. [I think this kind of file is called 'dynamic' in UniData, just to make things confusing!]. A distributed file divides the data into several portions based on the record-ID. There have been several discussions of UniVerse Distributed files on the list in the past year or so, check the archives. HTH Mike > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Behalf Of [EMAIL PROTECTED] > Sent: Friday, 30 January 2004 8:28 a.m. > To: [EMAIL PROTECTED] > Subject: [UV] Resize - Dynamic or 64 bit? > > > Hi all, > > UV 9.6 / HPUX 11 > > I have a hashed file approaching the 2 gig limit. I need > some help determining whether to go with the dynamic or 64 bit option. > > Here are some specifics. > > The file is our inventory history file which is, as you can > imagine, used heavily. Approximately 85 percent of the > records are 4k in size. > > I have always frowned upon using dynamic files because they > seem to be slower compared to hashed. Maybe because I have > never attempted to figure out how to tune them. > > Can anyone give me the pros/cons of using the 64 bit versus > dynamic option? > > Thanks in advance, > > Scott > _______________________________________________ > u2-users mailing list > [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > 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 [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
