how to give record size in vsam while creating AIX

ankitkja · New User Joined: 21 Jul 2010 Posts: 4 Location: pune

im trying to create a AIX.but not getting how to define the record size.

PeterHolland · Posted: Wed Jul 21, 2010 11:09 am

RECORDSIZE(average maximum)

defaults are : average = 4086
maximum = 32600

sample :

expat · Posted: Wed Jul 21, 2010 12:26 pm

There was an extract posted on the forum for calculating the AIX RECSZ which Robert Sample supplied. If a search of the forum does not show that thread, then either the IDCAMS manual or the redbook VSAM demystified will show the formula.

Robert Sample · Posted: Wed Jul 21, 2010 3:59 pm

AIX record size is based upon the size of the primary key, the size of the alternateindex key, and the number of allowed duplicate alternateindex keys (plus system overhead of course).

PeterHolland · Posted: Wed Jul 21, 2010 4:10 pm

Yes Robert, and as far as i see it, one should use high values when
expecting lots of duplicates. Most of the times i found it trial and error
handling doing AIX defines.

Robert Sample · Posted: Wed Jul 21, 2010 4:18 pm

Peter: definitely -- unless you know the data real well, you're usually better off allowing for more than you expect will be needed!