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 Sad Rejonowy dla m. st. Warszawy XII Wydzial Gospodarczy Krajowego Rejestru Sadowego, nr rejestru przedsiebiorców KRS 0000025237 NIP: 526-021-50-88 Wedlug stanu na dzien 01.01.2007 r. kapital zakladowy BRE Banku SA (w calosci oplacony) wynosi 118.064.140 zl. W zwiazku z realizacja warunkowego podwyzszenia kapitalu zakladowego, na podstawie uchwal XVI WZ z dnia 21.05.2003 r., kapital zakladowy BRE Banku SA moze ulec podwyzszeniu do kwoty 118.760.528 zl. Akcje w podwyzszonym kapitale zakladowym beda w calosci oplacone. ---------------------------------------------------------------------- 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
