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
