How many Alternate Indexes you can have on a dataset?
Answers were Sorted based on User's Feedback
Answer / sivakumar devaram
253.but not more than 5 recommended because of overheada in
storing and maintaining alternate indexes.
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / guest
255 - but you must be a nut to have so many ALT Indexes on a
dataset!
| Is This Answer Correct ? | 7 Yes | 6 No |
What is the biggest disadvantage of using a vsam dataset?
Do all versions of the GDG have to be of the same record length ?
What is the index set?
By seeing the file itself how can we identify whether it is A vsam file or flat file
what is meant by dirty read in vsam?
Explain the purpose of the file status clause in the select statement?
Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?
How do you load a VSAM data set with records ?
What is the use of access method services in vsam?
What is the purpose of having vsam data space?
Explain the meaning and syntax for the START command. ?
How Vsam was evolved? What was the equivalent file for ESDS,KSDS and RRDS prior to evolution? What were their disadvantages of those file which leads to evolution of ESDS,KSDS and RRDS files ?