View previous topic :: View next topic
|
Author |
Message |
Mathiv Anan
Active User
Joined: 23 Jul 2008 Posts: 106 Location: USA
|
|
|
|
Hi,
I am trying to build the alternate index for a VSAM. but getting the below error.
IDC1646I 387 EXCESS PRIME KEY VALUES FOR AIX KEY 40404040404040404040
key is nonunique but i could not figure out the exact reason.
can you please help on this. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Did you look up the error?
Quote: |
IDC1646I nnnnn EXCESS PRIME {KEY|RBL} VALUES FOR AIX KEY key
Explanation: The specified key is the key of an alternate index record that was too short to contain all the prime key or relative block address (RBA) pointer values that occurred for that alternate index key.
Application Programmer Response: Delete the alternate index and redefine it using the access method services commands with a maximum record size long enough to contain the maximum number of pointers for any one alternate key. Then rebuild the alternate index using the BLDINDEX command. |
|
|
Back to top |
|
|
Mathiv Anan
Active User
Joined: 23 Jul 2008 Posts: 106 Location: USA
|
|
|
|
This has been resolved after increasing the RECSZ range based on expected duplicate alternate keys.
Thank you |
|
Back to top |
|
|
|