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
 

 

Can we have any alternative for alternet index 32K limit ?

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

New User


Joined: 12 Dec 2006
Posts: 14
Location: pune

PostPosted: Wed Dec 26, 2012 5:36 pm    Post subject: Can we have any alternative for alternet index 32K limit ?
Reply with quote

Hi,

VSAM file has defined with the primary key as CUST-ID and alterant key as CUST-NAME and CUST-CDE.

Now My program A would require all the records from program B by reading vsam file matching to CUST-NAME and CUST-CDE(these values are passed by program A) and send back all the matching row. Right now my program is working fine but when I have seen AIX file, it already have LRECL as 30K and it soon cross 32K limit for the duplicates. (As per my knowledge, there is limit for the duplicates corresponding to alternate key i.e. 32K).

Can someone please help me to overcome this 32K limit or suggest alternative to alternate indexes?

kindly note that,
- We already suggested to have maint. job to remove the old records in order to avoid the limit but client refuses.

Thanks,
Snehal
Back to top
View user's profile Send private message

Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 961
Location: Richmond, Virginia

PostPosted: Wed Dec 26, 2012 6:11 pm    Post subject:
Reply with quote

I am confused.

How does the number of records in the index affect the record length?

I think you do not understand the terms that you are using.
Back to top
View user's profile Send private message
snehal

New User


Joined: 12 Dec 2006
Posts: 14
Location: pune

PostPosted: Wed Dec 26, 2012 6:18 pm    Post subject: Reply to: Can we have any alternative for alternet index 32K
Reply with quote

Thanks Phil for the reply...

As per my understanding data in AIX will be store as -
Alternet Key and then all the duplicates associated with the alternet key in a single record

Since alternate key is of length 20 bytes and because of 32K limit we can have maximum 1630 duplicate records(32K/20) associated with the alternate key.

So once my VSAM file has more than 1630 records associated with alternate key then all the LRECL will be exausted and there would be no space in alternate index VSAM file to write additional duplicates records associated with the alternate key.

so it does not affect index component however it sure affects the data components.
Back to top
View user's profile Send private message
Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 961
Location: Richmond, Virginia

PostPosted: Wed Dec 26, 2012 6:25 pm    Post subject:
Reply with quote

Thanks for the explanation.

I haven't used VSAM in years, so we'll have to wait for someone else to chime in.

1630 does sound like a measly number to cause a problem, though.

I googled "vsam aix duplicates" and found: http://ibmmainframes.com/about46217.html

Does it help?
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Wed Dec 26, 2012 7:58 pm    Post subject: Re: Reply to: Can we have any alternative for alternet index
Reply with quote

snehal wrote:
As per my understanding data in AIX will be store as -
Alternet Key and then all the duplicates associated with the alternet key in a single record

Since alternate key is of length 20 bytes and because of 32K limit we can have maximum 1630 duplicate records(32K/20) associated with the alternate key.

So once my VSAM file has more than 1630 records associated with alternate key then all the LRECL will be exausted and there would be no space in alternate index VSAM file to write additional duplicates records associated with the alternate key.

so it does not affect index component however it sure affects the data components.

I believe that your "understanding" is incorrect; see Mr. Sample's explanations in this thread.
Back to top
View user's profile Send private message
snehal

New User


Joined: 12 Dec 2006
Posts: 14
Location: pune

PostPosted: Thu Dec 27, 2012 6:02 pm    Post subject: Reply to: Can we have any alternative for alternet index 32K
Reply with quote

Akatsukami, thanks a lot for pointing to the sample's thread...it's resolved now... Yes as per his thread we can create AIX greater than 32K LRECL but each alternate key at max has maximum 32767 duplicates allowed in base file.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Dec 27, 2012 6:27 pm    Post subject: Reply to: Can we have any alternative for alternet index 32K
Reply with quote

Quote:
Yes as per his thread we can create AIX greater than 32K LRECL but each alternate key at max has maximum 32767 duplicates allowed in base file.


and ???

pretty difficult to understand what You are trying to tell
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm
No new posts Drop building Alternate Index for a p... bhavin.mehta JCL & VSAM 6 Mon Jul 04, 2016 3:47 pm
No new posts VSAM Alternate Index in CICS jacobdng CICS 2 Fri May 06, 2016 1:41 pm
No new posts Rebuilding IMS secondary index withou... Hooman24 IMS DB/DC 6 Tue Mar 29, 2016 12:22 pm


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