MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

RECORDSIZE of ALTERNATEINDEX

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
shreyas_e
Beginner


Joined: 06 Nov 2017
Posts: 10
Topics: 4

PostPosted: Mon Jul 23, 2018 11:33 am    Post subject: RECORDSIZE of ALTERNATEINDEX Reply with quote

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
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12354
Topics: 75
Location: San Jose

PostPosted: Mon Jul 23, 2018 11:59 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail Visit poster's website
RSample
Beginner


Joined: 03 Jun 2015
Posts: 1
Topics: 0

PostPosted: Mon Jul 23, 2018 4:39 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group