Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
Benasir

New User

Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

 Posted: Thu May 08, 2008 7:46 am    Post subject: To find out the length of Alternative Index(AIX) What is the formula to find out the length of Alternative Index(AIX) ?

dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

 Posted: Thu May 08, 2008 8:21 am    Post subject: 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.
the_gautam

Active User

Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

Posted: Thu May 08, 2008 9:32 am    Post subject:

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.
the_gautam

Active User

Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

 Posted: Thu May 08, 2008 10:04 am    Post subject: sorry, i mistaken it to be a VSAM question.
dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

Posted: Thu May 08, 2008 10:59 am    Post subject:

Hi Gautam,

 Quote: sorry, i mistaken it to be a VSAM question.
Not to worry - it possibly is a vsam question
Benasir

New User

Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

 Posted: Tue May 13, 2008 6:25 pm    Post subject: Length of the AIX Record. Primary Key = 10, Record length = 100, Alternate key = 8, 5 duplicates allowed then what is the length of AIX record??
expat

Global Moderator

Joined: 14 Mar 2007
Posts: 8652
Location: Back in jolly old England

 Posted: Tue May 13, 2008 6:56 pm    Post subject: Length of alt key * number of possibilities perhaps ?
CICS Guy

Senior Member

Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

Posted: Tue May 13, 2008 7:06 pm    Post subject: Re: Length of the AIX Record.

 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?
enrico-sorichetti

Global Moderator

Joined: 14 Mar 2007
Posts: 10439
Location: italy

 Posted: Tue May 13, 2008 7:42 pm    Post subject: Reply to: Length of the AIX Record. just print the aix and Your curiosity will be satisfied
Benasir

New User

Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

 Posted: Tue May 13, 2008 7:49 pm    Post subject: Length of the AIX Record. Hi everyone, Thanks a lot for sharing the details about AIX.
the_gautam

Active User

Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

 Posted: Wed May 14, 2008 7:06 am    Post subject: how many times will you ask this question? your question was already answered when you asked in the DB2 forum.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Copying only first and last word from... chandan.inst SYNCSORT 4 Wed Jan 31, 2018 4:19 pm How to select record x+7 or x+2 based... JoAnn Kulcyk SYNCSORT 6 Tue Jan 16, 2018 10:49 pm query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm Extract Record using range of Data scorp_rahul23 DFSORT/ICETOOL 3 Wed Nov 15, 2017 11:54 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us