what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?

Answer Posted / codebulls

At times a vendor might offer a file to be consumed by a mainframe application. Rather than the primary key, the file would contain another field in the VSAM which is unique but not the primary key of VSAM. If such fields are made to be Alternate Index, unnecessary reads and performance overhead can be avoided.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Would you specify freespace ce for an esds?

596


What is the function of linear dataset in vsam?

632


in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?

698


What are the access method services used in vsam?

592


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?

585






Is it slower if you access a record through alt index as compared to primary index?

589


Describe the uses of ams?

538


what do you mean by the repro command?

566


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.

1875


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

706


difference between vsam and database tables

633


what are the idcams commands that can be used for vsam and explain each of them.

547


What is control interval?

608


what is the syntax of ams modal commands?

768


explain how many ways you can load data in a vsam cluster?

574