what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?

Answers were Sorted based on User's Feedback



what is the use of aix in vsam why do we go for aix and wht is build index in vsam?..

Answer / guest

aix is the secondary key for searching the records in the
cluster.aix must be duplicate r unique..

Is This Answer Correct ?    17 Yes 0 No

what is the use of aix in vsam why do we go for aix and wht is build index in vsam?..

Answer / mr. cooooool

Sorry I mistaken.
I given wrong answer.

Is This Answer Correct ?    4 Yes 0 No

what is the use of aix in vsam why do we go for aix and wht is build index in vsam?..

Answer / 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

what is the use of aix in vsam why do we go for aix and wht is build index in vsam?..

Answer / sanjana

we use aix to reduce the fields in base table.in further
divided tables will have their own primary key for each
table.in this way we can search the records in the cluster
very easily.

Is This Answer Correct ?    2 Yes 6 No

what is the use of aix in vsam why do we go for aix and wht is build index in vsam?..

Answer / mr. cooooool

Hi...........

we use AIX to extend the limit of Keys.

Suppose i have following records with key(5,0)

00001 Ravindra Uttaranchal
00002 Reena Uttaranchal

And We got new records from Client as following

00001 Manmohan New Delhi
00002 Gaurav New Delhi

So there may be confliction
To resolve this we create AIX on KSDS/ESDS.

Thanks & Regards.

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More VSAM Interview Questions

What are the types of VSAM datasets?

3 Answers   IBM,


What is the biggest disadvantage of using a vsam dataset?

0 Answers  


what do you mean by the repro command?

0 Answers   IBM,


Is CA(Control Area) is part of CI(Control Interval)

1 Answers  


how can you load a vsam data set with records ?

0 Answers   IBM,






What is IDCAMS? and what is the purpose of it?

4 Answers  


What is the maximum record length for the VSAM dataset?

7 Answers   Infosys,


What do you mean by RDW in VSAM?

2 Answers  


Under IDCAMS , multiple functions can be executed, each of which returns a cond code. What will be the condition code returned to the operating system ?

1 Answers   IBM,


What is a lds (linear data set)?

0 Answers  


How do you decide on optimum values for CI, FREESPACE etc...?

1 Answers  


what is a Base Cluster?

3 Answers   HSBC, TCS,


Categories