How do you calculate record size of an alternate cluster?
Give your values for both unique and nonunique.
Answer / guest
Unique Case: 5 + ( alt-key-length + primary-key )
Non unique Case: 5 + ( alt-key-length + n * primary-key )
where n = number of duplicate records for the alternate key
| Is This Answer Correct ? | 7 Yes | 0 No |
What is the difference between lds and esds?
What is a lds (linear data set)?
What are the types of VSAM datasets?
What are the common vsam error conditions and codes?
difference between vsam and database tables
name the utility program closely associated with vsam?
is there any lock for vsam file so that no one can update the vsam file ?
What is the use of KSDS,LDS,ESDS,RRDS??what is VRRDS?? How are all these useful in realtime scenario??Plz helpme out...Its a recent question in IGATE..
Why is master catalog used in vsam?
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.
is it slower if you access a record through alternative index as compared to primary index?
What are the building blocks used in vsam datasets?