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

Author Message
Manicka Yazhini T

New User

Joined: 01 Jun 2011
Posts: 7
Location: INDIA

 Posted: Wed Jun 01, 2011 2:17 pm    Post subject: AIX VSAM BLDINDEX Hi! I have already looked into the posts regarding this topic. But still am not clear of how can we find the following values in calculating the record size for AIX I need to know how can I find CI, CA and n in the following formula RECORDSIZE = (RECSZ MAXLRECL) where MAXLRECL = CI/CA * (CISZ - 10) RECSZ = 5 + AIXKL + (n*BCKL) Thanks, MY

PeterHolland

Global Moderator

Joined: 27 Oct 2009
Posts: 2446
Location: Netherlands, Amstelveen

 Posted: Wed Jun 01, 2011 2:48 pm    Post subject: http://ibmmainframes.com/about42455.html
Robert Sample

Global Moderator

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

Posted: Wed Jun 01, 2011 3:00 pm    Post subject:

 Quote: RECSZ = 5 + AIXKL + (n*BCKL)
BCKL is Base Cluster Key Length -- the length of your primary key.
AIXKL is the length of the alternate index key.
n is the number of duplicates you can have for a single primary key (1 if duplicates are not allowed)
Manicka Yazhini T

New User

Joined: 01 Jun 2011
Posts: 7
Location: INDIA

 Posted: Wed Jun 01, 2011 3:49 pm    Post subject: Thanks both. So now it looks like n come by either by knowing or by guessing.. Ok. BASE: KEYS (48 0) AIX : KEYS (4 32) and both have CISZ (8192) and CYL (1 1)) I calculated my RECSZ as 5 + 4 + (2000 * 48) = 96009 Can I give RECORDSIZE (96009 96009) in AIX defiinition?
PeterHolland

Global Moderator

Joined: 27 Oct 2009
Posts: 2446
Location: Netherlands, Amstelveen

 Posted: Wed Jun 01, 2011 4:04 pm    Post subject: yes
Manicka Yazhini T

New User

Joined: 01 Jun 2011
Posts: 7
Location: INDIA

 Posted: Wed Jun 01, 2011 4:06 pm    Post subject: Thats Great. In deed it worked in my test job, I just wanted to confirm from you experts so that I can have a reliable info. Thanks Again..!!
PeterHolland

Global Moderator

Joined: 27 Oct 2009
Posts: 2446
Location: Netherlands, Amstelveen

 Posted: Wed Jun 01, 2011 4:16 pm    Post subject: Good, but you could have tested first to see if it could be done.
Robert Sample

Global Moderator

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

 Posted: Wed Jun 01, 2011 4:54 pm    Post subject: Record size for the alternate index definition can be anything up to the limit (n in the formula cannot exceed 32767).
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics IDCAMS RENAMING VSAM FILE ALONG WITH ... upendrasri JCL & VSAM 11 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 VSAM File free space sancraig16 JCL & VSAM 13 Fri Mar 30, 2018 1:02 am VSAM BUFFER SPACE? John Poulakos CICS 17 Thu Mar 22, 2018 2:54 am

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