Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of aix in vsam why do we go for aix and wht
is build index in vsam?
- 5 Answers
- 12493 Views
- HCL, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What's a LDS (Linear Data Set) and what's it used for?
FREESPACE can be specified for which type of cluster? a.LDS b.RRDS c.ESDS d.KSDS
What is IDCAMS? and what is the purpose of it?
How to declare the EMP Name, EMP No., DOB in VSAM KSDS file? Please explain.....
If we are using empty VSAM file, we can see this empty file by using FILE AID tool. How can we open empty VSAM file if you are using in Program..?
What are all the ways we can create datasets?
What is the base cluster?
What is an alternate index and path ?
can i see how many records does a vsam file have without browsing or without using file-aid? and same for ps file?
How to createing new version of GDG with out loosing the data in preaves GDG version?
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.
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now ?
COBOL 
