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
 

 

How to solve SB37, SD37

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
pbgunasekar

New User


Joined: 28 May 2005
Posts: 26
Location: Chennai

PostPosted: Mon May 30, 2005 1:16 pm    Post subject: How to solve SB37, SD37
Reply with quote

hello ,

Please help me to know to solve SB37, SD37
Back to top
View user's profile Send private message

radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Mon May 30, 2005 1:50 pm    Post subject:
Reply with quote

SB37 is space abend, end of volume cond. Increase the work space of the dataset and restart it from the aborted step. I think SD37 should be similar to sb37. can you let me know what does the error message reads for sd37?
Back to top
View user's profile Send private message
shinjini_t

New User


Joined: 11 May 2005
Posts: 14
Location: Bangalore, India

PostPosted: Mon May 30, 2005 2:37 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

SD37, SB37, SE37 abends:

All indicate dataset out of space.
SD37 - no secondary allocation was specified.
SB37 - end of vol. and no further volumes specified.
SE37 - Max. of 16 extents already allocated.

So to solve SD37, one must specify secondary quantity while allocating a dataset.
Back to top
View user's profile Send private message
kanak

Moderator


Joined: 12 Mar 2005
Posts: 252
Location: India

PostPosted: Mon May 30, 2005 3:27 pm    Post subject:
Reply with quote

I agree with all the replied given above.

SYMPTOM: ABEND SD37, SB37 or SE37 ABEND on a Sequential Output File.

CAUSE: The amount of data associated with the ABENDing sequential output file exceeded the capacity of the SPACE sub-parameter of the associated DD statement, or the available space on the Volume on which the sequential output file resides has been exhausted.

SOLUTION: Rename the Problem file to another dataset name ("DSN"). Create a new dataset with the desired target DSN and a more generous SPACE capacity.

Hope this information might help you.
Back to top
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Mon May 30, 2005 4:14 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

Hi,

Other way is to use the EXPAND utility to increase the primary/Secondary Space.
Back to top
View user's profile Send private message
kkumarv

New User


Joined: 13 May 2005
Posts: 20
Location: Bangalore/India

PostPosted: Mon May 30, 2005 5:51 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

SB37 you can avoid also by compressing the data by giving DATCLAS=COMPRESS

Whereas also you can declare the dataset as tapefile, if its very big another alternative is to create GDG where in generation you can give size of cylinder such as(100,100) ..Primary,seconday allocation..
this you can not give in plain PS dataset as limit to user is max specific to system such 43 cylinders , you can give max only (8,3).

So best is go for tape or try compress the data
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Tue May 31, 2005 12:38 am    Post subject:
Reply with quote

Hi Sudheer,

Could you provide a link to further info on EXPAND? It sounds very interesting.

Thanx and
Back to top
View user's profile Send private message
samchris

New User


Joined: 31 May 2005
Posts: 26
Location: pune

PostPosted: Tue May 31, 2005 6:16 pm    Post subject:
Reply with quote

sb37 problem occur due to secondary space problem.better create new dataset.
se37:problem occur due to compress problem.first compress the data set.
Back to top
View user's profile Send private message
sree_2503

New User


Joined: 22 May 2005
Posts: 12
Location: Chennai,India

PostPosted: Tue May 31, 2005 7:43 pm    Post subject:
Reply with quote

Hi Sudheer,

Like MMwife asked, please share more info on EXPAND.....I am not aware much of this util :-(

TIA.....
Back to top
View user's profile Send private message
pbgunasekar

New User


Joined: 28 May 2005
Posts: 26
Location: Chennai

PostPosted: Wed Jun 01, 2005 9:50 am    Post subject:
Reply with quote

plese give info about EXPAND utility...At first how can u choose Primary allocation and sec allocation space for the dataset...



sree_2503 wrote:
Hi Sudheer,

Like MMwife asked, please share more info on EXPAND.....I am not aware much of this util :-(

TIA.....
Back to top
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Wed Jun 01, 2005 10:40 am    Post subject: Re: how to solve sb37,sd37
Reply with quote

Hi Guna,

We have EXPAND toll which take Dataset name as input it shows the present trks/blks/cyl of the dataset and ask to enter the new space requirement if present some blks we can increase it to cyl and so on.

I will get a snapshot of that Screen.
Back to top
View user's profile Send private message
vidyasaraswathi

New User


Joined: 10 May 2005
Posts: 72

PostPosted: Wed Jun 01, 2005 10:49 am    Post subject: Re: how to solve sb37,sd37
Reply with quote

Hi Sudheer,
Whether EXPAND is an IBM utility? Please explain where can we use it?

Thanks and Regards,
Vidya Bhat
Back to top
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Wed Jun 01, 2005 12:54 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

Hi,

This is snapshot of Expand Utility at our Shop.We use it to increase the size from Trks to CYL something like that.

I will try if there any tutorial for the same if have it i would send it.
Back to top
View user's profile Send private message
sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Wed Jun 01, 2005 2:49 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

Hi,

Attached is Snapshot of all Screens of Expand Utility.
Back to top
View user's profile Send private message
die7nadal

Active User


Joined: 23 Mar 2005
Posts: 156

PostPosted: Wed Jun 01, 2005 8:54 pm    Post subject: Re: how to solve sb37,sd37
Reply with quote

pbgunasekar wrote:
hello ,

Please help me to know to solve sb37,sd37


There may be 2 reasons for a space abend
1) The primary and secondary quantity allocated may not be sufficient to write the data - In these cases simply increasing the primary and sec cylinders and Tracks would do the trick
2) The System may not be able to allocate the space requested by you , usually it checks for 5 volumes for the space and if it is not availabe it abends - In these cases increase the no. of volumes to be searched using VOL=(,,,99). If it is with in 100 volumes, it searches for the nearest multiple of 15 and adds 5 . So in this case 105+5=110 volumes. Similarly it follows different algorithms for <20, >100 volumes I guess.
Back to top
View user's profile Send private message
Ricardo Moreira

New User


Joined: 20 Apr 2007
Posts: 15
Location: Brasil

PostPosted: Tue Aug 07, 2007 6:53 pm    Post subject: Looping
Reply with quote

Have you ever tried see if your program isn't in looping? icon_idea.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Aug 07, 2007 7:28 pm    Post subject:
Reply with quote

Hello Ricardo and welcome to the forums icon_smile.gif

When replying to an existing topic, it is a good idea to verify that the topic is still active. This topic last had a reply over 2 years ago and the original participants have moved on to other things.

Enjoy your time in the forums and we'll look forward to "seeing" you.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2: How to solve -805 DB2 Sql code trushant.w Mainframe Interview Questions 3 Fri Oct 04, 2013 3:47 pm
No new posts ABEND=SB37 U0000 REASON=00000004 shiitiizz JCL & VSAM 8 Mon Sep 16, 2013 7:26 pm
No new posts sb37 while extracting data maverick05 DB2 12 Tue Jun 05, 2012 11:54 pm
No new posts Need information on SB37 Space issue ... sivasaras JCL & VSAM 3 Mon Jan 16, 2012 7:20 pm
No new posts how to solve -904 in cobol db2 program. Escapa DB2 3 Tue Jul 19, 2011 5:34 pm


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