|
View previous topic :: View next topic
|
| 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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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: 165
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: 165
Location: Bangalore
|
|
|
|
| sorry, i mistaken it to be a VSAM question. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hi Gautam,
| Quote: |
| sorry, i mistaken it to be a VSAM question. |
Not to worry - it possibly is a vsam question  |
|
| Back to top |
|
|
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: 8797
Location: Welsh Wales
|
|
|
|
| Length of alt key * number of possibilities perhaps ? |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| 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
Superior Member
Joined: 14 Mar 2007
Posts: 10873
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: 165
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 |
|
|
|
|
