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 |
how to see the last records in vsam dataset??
What is the base cluster?
On which dataset you can have alt index?
Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.?
What's a LDS (Linear Data Set) and what's it used for?
How do you initialize a VSAM file before any operation? a VSAM with alternate index?
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,
what is the difference b/w sequential and ESDS
max how many AIX coded in a vsam dataset??
What is the maximum no. of records that can be allowed in VSAM ?
Why is it required to have a keyed directed retrieval?
How do you fix the problem associated with VSAM out of space condition?