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

Author Message
dates

New User

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

 Posted: Wed Jul 22, 2009 3:47 pm    Post subject: What would be the Record size of AIX file 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?

expat

Global Moderator

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

Posted: Wed Jul 22, 2009 3:57 pm    Post subject:

 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.
Robert Sample

Global Moderator

Joined: 06 Jun 2008
Posts: 8231
Location: Dubuque, Iowa, USA

 Posted: Wed Jul 22, 2009 5:01 pm    Post subject: 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.
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics write multiple lines in PS file in cobol Balu5491 COBOL Programming 7 Wed Mar 07, 2018 10:27 am ACESSING THE FILE NAME FROM ANOTEHR E... anilkumar922 All Other Mainframe Topics 2 Fri Mar 02, 2018 4:00 pm How to build one file from two input ... daniele DFSORT/ICETOOL 5 Tue Feb 27, 2018 6:45 pm java.io.FileNotFoundException - passi... Virendra Shambharkar Java & MQSeries 5 Mon Feb 26, 2018 11:41 am Find a string in PS file opened in br... mukkas CLIST & REXX 3 Sat Feb 24, 2018 2:15 pm

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