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.

By looking into JCL can we identify the dataset is VSAM (VSAM dataset supposed to be a input dataset).In this scenerio how will we identify the dataset is VSAM ?

5 Answers   Cognizant, EDS, Shridhar,

can we access sequential files online

4 Answers   Cap Gemini, GS,

How do you define a KSDS ?

1 Answers   IBM,

Why is master catalog used in vsam?

0 Answers  

What is a lds (linear data set)?

0 Answers  

what will happen when you try to open an empty vsam file in a cobol program for input?

0 Answers   IBM,

What are the different dataset organizations used in vsam?

0 Answers  

Explain the function of entry-sequenced data set?

0 Answers  

What is a cluster?

2 Answers  

What is the maximum number of Alternate Index ???

4 Answers  

What is recovery parameters in define cluster command?

0 Answers  

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

1 Answers