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: 8210
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: 8210
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 Where to get sample for processing RM... vice_versa PL/I & Assembler 0 Tue Jan 16, 2018 2:03 pm VSAM dataset not found abdulrafi JCL & VSAM 5 Fri Jan 12, 2018 11:19 am ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

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