Answer Posted / sagar kajale
aix is used to access records of vsam ksds in order other than ksds files primary key or we can say base key. the ds over which aix exists is called a base cluster.
aix are ksds and has their own data and index component.
advantages:
can be updated automatically.
reduces data redundancy.
can be defined for both ksds and esds.
can have duplicates.
Disadvantages:
complex update logic.
performance degradation.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the main function of linear dataset?
What is the main function of key sequenced data set in vsam?
Explain the catalog?
What is the purpose of control intervals in vsam?
How do you define an altindx?
differentiate between sequential files and esds files in vsam?
how can you load a vsam data set with records ?
What are the access method services used in vsam?
What is the main purpose of having user catalog 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.
OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output
On which dataset you can have alt index?
What is the use of lds (linear data set)?
how many buffers are allocated to vsam ksds and esds?
name a few common vsam status codes?