RS, CA free space is not normally irrelevant . If you are performing random writes it is very generally useful to have some, and CI free space is less useful as the overhead of a CI split is very small compared to a CA split. The only time when free space is not useful is if you are only (randomly) adding records to the end of the file (e.g. date YYYYMMDD at the start of the key). I know this to be true because I have done a lot of VSAM tuning for customers over the last 20 years.
There is a good Redbook on VSAM which explains the whole thing in detail. Go have a read. Regards. Mike ------------------------------------------------------------------------------------------------------------------ Mike Poil Java z/OS Level 3 Service IBM United Kingdom Limited, Hursley Park, Winchester SO21 2JN Internal: 246824 External: +44 (0)1962 816824 Java debugging: http://www.ibm.com/developerworks/java/jdk/diagnosis/ ------------------------------------------------------------------------------------------------------------------ "R.S." <[EMAIL PROTECTED]> Sent by: IBM Mainframe Discussion List <IBM-MAIN@BAMA.UA.EDU> 03/12/2007 17:02 Please respond to IBM Mainframe Discussion List <IBM-MAIN@BAMA.UA.EDU> To IBM-MAIN@BAMA.UA.EDU cc Subject Re: KSDS CA split, no CI split Mike Bell wrote: > I can think of 2 posible causes, > you do not have sufficient space in the INDEX component for any new CI's > therefore > 1. any new records, have to go to a new CA ie CA split > 2. the more CA's you have (ie increase free space for the CA which means the > data is loaded across more CA's) the more CA's there are to split. > The way to fix that is to change the CI size of the index component. I've tried with index CISZ up to 20kB. It haven't help. Finally I eliminated CA splits by increasing CI free space (large values, >30%). CA free space is simply irrelevant! > OR, you are using REPRO to add the records, which I thought always uses bulk > insert logic - always do a CI split then load the records into empty CI. Yes, I'm using REPRO. I don't think that IDCAMS always do the split. -- Radoslaw Skorupka Lodz, Poland -- BRE Bank SA ul. Senatorska 18 00-950 Warszawa www.brebank.pl Sąd Rejonowy dla m. st. Warszawy XII Wydział Gospodarczy Krajowego Rejestru Sądowego, nr rejestru przedsiębiorców KRS 0000025237 NIP: 526-021-50-88 Według stanu na dzień 01.01.2007 r. kapitał zakładowy BRE Banku SA (w całości opłacony) wynosi 118.064.140 zł. W związku z realizacją warunkowego podwyższenia kapitału zakładowego, na podstawie uchwał XVI WZ z dnia 21.05.2003 r., kapitał zakładowy BRE Banku SA może ulec podwyższeniu do kwoty 118.760.528 zł. Akcje w podwyższonym kapitale zakładowym będą w całości opłacone. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
