What is a VSAM split?
Answers were Sorted based on User's Feedback
Answer / guest
If there isn't enough space in the control interval VSAM
performs a control interval split by moving some records to
the free control intervals. If there isn't a free control
interval VSAM performs a control area split by allocating a
new control area and moving half of the control intervals to it.
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / krishna
When there isn't enough space in the control interval VSAM performs a control interval split by moving some records to the free control intervals. If there isn't a free control interval, VSAM performs a control area split by allocating a new control area and moving half of the control intervals to it.
There are two types of splits used extensively in VSAM.
CI-SPLIT Movement of some records from an existing CI to another free CI in the same CA because a record add or update cannot be accommodated in the existing one.
A CI split requires a number of I/O operations and this degrades the performance of the VSAM file. The correct amount of the space will need to be allocated for the CI (internal percentage of free space allocation). This will result in two half-empty CI's instead of one full and one empty CI.
CA-SPLIT Movement of the half of the records in an existing CA to a new CA because a record add or update cannot be accommodated in the existing CA. This results in two approximately half-full CA's instead of one full and one empty CA. This is inefficient because it involves a high level of I/O operations.
| Is This Answer Correct ? | 4 Yes | 2 No |
Tell me how many alternate indexes you can have on a dataset?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?
How are records stored in an ESDS, entry sequenced dataset?
what is buffering and how does it apply to vsam files ?
What is speed parameters in define cluster command?
If you wish to use the REWRITE command haw must the VSAM file be opened?
In vsam why we use export-import utility?
explain how do you define a gdg in vsam?
How are different versions of GDG named ?
In vsam at the cluster creation for KSDS FREESPACE parameter is required but for ESDS FREESPACE parameter is not required ?
In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?