I guess my main question is regarding the 'overflow' and 'badly' #'s which you
can see when you do an ANALYZE.FILE <filename> STATISTICS.
Is the goal not to have any overflow #? And what is 'badly'?
After playing around with RESIZE on this file, I was able to come up with the
following:
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 24
82850 current ( minimum 24, 104 empty,26225
overflowed, 1441 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 1000
82850 current ( minimum 1000, 104 empty,26225
overflowed, 1441 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 99420
99420 current ( minimum 99420, 182 empty,18725
overflowed, 1054 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 119304
119304 current ( minimum 119304, 247 empty, 9511
overflowed, 406 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 143165
143165 current ( minimum 143165, 1328 empty,4333
overflowed, 259 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 171799
171799 current ( minimum 171799, 3814 empty,3063
overflowed, 237 badly )
RESIZE TEST_FILE 30 GROUP.SIZE 2 MINIMUM.MODULUS 223339
223339 current ( minimum 223339, 9215 empty,1810
overflowed, 222 badly )
As you can see as I increase my MINIMUM.MODULUS, my 'overflowed' and 'badly'
#'s go down. Is this the goal when tuning a dynamic file?
Chris
> From: martinphill...@ladybridge.com
> To: u2-users@listserver.u2ug.org
> Date: Mon, 2 Jul 2012 20:56:40 +0100
> Subject: Re: [U2] RESIZE - dynamic files
>
> Hi Chris,
>
> The whole point of dynamic files is that you don't do RESIZE. The file will
> look after itself, automatically responding to
> variations in the volume of data.
>
> There are "knobs to twiddle" but in most cases they can safely be left at
> their defaults. A dynamic file will never perform as well
> as a perfectly tuned static file but they are a heck of a lot better than
> typical static files that haven't been reconfigured for
> ages.
>
>
> Martin Phillips
> Ladybridge Systems Ltd
> 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
> +44 (0)1604-709200
>
>
>
>
> -----Original Message-----
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
> Sent: 02 July 2012 20:22
> To: u2-users@listserver.u2ug.org
> 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
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
