what is the concept of AIX in vsam ????



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

Post New Answer

More VSAM Interview Questions

How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique.

1 Answers   IBM,


how many buffers are allocated to vsam ksds and esds?

0 Answers   IBM,


What is the main purpose of having user catalog in vsam?

0 Answers  


Would you specify FREESPACE for an ESDS?

1 Answers  


What is IDCAMS ?

2 Answers  






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?

0 Answers  


What does the keyranges parameter in define cluster commends do?

0 Answers  


Is it slower if you access a record through alt index as compared to primary index?

0 Answers  


What is the difference between sequential files and ESDS files?

1 Answers   IBM,


what is a Base Cluster?

3 Answers   HSBC, TCS,


is it required that primary key values have to be unique? Do alternate key values have to be unique?

0 Answers   IBM,


How to createing new version of GDG with out loosing the data in preaves GDG version?

7 Answers   Patni, Satyam,


Categories