Size of dataset

muffirulz · Posted: Fri Mar 17, 2006 1:27 am

Hi,

I would like to know the size of the dataset to be specified if it has to contain 7 million records of a field which is of size x(13).

Thanks,

martin9 · Posted: Fri Mar 17, 2006 1:37 am

hy muffyrulz,

try to give 100 cyls as primary and 50 as secondary space,
this should be more than enough.
just never forget to give the RLSE word, for the unused
space amount will be released again...

SPACE=(CYL,(100,50),RLSE)

if you like to optimize, because to cannot use to much disk space,
then look after the space taken and correct your job, with the space used
as primary and about ca. 10% as secondary. (one day you might have
more than 7million recors...).

martin9

superk · Posted: Fri Mar 17, 2006 1:52 am

I would just use

SPACE=(13,(7,1),RLSE),AVGREC=M

Our system-calculated allocation routine comes out with:

SPACE=(13,(6915,1383),RLSE),AVGREC=K

so either one ought to work.

martin9 · Posted: Fri Mar 17, 2006 1:59 am

hy superk,

you can do it also in blocks...
...one record per block, i never tried like this...
is this better for further access to the dataset,
or better for space management...i cannot figure...

you have some tips on this, for better dataset allocations...

martin9