Hi,
What is the best way to choose the control interval size for the data and index in VSAM? And should we even bother about it while defining a VSAM?
As of now I look at the existing VSAM, used for similar work and define the new VSAM file.
Control interval size for VSAM.
-
- New Member
- Posts: 1
- Joined: Wed Nov 12, 2014 9:13 am
- Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Control interval size for VSAM.
The access pattern should help determine CI sizes. For a KSDS being read completely randomly, use a shorter data CI size; for a completely sequential access, use a longer data CI size. How long or how short? That depends on a lot of factors -- average record length, free space needed, etc. For the index CI size, the one thing you want to make sure of is that the CI size is big enough to allow access to all the data CI -- if not, you're wasting space.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute