|
|
| Author |
Message |
Benasir
New User
Joined: 25 Apr 2008
Posts: 3
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: 7342
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: 169
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: 169
Location: Bangalore
|
|
|
|
| sorry, i mistaken it to be a VSAM question. |
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 7342
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 |
|
|
| Moved: Wed May 14, 2008 5:36 pm by William Thompson From DB2 to SMS & VSAM |
Benasir
New User
Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore
|
|
|
|
| Primary Key = 10, Record length = 100, Alternate key = 8, 5 duplicates allowed then what is the length of AIX record?? |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 2817
Location: Brussels once more ...
|
|
|
|
| Length of alt key * number of possibilities perhaps ? |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 1117
Location: At my desk
|
|
|
|
| Benasir wrote: |
| Primary Key = 10, Record length = 100, Alternate key = 8, 5 duplicates allowed then what is the length of AIX record?? |
Why would you care?
8+(10*5)?
From 18 to 58? |
|
| Back to top |
|
|
enrico-sorichetti
Global Moderator
Joined: 14 Mar 2007
Posts: 2538
Location: italy
|
|
|
|
| just print the aix and Your curiosity will be satisfied |
|
| Back to top |
|
|
Benasir
New User
Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore
|
|
|
|
Hi everyone,
Thanks a lot for sharing the details about AIX. |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 169
Location: Bangalore
|
|
|
|
how many times will you ask this question?
your question was already answered when you asked in the DB2 forum. |
|
| Back to top |
|
|
|
|
