Hi,
I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields.
Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out what to do with it).
Thanks in advance,
Martin Gilbert.
Software/Hardware used:
ASKED:
February 8, 2008 10:36 AM
UPDATED:
March 14, 2010 1:08 AM
Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can’t make out what to do with it).
Simplest way for me is to test it physically. Create the index and add 100, 5000, 10000 entries. The more increments you can use, the better your trendlines will be.
I might work the formulas if you supply key length and access path size.
Tom