Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
ShwetaG

New User

Joined: 26 May 2010
Posts: 5
Location: Pune

 Posted: Fri Feb 18, 2011 1:32 pm    Post subject: VSAM - calculate the RECSZ for alt index Hello..Can you please look and advice. If RECSZ of base cluster for KSDS is changed. How will it impact the RECSZ of the alternate index for the same base ksds cluster. If in case it impacts the alternate index RECSZ then how will we calculate the RECSZ for alt index. For examplet: RECSZ(259,259) for KSDS cluster changed to RECSZ(268,268) . currently Alter index record length is RECSZ(259,130400).How should we change this record length corresponds to above base cluster record length. Thanks. ShwetaG.

expat

Global Moderator

Joined: 14 Mar 2007
Posts: 8681
Location: Back in jolly old England

 Posted: Fri Feb 18, 2011 1:45 pm    Post subject: What happened when you tried it out with no changes. Have you read the IDCAMS manual to see how to calculate the RECSZ for an AIX These are things that you SHOULD have done before posting.
Robert Sample

Global Moderator

Joined: 06 Jun 2008
Posts: 8339
Location: Dubuque, Iowa, USA

 Posted: Fri Feb 18, 2011 3:46 pm    Post subject: You DO realize, I hope, that the record size for an alternate index has absolutely no relationship to the base cluster record size? If you read the manual (Access Method Services for Catalogs, accessible from the manuals link at the top of the page) about DEFINE ALTERNATEINDEX you will learn much and be able to answer your own questions.
ShwetaG

New User

Joined: 26 May 2010
Posts: 5
Location: Pune

 Posted: Fri Feb 18, 2011 5:43 pm    Post subject: Thanks Expat and Robert for coming back. To calculate the record sixe of the AIX we use the formula: RECSZ = 5 + AIXKL + (n x BCKL) where where: - RECSZ is the average record size. - AIXKL is the alternate-key length (see the KEYS parameter). - BCKL is the base cluster's prime-key length (you can issue the access method services LISTCAT command to determine the base cluster's prime-key length). - n = 1 when UNIQUEKEY is specified (RECSZ is also the maximum record size). - n = the number of data records in the base cluster that contain the same alternate-key value, when NONUNIQUEKEY is specified. So in the above formula we dont use the RECORD SIZE OF THE PRIMARY key so that also proofs that we don't need to change the RECSZ of AIX if we are changing RECSZ for base cluster.Only if we are changind the keys lenght then we require RECSZ to be changed for AIX. Thanks again. ShwetaG.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Not able to export the VSAM cluster sandeep kumar302 JCL & VSAM 6 Fri May 04, 2018 12:42 pm Incorrect output after build alternat... sandeep kumar302 JCL & VSAM 10 Wed May 02, 2018 2:35 pm IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 12 Tue Apr 17, 2018 10:42 pm VSAM file NOT Found error while proce... SumaReva CICS 5 Wed Apr 11, 2018 9:54 pm VSAM - Accessing beyond record size Benchwarmer JCL & VSAM 6 Wed Apr 11, 2018 9:20 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us