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

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


what do you mean by the repro command?

568


Explain the biggest disadvantage of using a vsam dataset?

584


Discuss record management in vsam?

545


Why is master catalog used in vsam?

577






What is recovery parameters in define cluster command?

566


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

554


What is a lds (linear data set)?

556


what do you mean by a upgrade set in vsam?

641


what is the meaning of each of the values in shareopts(2 3)?

581


what is meant by dirty read in vsam?

844


Define base cluster?

571


Using alternate indexes in cics program?

561


What is the main function of key-sequenced data set?

568


Explain the difference between lds and esds?

580