| Author |
Message |
Benasir
New User
Joined: 25 Apr 2008
Posts: 1
Location: Coimbatore
|
|
|
|
| What is the formula to find out the length of Alternative Index(AIX) ? |
|
| Back to top |
|
 |
References
|
 Posted: Thu May 08, 2008 7:46 am Post subject: Re: To find out the length of Alternative Index(AIX) |
|
|
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 5923
Location: 221 B Baker St
|
|
|
|
Hello Benasir and welcome to the forums,
If i understand your question, there is no calculation - the length is determined by the size of the column(s) that make up the alternate index. |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 94
Location: Bangalore
|
|
|
|
the size of the alternate index for KSDS is calculated as :
| Code: |
for unique key : 5 + alternate key length + primary key length
for non-unique key : 5 + alternate key length + (n * primary key length)
|
the size of the alternate index for ESDS is calculated as :
| Code: |
for unique key : 5 + alternate key length + RBA Size
for non-unique key : 5 + alternate key length + (n * RBA Size)
|
here, n is the maximum number of duplicates allowed in the alternate index. |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 94
Location: Bangalore
|
|
|
|
| sorry, i mistaken it to be a VSAM question. |
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 5923
Location: 221 B Baker St
|
|
|
|
Hi Gautam,
| Quote: |
| sorry, i mistaken it to be a VSAM question. |
Not to worry - it possibly is a vsam question  |
|
| Back to top |
|
|
|
|
