RS, a) A CA split is still costly, but having extra data buffers normally helps though (BUFND=); a CI split is almost nothing now.
b) Empty CIs are not read by VSAM. Almost empty CIs cost the same for random read as for full CIs. For sequential read almost empty CIs does cost extra. You can always reorg to pack the data better. VSAM can be made much more efficient by appropriate buffering, e.g. System Managed Buffering is pretty good. VSAM splits are a fact of life, and it is an Access Method that is 30+ years old. It could be worse, we could still be stuck with ISAM!! (yes, I did work with it). 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 <[email protected]> 05/12/2007 18:00 Please respond to IBM Mainframe Discussion List <[email protected]> To [email protected] cc Subject Re: KSDS CA split, no CI split Gene Hudders wrote: [...] > I sure would hate to take too many CA splits in an on-line environment > especially if the CA split requires another extent for either the data > and/or index component. That's why I wrote "not so bad". <g> Indeed CA split is painful (CI also, but the pain is CI/CA times less). However the pain is no longer because after the split data is no longer in physical sequence. That (maybe) was painful in times of SLEDs with long seek time. What is painful, it's: a) poor performance *at the split time* - you insert single LR (logical record) and VSAM moves cylinder of data. b) free space distribution. After the splits you could end up with 50% free space. Overhead because of reading almost empty CIs. Did I miss something ? Regards -- Radoslaw Skorupka Lodz, Poland -- BRE Bank SA ul. Senatorska 18 00-950 Warszawa www.brebank.pl Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 0000025237 NIP: 526-021-50-88 Wedug stanu na dzie 01.01.2007 r. kapita zakadowy BRE Banku SA (w caoci opacony) wynosi 118.064.140 z. W zwizku z realizacj warunkowego podwyszenia kapitau zakadowego, na podstawie uchwa XVI WZ z dnia 21.05.2003 r., kapita zakadowy BRE Banku SA moe ulec podwyszeniu do kwoty 118.760.528 z. Akcje w podwyszonym kapitale zakadowym bd w caoci opacone. ---------------------------------------------------------------------- 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
