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
 

 

AIX VSAM BLDINDEX

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

New User


Joined: 01 Jun 2011
Posts: 7
Location: INDIA

PostPosted: Wed Jun 01, 2011 2:17 pm    Post subject: AIX VSAM BLDINDEX
Reply with quote

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
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


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

PostPosted: Wed Jun 01, 2011 2:48 pm    Post subject:
Reply with quote

http://ibmmainframes.com/about42455.html
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7930
Location: Bellevue, IA

PostPosted: Wed Jun 01, 2011 3:00 pm    Post subject:
Reply with quote

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)
Back to top
View user's profile Send private message
Manicka Yazhini T

New User


Joined: 01 Jun 2011
Posts: 7
Location: INDIA

PostPosted: Wed Jun 01, 2011 3:49 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Jun 01, 2011 4:04 pm    Post subject:
Reply with quote

yes
Back to top
View user's profile Send private message
Manicka Yazhini T

New User


Joined: 01 Jun 2011
Posts: 7
Location: INDIA

PostPosted: Wed Jun 01, 2011 4:06 pm    Post subject:
Reply with quote

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..!!
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


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

PostPosted: Wed Jun 01, 2011 4:16 pm    Post subject:
Reply with quote

Good,

but you could have tested first to see if it could be done.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7930
Location: Bellevue, IA

PostPosted: Wed Jun 01, 2011 4:54 pm    Post subject:
Reply with quote

Record size for the alternate index definition can be anything up to the limit (n in the formula cannot exceed 32767).
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 how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am
No new posts CICS VSAM RLS READ akodakka CICS 3 Tue Oct 04, 2016 3:09 pm


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