MVSFORUMS.com

[shreyas_e]

Hi,

The below is from IBM Website. Is there any way we can have the RECORDSIZE of ALTERNATEINDEX more than 32767. I have a requirement where my ALTERNATEINDEX with NONUNIQUE keys exceeds 32767. Please let me know if there is a workaround or any other way to fix this issue.

"When you define an alternate index with many nonunique keys, specify a RECORDSIZE value that is large enough to handle all the nonunique keys. All occurrences of primary keys for a particular alternate key must be within a single alternate index logical record. If the maximum RECORDSIZE value is 1000, for example, you would not be able to support as many nonunique keys as you would if the maximum RECORDSIZE value were 5000. The maximum number of prime keys that a single alternate index logical record can contain is 32767."

Thanks in advance

[kolusu]

shreyas_e,

You cannot have more than 32K as recordsize for an Alternate Index. However the question, is why do you need more than 32K duplicates? It is like having 32,000 "shreyas_e" s to search on.
_________________
Kolusu
www.linkedin.com/in/kolusu

[RSample]

Record size of an alternate index can be more than 32767 bytes but that precludes you from exporting or using REPRO to a non-VSAM data set. There is an absolute limit of 32767 occurrences of one primary key per alternate index key, though.