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: 7315

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: 10327
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: 445
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 SIGNAL ON HALT issue packerm CLIST & REXX 0 Fri Oct 20, 2017 6:56 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am

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