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: 8593
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: 10310
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 Selecting two copybooks of different ... Vignesh Sid COBOL Programming 8 Tue Sep 05, 2017 7:28 pm Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm

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