Answer / guest

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

Answer / mr. cooooool

Sorry I mistaken.
I given wrong answer.

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.

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.

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.

What is an RBA in rrds? What does it do? What is it used for?

5 Answers   CTS,

why ci and ca splits are not possible in esds and rrds?

0 Answers   IBM,

Syntax of AMS modal commands ?

1 Answers   IBM,

How many cluster index can have in a table?

3 Answers   HSBC,

what is the meaning of dynamic processing in vsam?

0 Answers   IBM,

Explain the process in which flat files are converted into vsam files?

0 Answers  

what are the different types of vsam files available? Explain them

1 Answers   IBM,

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

1 Answers  

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

0 Answers  

can we access sequential files online

4 Answers   Cap Gemini, GS,

Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ?

3 Answers  

In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?

4 Answers