MVSFORUMS.com

shreyas_e · Beginner Joined: 06 Nov 2017 Posts: 10 Topics: 4

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 · Posted: Mon Jul 23, 2018 11:59 am Post subject:

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 - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

www.linkedin.com/in/kolusu

RSample · Beginner Joined: 03 Jun 2015 Posts: 1 Topics: 0

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.