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
 
To solve SB37 with the file of 11 lakh records

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

Active User


Joined: 26 Feb 2007
Posts: 126
Location: Chennai

PostPosted: Mon May 28, 2007 11:42 pm    Post subject: To solve SB37 with the file of 11 lakh records
Reply with quote

While am executing the job with the input file with 1000 records, it was sucessful.

But I now have a file of 1,100,000 records with LRECL=32755.

I am getting the SB37 abend.
I given mulitple volume nearly around 50.
I got the output.

But after few days,now its showing JCL error because of some volume.
I need a solution how to rectify SB37 abend while am using the above data around 1,100,000 records with LRECL=32755
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue May 29, 2007 12:07 am    Post subject:
Reply with quote

What additional information did message IEC030I give?
Back to top
View user's profile Send private message
expat

Global Moderator


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

PostPosted: Tue May 29, 2007 1:58 am    Post subject:
Reply with quote

And with an LRECL of 32755, unless you are using spanned blocks, will put ONE record on each track of DASD.

1,100,000 / 15 = 73,334 cylinders = 22 x 3390-3

May I suggest that perhaps you use tape for this one.
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 May 29, 2007 2:17 am    Post subject:
Reply with quote

Hello,

Look at your process and see how many of the 32k bytes need to be written. Very few processes need records that long. If you do a coding and select only the data needed to meet your requirement, you may be able to eliminate most of the space needed.

As much of the 32k is likely not used in all of the records, you might be able to change your output to variable length and save some space (if the records are 32k fixed as input.

If you cannot or will not reduce the dasd volume, you can use tape as was suggested before. You will most likely need to specify the volume count as the number of volumes will probably exceed the site limit.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1105
Location: The Netherlands at Hole 19

PostPosted: Tue May 29, 2007 3:21 pm    Post subject:
Reply with quote

I wonder what kind of medium you use for the inputfile.

Is there a way you can process the file in pieces and accumelate records?
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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm

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