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
 
Abend B37 Formula Calculate the Primary and Secondary Units

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
barajendran1

New User


Joined: 16 Jun 2010
Posts: 9
Location: Chennai

PostPosted: Sat Sep 25, 2010 10:00 pm    Post subject: Abend B37 Formula Calculate the Primary and Secondary Units
Reply with quote

Anyone help me with the below issue :

My Job is abending with Insufficient Secondary quantity that is U0101 (B37).

It means that due to insufficient space of a particular file.

After analysis of the JCL the symbolic parameter with Primary and Secondary Units to be increased.

But blindly I can't increase the size.

I need to test it whether for a particular size of the file the program should not abend.

There is a formula to check.

Can anyone help me with the formula.
Back to top
View user's profile Send private message

PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Sat Sep 25, 2010 10:17 pm    Post subject:
Reply with quote

Give us more details.

How large is the file ( number approx records and lenght size).
The space you gave.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Sat Sep 25, 2010 10:18 pm    Post subject:
Reply with quote

This topic comes up at least once a month -- did not any of the previous answers on this forum help you?

You must know how many records are in the file before you begin. If you don't know this, your question cannot be answered except as a guess.

For fixed length records, divide the blocksize by the record length to get records per block. Assuming your blocksize is somewhere near half-track blocking on a 3390 (if not, there is a 3390 reference card GX26-4677 you must consult to find the blocks per track for a given blocksize), multiply the records per block by 2. This gives you records per track. Multiply by 15 to get records per cylinder. Divide the total number of records by the records per cylinder to determine the number of cylinders required. If this number is much over 3300, you will need to use more than one 3390 mod 3 for the data set. If the number is over 4369, you cannot allocate it on a single volume unless you use DSNTYPE=LARGE (even assuming you have a volume with that many cylinders available).

For variable length records, the calculation is similar but you must adjust each record length for the 4-byte record descriptor word and each block length for the 4-byte block descriptor word. Also, you would use average record length -- using maximum record length may give you wildly inaccurate values if the average and maximum record lengths are significantly different.

In general, your best and safest way to proceed is to contact your site support group to ensure that the storage is available where you need it -- they are the only ones who know your site well enough.
Back to top
View user's profile Send private message
barajendran1

New User


Joined: 16 Jun 2010
Posts: 9
Location: Chennai

PostPosted: Mon Sep 27, 2010 11:55 am    Post subject: Reply to: Abend B37 Formula Calculate the Primary and Second
Reply with quote

Record Length is 8704

And the approximate records in the file is 5000000 records.

I need to know what primary and secondary units that needs to be given.

Please help me with the formula to calculate the Primary and Secondary Units to be given.
Back to top
View user's profile Send private message
PeD

Active User


Joined: 26 Nov 2005
Posts: 456
Location: Belgium

PostPosted: Mon Sep 27, 2010 12:01 pm    Post subject:
Reply with quote

Please try with info Robert gave you.

Also consider the available physical space on disk and play with
UNIT=(SYSDA,n) wher n can be i.e. 5,6,.... 15.
Back to top
View user's profile Send private message
barajendran1

New User


Joined: 16 Jun 2010
Posts: 9
Location: Chennai

PostPosted: Mon Sep 27, 2010 12:17 pm    Post subject: Reply to: Abend B37 Formula Calculate the Primary and Second
Reply with quote

There is a formula Primary Unit + Secondary Unit * record length + Number of records.

This formula is incorrect.

I need to know the Correct formula for this.

Could you please help me by providing the Formula.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10308
Location: italy

PostPosted: Mon Sep 27, 2010 12:29 pm    Post subject: Reply to: Abend B37 Formula Calculate the Primary and Second
Reply with quote

here is a link to a post containing a blocks per track calculator
http://www.ibmmainframes.com/viewtopic.php?t=35906&postdays=0&postorder=asc&start=0
( go to the second page )
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Sep 27, 2010 1:46 pm    Post subject:
Reply with quote

This guy, Balaji, really, really, does not want to contact his storage management people, does he?
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Wanted to calculate TRK when i have B... Balu5491 JCL & VSAM 9 Wed Jul 19, 2017 5:43 pm
No new posts C03 ABEND sjiraga PL/I & Assembler 1 Thu Jun 01, 2017 4:51 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm

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