Radoslaw, Have you tried loading the data in reverse key order? (10, 9, 8, 7, etc) Chuck
-----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of R.S. Sent: Monday, December 03, 2007 11:03 AM To: IBM-MAIN@BAMA.UA.EDU 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 ---------------------------------------------------------------------- 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
