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.
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. It has been a long time since I tested the combinations and permutations of REPRO versus a program writing new records and they may have changed things. Wondering if bulk insert now does CA splits not CI? I would have to read the redbook VSAM demystified again to give more accurate answers. Mike On Dec 3, 2007 9:16 AM, R.S. <[EMAIL PROTECTED]> wrote: > Larry Crilley wrote: > > I've seen when an INDEX CI gets full (can not put any more compressed > keys > > into the INDEX), a CA SPLIT can occur. Since the sequence set can not > hold > > the new key, the CA must be split. > > > > Try loading your dataset and run an IDCAMS EXAMINE. EXAMINE has been > > updated in the past few years to give you a recommended INDEX CI size. > It > > will also tell you if you have any 'unreachable' data CI's. > > I ran EXAMINE INDEXTEST DATATEST. No clue about unreachable CIs. The key > should be well compressed - the values are: 00000001, 00000011, 00000021, > etc. I also tried to increase CI size. Started from default 1.5k, ended at > 18k. Still having the same number of CA splits. What's funny the higher CA > free space the more CA splits. > > > -- > 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 > -- Mike
