IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

VSAM ALTERNATE INDEX ISSUE


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sherlinpraveenkumar

New User


Joined: 14 Jul 2010
Posts: 6
Location: chennai

PostPosted: Wed Jan 15, 2014 2:57 pm
Reply with quote

A build alternate index step fails while executing a JCL due to the following error message and throws RC=04.

Build alternate index steps fails due to QI309 INSUFFICIENT "AIX" RECORD LENGTH - FOLLOWING BASE KEY(S)/RBA(S) DROPPED

Note: This job is daily job and it does not fail regularly.

Follwoing is the DEFINITION of the AIX:
DEFINE AIX (NAME(TTT.XXX.ZZZ.AIXINV)
RELATE(TTT.XXX.ZZZ)
VOLUMES(PRD136)
KEYS(25 55)
RECORDSIZE(900 670000)
CYLINDERS(10 1)
NONUNIQUEKEY
SPEED IMBED)
DATA
(NAME(TTT.XXX.ZZZ.AIXINV.DATA)
FREESPACE(20 20)
CISZ(4096))
INDEX
(NAME(TTT.XXX.ZZZ.AIXINV.INDEX))
DEFINE PATH (NAME(TTT.XXX.ZZZ.PATHINV)
PATHENTRY(TTT.XXX.ZZZ.AIXINV))

I hve gone thru the reference link, but still would like some assistance in understanding and fixing it. Can someone help me?
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7312
Location: Inside the Matrix

PostPosted: Wed Jan 15, 2014 3:19 pm
Reply with quote

You have duplicate alternate index keys. Each existing key is a record with the primary key of each record which matches that key. You now, today, have more duplicates for a particular value (at least one) than previously, and that happens to make your alternate index record too small. Make it bigger. If it is already maximum, then you have thinking to do which should have been done at the design stage. How did this get through testing?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10697
Location: italy

PostPosted: Wed Jan 15, 2014 7:23 pm
Reply with quote

I strongly suggest to read

Use [URL] BBCode for Links
Back to top
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 488
Location: London

PostPosted: Tue Feb 18, 2014 9:07 pm
Reply with quote

It would help if you showed the BASE CLUSTER define statement.

The QI309 message is also unfamiliar, are you using a 3rd party product of basic IDCAMS to do the define?

Not sure how you can have RECORDSIZE(900 670000), i.e. a 670k recordsize!? I think the record size is limited to 32760 bytes. Also the CISIZE is only 4096 bytes and you haven't specified SPANNED so even a 32k record size wouldn't fit.

Suggest you read the IBM manuals 'VSAM Demystified' and 'Using Data Sets' urgently.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts FILE STATUS - 39 ON VARIABLE LENGTH V... COBOL Programming 1
No new posts VSAM Alter Command - Cylinder Extent ... JCL & VSAM 3
No new posts RPLDDDD field for extended VSAM - ESDS JCL & VSAM 0
No new posts DFDSS msg ADR485E when restoring VSAM... JCL & VSAM 5
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9

Back to Top