Page 1 of 1

VSAM CI SIZE

PostPosted: Thu Mar 14, 2013 8:41 pm
by ewansyo
How does the CI SIZE affect the ESDS VSAM file in terms of processing speed? Does larger CI SIZE much faster?

Re: VSAM CI SIZE

PostPosted: Fri Mar 15, 2013 12:33 am
by c62ap90
I always start define as CISZ (4096) and then depending on, for example, Splits - I contact our Systems Programmer for VSAM file tuning.

Some more info...
http://pic.dhe.ibm.com/infocenter/pdthe ... pvsm51.htm
An average CISZ of 4K is suitable for most applications. A smaller CISZ means faster retrieval for random processing at the expense of inserts (that is, more CISZ splits and therefore more space in the data set). A larger CISZ results in the transfer of more data across the channel for each READ. This is more efficient for sequential processing, similar to a large OS BLKSIZE.

Re: VSAM CI SIZE

PostPosted: Fri Mar 15, 2013 1:15 am
by Robert Sample
For an ESDS, I'd probably go with 18432 which is most space-efficient. However, if the application is running under CICS 4096 might work better as there is less data written at a time. If the application is running only batch ESDS with no alternate indexes, then 32768 might be your best CI SIZE. There is no one "true" answer to a question like yours -- it depends upon the site, whether the ESDS file has alternate indexes, whether the ESDS file is used online only or batch only or both, and other factors.

Re: VSAM CI SIZE

PostPosted: Fri Mar 15, 2013 9:45 am
by ewansyo
Hi,

Thank you both for the helpful responses. :)

The ESDS file has no alternate index and will be used only as an online log, we would only do write to this file. So does it mean that 32768 might be good for this type of file?

Re: VSAM CI SIZE

PostPosted: Fri Mar 15, 2013 1:06 pm
by NicC
If the application is running only batch ESDS with no alternate indexes, then 32768 might be your best CI SIZE.

Re: VSAM CI SIZE

PostPosted: Fri Mar 15, 2013 4:58 pm
by Robert Sample
For an online log, 4096 is probably your best choice. You want logs to be written fairly quickly, and hence a smaller CI SIZE makes sense.