Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What would be the Record size of AIX file

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

New User


Joined: 11 Mar 2008
Posts: 9
Location: LA,USA

PostPosted: Wed Jul 22, 2009 3:47 pm    Post subject: What would be the Record size of AIX file
Reply with quote

Hi,


I have a KSDS file of Key length 31 from OFFSET 0 and AIX of key length 10 from OFFSET 13.

So my KSDS primary key lay-out is

01 A-RECORD.
03 A-KEY1.
05 A1 PIC X(1).
05 A2 PIC X(1).
05 A3 PIC X(10).
05 A4 PIC X(1).
05 A-KEY-2.
07 A5 PIC X(7).
07 A6 PIC X(3).
05 A7 PIC 9(8).



I have defined the KSDS file , but encountering problems in defining the AIX. What would be the record Size of AIX?
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: Wed Jul 22, 2009 3:57 pm    Post subject:
Reply with quote

What happened to your access to the IDCAMS manual ??? or google perhaps ???

Quote:

RECORDSIZE(average maximum| 4086 32600)
The average and maximum length, in bytes, of an alternate index record.
An alternate index record can span control intervals, so RECORDSIZE can be larger than CONTROLINTERVALSIZE. The formula for the maximum record size of spanned records as calculated by VSAM is:

MAXLRECL = CI/CA * (CISZ - 10)

where:

MAXLRECL is the maximum spanned record size
CI/CA represents the number of control intervals per control area
CA is the number of control areas
CISZ is the quantity control interval size

You can use either of the following formulas to determine the size of the alternate index record:

When the alternate index supports a key-sequenced base cluster, use this formula:

RECSZ = 5 + AIXKL + (n x BCKL)

When the alternate index supports an entry-sequenced base cluster, use this formula:

RECSZ = 5 + AIXKL + (n x 4)

Variables in the formulas represent these values:

RECSZ is the average record size.

AIXKL is the alternate-key length (see the KEYS parameter).

BCKL is the base cluster's prime-key length. (You can enter the LISTCAT command to determine this base cluster's prime-key length).

n = 1 when UNIQUEKEY is specified (RECSZ is also the maximum record size).

n = the number of data records in the base cluster that contain the same alternate-key value, when NONUNIQUEKEY is specified.

When you use NONUNIQUEKEY, give a record size large enough to allow for as many key pointers or RBA pointers as you might need. The record length values apply only to the alternate index's data component.

Restriction: REPRO and EXPORT do not support data sets with record sizes greater than 32760.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Wed Jul 22, 2009 5:01 pm    Post subject:
Reply with quote

When defining an alternate index to a VSAM file, you must know whether or not the alternate index key is unique. If it is unique, the alternate index record size formula as quoted by expat reduces to 5 + primary key length + alternate index key length. If it is not unique, you must determine how many duplicates may occur -- either by knowing or by guessing -- and plug that number into the formula quoted by expat. In all cases, however, the alternate index record size has nothing to do with your base cluster record size.
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. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us