View previous topic :: View next topic
|
Author |
Message |
Manicka Yazhini T
New User
Joined: 01 Jun 2011 Posts: 7 Location: INDIA
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
Manicka Yazhini T
New User
Joined: 01 Jun 2011 Posts: 7 Location: INDIA
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
yes |
|
Back to top |
|
|
Manicka Yazhini T
New User
Joined: 01 Jun 2011 Posts: 7 Location: INDIA
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
Good,
but you could have tested first to see if it could be done. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
Record size for the alternate index definition can be anything up to the limit (n in the formula cannot exceed 32767). |
|
Back to top |
|
|
|