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. Larry Crilley Dino-Software Corporation 800.480.DINO 412.366.3566 www.dino-software.com Dino-Software Utilities T-REX - Superior catalog management tool inclusive of HSM & Tape audits REORGadon - First REORG While-OPEN tool for HSM Teradon - First ever OnLine REPRO MERGECAT utility Xtinct - DASD Data purge RTD - DASD Real Time Defrag DAL - Analysis for Legato in an easy to view format -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of R.S. Sent: Sunday, December 02, 2007 6:12 PM To: IBM-MAIN@BAMA.UA.EDU Subject: KSDS CA split, no CI split The following scenario: KSDS defined with RECSZ(100 100), FSPC(15 15), CISZ(4096). Records loaded, with evenly distributed key values (i.e. start 1, increment 10). 20000 records. Then I inserted 500 evenly distributed records (start=5, increment=100). Listcat shows no CI splits and 3 CA splits. Q: how it is possible to have CA split without CI split ? BTW: I increased CA freespace to 30% without effect. Increasing CI freespace finally gave me 0 splits at all. -- 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