what is the concept of AIX in vsam ????
Answer / 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 |
How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique.
how many buffers are allocated to vsam ksds and esds?
What is the main purpose of having user catalog in vsam?
Would you specify FREESPACE for an ESDS?
What is IDCAMS ?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
What does the keyranges parameter in define cluster commends do?
Is it slower if you access a record through alt index as compared to primary index?
What is the difference between sequential files and ESDS files?
what is a Base Cluster?
is it required that primary key values have to be unique? Do alternate key values have to be unique?
How to createing new version of GDG with out loosing the data in preaves GDG version?