View previous topic :: View next topic |
Author |
Message |
shreyas_e Beginner
Joined: 06 Nov 2017 Posts: 10 Topics: 4
|
Posted: Mon Jul 23, 2018 11:33 am Post subject: RECORDSIZE of ALTERNATEINDEX |
|
|
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 |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
kolusu Site Admin
![Site Admin Site Admin](images/ranks/adminpic.jpg)
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
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
www.linkedin.com/in/kolusu |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
RSample Beginner
Joined: 03 Jun 2015 Posts: 1 Topics: 0
|
Posted: Mon Jul 23, 2018 4:39 pm Post subject: |
|
|
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. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|