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: 2433
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: 8055
Location: East Dubuque, Illinois, USA

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: 2433
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: 2433
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: 8055
Location: East Dubuque, Illinois, USA

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 VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts VSAM RLS=NRI while doing IDCAMS sheersh JCL & VSAM 1 Tue Mar 07, 2017 1:55 pm
No new posts Fail to change physical VSAM filename... jacobdng CICS 7 Fri Jan 20, 2017 12:36 pm


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