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
 

 

VSAM ALTERNATE INDEX ISSUE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: VSAM ALTERNATE INDEX ISSUE
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7306

PostPosted: Wed Jan 15, 2014 3:19 pm    Post subject: Reply to: VSAM ALTERNATE INDEX ISSUE
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Wed Jan 15, 2014 7:23 pm    Post subject: Reply to: VSAM ALTERNATE INDEX ISSUE
Reply with quote

I strongly suggest to read

http://www.redbooks.ibm.com/redbooks/pdfs/sg246105.pdf
Back to top
View user's profile Send private message
Pete Wilson

Active User


Joined: 31 Dec 2009
Posts: 440
Location: London

PostPosted: Tue Feb 18, 2014 9:07 pm    Post subject:
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    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 Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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