Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Length of the AIX Record.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Benasir

New User


Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

PostPosted: Thu May 08, 2008 7:46 am    Post subject: To find out the length of Alternative Index(AIX)
Reply with quote

What is the formula to find out the length of Alternative Index(AIX) ?
Back to top
View user's profile Send private message

dick scherrer

Site Director


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

PostPosted: Thu May 08, 2008 8:21 am    Post subject:
Reply with quote

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
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Thu May 08, 2008 9:32 am    Post subject:
Reply with quote

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
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Thu May 08, 2008 10:04 am    Post subject:
Reply with quote

sorry, i mistaken it to be a VSAM question.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Thu May 08, 2008 10:59 am    Post subject:
Reply with quote

Hi Gautam,

Quote:
sorry, i mistaken it to be a VSAM question.
Not to worry - it possibly is a vsam question icon_smile.gif
Back to top
View user's profile Send private message
Benasir

New User


Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

PostPosted: Tue May 13, 2008 6:25 pm    Post subject: Length of the AIX Record.
Reply with quote

Primary Key = 10, Record length = 100, Alternate key = 8, 5 duplicates allowed then what is the length of AIX record??
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue May 13, 2008 6:56 pm    Post subject:
Reply with quote

Length of alt key * number of possibilities perhaps ?
Back to top
View user's profile Send private message
CICS Guy

Senior Member


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

PostPosted: Tue May 13, 2008 7:06 pm    Post subject: Re: Length of the AIX Record.
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10310
Location: italy

PostPosted: Tue May 13, 2008 7:42 pm    Post subject: Reply to: Length of the AIX Record.
Reply with quote

just print the aix and Your curiosity will be satisfied
Back to top
View user's profile Send private message
Benasir

New User


Joined: 25 Apr 2008
Posts: 3
Location: Coimbatore

PostPosted: Tue May 13, 2008 7:49 pm    Post subject: Length of the AIX Record.
Reply with quote

Hi everyone,
Thanks a lot for sharing the details about AIX.
Back to top
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Wed May 14, 2008 7:06 am    Post subject:
Reply with quote

how many times will you ask this question?
your question was already answered when you asked in the DB2 forum.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Selecting two copybooks of different ... Vignesh Sid COBOL Programming 8 Tue Sep 05, 2017 7:28 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts Read two inputs and write into output... murali.andaluri DFSORT/ICETOOL 6 Wed Jul 26, 2017 7:35 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us