mainframegurukul.com

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

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.

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

Cheers.