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
What does the keyranges parameter in define cluster commends do?
In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?
to use the rewrite command, how should the vsam file be opened?
what do you mean by a vsam split?
what do you mean by recovery and speed parameters in define cluster command?
What is the purpose of control intervals 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.
what is buffering and how does it apply to vsam files ?
can you specify some the distinctive features of a ksds, key sequenced dataset?
What is the use of access method services in vsam?
Explain the purpose of the file status clause in the select statement?
what do you mean by a shareoptions parameter (shr) in define cluster command?
How do you define an altindx?
What is the main function of key-sequenced data set?
explain how do you define a gdg in vsam?