View previous topic :: View next topic
|
Author |
Message |
barajendran1
New User
Joined: 16 Jun 2010 Posts: 9 Location: Chennai
|
|
|
|
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 |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Give us more details.
How large is the file ( number approx records and lenght size).
The space you gave. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
barajendran1
New User
Joined: 16 Jun 2010 Posts: 9 Location: Chennai
|
|
|
|
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 |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
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 |
|
|
barajendran1
New User
Joined: 16 Jun 2010 Posts: 9 Location: Chennai
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
This guy, Balaji, really, really, does not want to contact his storage management people, does he? |
|
Back to top |
|
|
|