Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

IDC1646I 387 EXCESS PRIME KEY VALUES

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Mathiv Anan

Active User


Joined: 23 Jul 2008
Posts: 106
Location: USA

PostPosted: Thu Feb 12, 2009 6:59 am    Post subject: IDC1646I 387 EXCESS PRIME KEY VALUES
Reply with quote

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

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Feb 12, 2009 7:15 am    Post subject:
Reply with quote

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
View user's profile Send private message
Mathiv Anan

Active User


Joined: 23 Jul 2008
Posts: 106
Location: USA

PostPosted: Thu Feb 12, 2009 10:35 am    Post subject:
Reply with quote

This has been resolved after increasing the RECSZ range based on expected duplicate alternate keys.

Thank you
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm
No new posts Using 'parm' to vary SORTOUT record v... Sysaron DFSORT/ICETOOL 13 Wed Sep 07, 2016 9:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us