Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7314

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

Senior Member


Joined: 14 Mar 2007
Posts: 10603
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: 470
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 DO we have alternate syntax for IFTHEN? useit Compuware & Other Tools 8 Wed May 29, 2019 3:50 pm
No new posts GTT issue - help ! jzhardy DB2 7 Sat Mar 23, 2019 4:17 am
No new posts Tivoli job scheduler issue John Poulakos IBM Tools 12 Sat Mar 23, 2019 12:32 am
No new posts VSAM Spacce allocated and used -->... upendrasri CLIST & REXX 18 Sat Mar 09, 2019 3:54 pm
No new posts How to delete a VSAM dataset from ins... Mike.Fulton JCL & VSAM 6 Fri Feb 15, 2019 5:58 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us