The dynamic file I'm working with is below. What do 'overflowed' and 'badly' refer to under MODULUS? Is the goal of the RESIZE to eliminate that overflow? Any ideas what I should change to achieve this?
File name .................. TEST_FILE Pathname ................... TEST_FILE File type .................. DYNAMIC File style and revision .... 32BIT Revision 12 Hashing Algorithm .......... GENERAL No. of groups (modulus) .... 82850 current ( minimum 24, 104 empty, 26225 overflowed, 1441 badly ) Number of records .......... 1157122 Large record size .......... 2036 bytes Number of large records .... 576 Group size ................. 4096 bytes Load factors ............... 80% (split), 50% (merge) and 80% (actual) Total size ................. 449605632 bytes Total size of record data .. 258687736 bytes Total size of record IDs ... 19283300 bytes Unused space ............... 171626404 bytes Total space for records .... 449597440 bytes Thanks, Chris > From: cjausti...@hotmail.com > To: u2-users@listserver.u2ug.org > Date: Mon, 2 Jul 2012 14:55:21 -0500 > Subject: [U2] RESIZE - dynamic files > > > I was wondering if anyone had instructions on RESIZE with a dynamic file? For > example I have a file called 'TEST_FILE' > with the following: > > 01 ANALYZE.FILE TEST_FILE > File name .................. TEST_FILE > Pathname ................... TEST_FILE > File type .................. DYNAMIC > File style and revision .... 32BIT Revision 12 > Hashing Algorithm .......... GENERAL > No. of groups (modulus) .... 83261 current ( minimum 31 ) > Large record size .......... 3267 bytes > Group size ................. 4096 bytes > Load factors ............... 80% (split), 50% (merge) and 80% (actual) > Total size ................. 450613248 bytes > > How > do you calculate what the modulus and separation should be? I can't use > HASH.HELP on a type 30 file to see the recommended settings > so I was wondering how best you figure out the file RESIZE. > > Thanks, > > 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