can alternate index use in ESDS since it does not contain
primary index? if yes can you explain?

Answer Posted / shriram supalwar

Alternate index is possible in ESDS but only in
On-line mode using RBA (Relative Byte Address)
- Accessing of records through RBA is faster than
accessing through index field
- It can be dangerous, since RBA can be altered
through control interval/control area split

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a ca split?

600


What is the use of access method services in vsam?

593


Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?

589


Describe the uses of ams?

544


What is the purpose of relative record data set used in vsam?

689






What makes vrrds different from vsam?

709


What is a base cluste?

607


how do you create an alternate index ?

586


explain in brief how are different versions of gdg named?

540


Explain the purpose of the file status clause in the select statement?

524


What is a lds (linear data set) and what is it used for?

524


how many buffers are allocated to vsam ksds and esds?

714


why ci and ca splits are not possible in esds and rrds?

709


Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

1880


How does control intervals and control areas related to each other?

557