CI Splits

Dave · Post by **Dave** » Fri Mar 27, 2009 1:14 pm

Hi,

This is a query on CI splits. For instance, a CI has three records and no free space. The three records be 50,100 & 200. Now we have to insert a new record 150. I understand that for evry insert operation.. exactly half the number of records in the original CI will be moved to a new CI and the new record will be inserted in the original CI. What if the original CI contains odd number of records? Could you please explain.

Cheers,
Dave

Natarajan · Post by **Natarajan** » Fri Mar 27, 2009 3:43 pm

It is not exactly half the number of records... Approximately half of the records from the full CI will moved into free CI's . Once the CI Split has completed, the new record that caused the split to occur can then be inserted into the original CI.

Dave · Post by **Dave** » Fri Mar 27, 2009 3:50 pm

Thanks a lot for your Reply. It would be great if you could explain with an example. Preferably the one i stated above.

Cheers.

mainframegurukul.com

CI Splits

CI Splits

CI Split

FREE TUTORIALS