[U2] Sequentially Hashed Files

2009-10-20 Thread Raymond P. de Bourbon
Does anyone have any experience using Sequentially hashed files? The documentation on Sequentially hashed files is not very explicit about what kinds of benefits or problems can be expected / experienced.. It also only hints towards one use case, but IMO doesn't do enough to clearly define when

[U2] [UV] List of hashed file types

2009-10-20 Thread Jeff Schasny
Somehow, I have lost my list of Universe Hashed File Types and their recommended associated ID structures and I cant seem to find it in the Universe System Admin or System Description .pdf's Can someone point me to where its hiding in the documentation? --

Re: [U2] [UV] List of hashed file types

2009-10-20 Thread br...@brianleach.co.uk
Hi Jeff Not to hand, but here's the help from HASH.HELP and CREATE.FILE: CREATE.FILE:  The valid types are: *TYPE*   *USAGE*   1  Sub-UFD type file, for large records or source code.   2  Hashed.  Keys end with numbers.   3  Hashed.  Keys end mainly with numbers.   4 

Re: [U2] [UV] List of hashed file types

2009-10-20 Thread Jeff Fitzgerald
Jeff, A quick way to get this info is to use the CREATE.FILE command and enter ? at the file type prompt: 1 Sub-UFD type file, for large records or source code. 2 Hashed. Keys end with numbers. 3 Hashed. Keys end mainly with numbers. 4 Hashed. Keys end with

Re: [U2] Sequentially Hashed Files

2009-10-20 Thread Anthony W. Youngman
In message 5e5ef002669716488cf5f69288ba6b093bf...@msgl-lon01-es01.msgluk.local, Raymond P. de Bourbon rdebour...@msgl.com writes Does anyone have any experience using Sequentially hashed files? The documentation on Sequentially hashed files is not very explicit about what kinds of benefits or

Re: [U2] Sequentially Hashed Files

2009-10-20 Thread Raymond P. de Bourbon
Thanks for the response.. Here's my situation: The app is generating records with sequential numeric keys and over time the records are deleted with the file returning to a count of zero.. The record sizes can vary considerably from record to record... Currently we are using dynamic files and are

Re: [U2] Sequentially Hashed Files

2009-10-20 Thread Tom Whitmore
Hi, Creating a type-19 file (or type-1) has advantages with large records IF you are not doing many reads and writes to the file. If you are updating a type of log record, look into using OPENSEQ, READSEQ, WRITESEQ, instead of READs and WRITEs. With the SEQ functions, you are appending

Re: [U2] [UV] List of hashed file types

2009-10-20 Thread Jeff Schasny
Thanks Jeff Brian. That will work. Jeff Fitzgerald wrote: Jeff, A quick way to get this info is to use the CREATE.FILE command and enter ? at the file type prompt: 1 Sub-UFD type file, for large records or source code. 2 Hashed. Keys end with numbers. 3 Hashed.

Re: [U2] Sequentially Hashed Files

2009-10-20 Thread David Jordan
Hi Ray Are you using UniVerse or UniData. I use dynamic files and never have to resize them in UniVerse. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Sequentially Hashed Files

2009-10-20 Thread Womack, Adrian
Have you tried setting MINIMUM.MODULUS to a high value on your dynamic file. This prevents the file from merging below the size you've set. Although it can still split to larger than that size. You can use the CONFIGURE.FILE command to set MINIMUM.MODULUS - but it won't take effect until the

[U2] Distributed file on Unidata Unix (DEFINE.DF)

2009-10-20 Thread Manu Fernandes
Hello, I'm looking for a solution to distribute a Unidata/Unix Hashed file like Universe does with the DEFINE.DF verb and PartKey algorythm. Is there someone with any idea ? With kind regards. Manu ___ U2-Users mailing list