IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Abend B37 Formula Calculate the Primary and Secondary Units


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 459
Location: Belgium

PostPosted: Sat Sep 25, 2010 10:17 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Sep 25, 2010 10:18 pm
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
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: 459
Location: Belgium

PostPosted: Mon Sep 27, 2010 12:01 pm
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
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

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Sep 27, 2010 12:29 pm
Reply with quote

here is a link to a post containing a blocks per track calculator
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: 6966
Location: porcelain throne

PostPosted: Mon Sep 27, 2010 1:46 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Execute secondary panel of sdsf with ... CLIST & REXX 1
No new posts ISAM and abend S03B JCL & VSAM 10
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
No new posts Query on edit primary command CLIST & REXX 5
Search our Forums:

Back to Top