What is the maximum number of Alternate Index ???
Answers were Sorted based on User's Feedback
Answer / guest
Theoretically, it is 253. But pracically it is not
advisable to build more than 12 alternate indices.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / guest
WE CAN GIVE 255 MAXIMUM ALTERNET INDEX
BUT PRACTICALLY ONLY 5 FOR SYSTEM WELL
PERFORMANCE
| Is This Answer Correct ? | 1 Yes | 0 No |
What are all the ways we can create datasets?
what is vsam catalog ?
I have three fields in a Variable VSAM file X(2) Y(10) occurs X times Z(02) Say for the first record X=2 then the length of the file is 2+(10*3)+2=34 second record, x=4 then 4+(10*4)+2=46 If any time if the field x is updated then the total length changes. Is it feasible? Is it
what is the use of the file status clause in the select statement in vsam?
FREESPACE can be specified for which type of cluster? a.LDS b.RRDS c.ESDS d.KSDS
what are the codes returned by the ams (access method services) command during the execution in vsam?
what will happen if there is no secondary allocation made for datasets?
what is the concept of AIX in vsam ????
if you wish to use the rewrite command how must the vsam file be opened?
What are the advantages of vsam over isam?
Explain the function of the relative record data set?
What are the information stored in ci?