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.

explain in brief why do vsam take more disk space than other utilities?

0 Answers   IBM,

---

How do you load a VSAM data set with records ?

2 Answers  

---

what is reuse parameter ?

3 Answers   Polaris, Xansa,

---

What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??

3 Answers  

---

what do you mean by a upgrade set in vsam?

0 Answers   IBM,

---

---

How many cluster index can have in a table?

3 Answers   HSBC,

---

How is record management performed in vsam?

0 Answers  

---

What is a path?

1 Answers  

---

Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

0 Answers  

---

What is the COBOL RECORD KEY clause?

2 Answers  

---

what do you mean by a shareoptions parameter (shr) in define cluster command?

0 Answers   IBM,

---

Can AMS commands be run from the TSO prompt ?

1 Answers   IBM,

---