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
 
SB37 Error While Sorting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
manishram1

New User


Joined: 23 Mar 2006
Posts: 34

PostPosted: Tue Aug 29, 2006 10:49 am    Post subject: SB37 Error While Sorting
Reply with quote

Hi Everyone,
Input:::File with VB,LRECL=2587,BLKSIZE=32760,No:oF Records=3800000
Ouput::File with VB,LRECL=2587,BLKSIZE=32760,No:oF Records=3800000

SortCard used::
RECORD TYPE=V
SORT FIELDS=(05,8,BI,A)

Below Jcl I have used::
Code:

//SORTSTEP EXEC PGM=SORT                             
//SORTLIB  DD DSN=SYS1.SORTLIB,DISP=SHR               
//SYSOUT DD SYSOUT=(J)                               
//SORTIN   DD DSN=Input Dataset, 
//            DISP=SHR                               
//SORTOUT  DD DSN=&&SORTPREF,                         
//            UNIT=SYSDA,                             
//            SPACE=(32760,(00691,20),RLSE),         
//            DCB=(RECFM=VB,LRECL=2587,BLKSIZE=32760),
//            DISP=(NEW,PASS)                         
//SORTWK01 DD UNIT=SYSDA,                             
//            SPACE=(32760,(00691),,,ROUND),         
//            DISP=(NEW,DELETE,DELETE)               
//SORTWK02 DD UNIT=SYSDA,                             
//            SPACE=(32760,(00691),,,ROUND),         
//            DISP=(NEW,DELETE,DELETE)               
//SORTWK03 DD UNIT=SYSDA,                             
//            SPACE=(32760,(00691),,,ROUND),         
//            DISP=(NEW,DELETE,DELETE)               
//SORTWK04 DD UNIT=SYSDA,                             
//            SPACE=(32760,(00691),,,ROUND),         
//            DISP=(NEW,DELETE,DELETE)               
//SYSIN    DD *         
  RECORD TYPE=V         
  SORT FIELDS=(05,8,BI,A)
/*


Error::SB37

Can anyone help me regarding this,I have increased the Sort Work files to 12,but still it didn't work.


Mani[/img]
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Aug 29, 2006 8:49 pm    Post subject:
Reply with quote

Please show the //SYSOUT messages.
Back to top
View user's profile Send private message
manishram1

New User


Joined: 23 Mar 2006
Posts: 34

PostPosted: Wed Aug 30, 2006 3:52 pm    Post subject:
Reply with quote

Hi Frank,
Thanks for the quick reply,the Sysout of the particular job is having having only the Sysin SORT CARD.
************************************************************
PRODUCT LICENSED FOR CPU SERIAL NUMBER 18715, MODEL 2094 705
SYSIN :
RECORD TYPE=V
SORT FIELDS=(05,8,BI,A)
************************************************************
The issue has been resolved after i gave a dasd GDG instead of the temporary file.
Can you please clear my below doubts

Is there any limit for Temporary files?
If so how much is the limit? in MB or KB
Is there any other way of resolving this error?
Are Installation Parameters decide the size of the Temporary Files?
(I am using Syncsort)

Thanks & Regards,
Mani
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Aug 30, 2006 8:55 pm    Post subject:
Reply with quote

Mani,

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Back to top
View user's profile Send private message
MainframeHelp4_u

New User


Joined: 15 Aug 2006
Posts: 25

PostPosted: Sat Sep 02, 2006 2:30 pm    Post subject: SPACE problem
Reply with quote

The error u r getting because of SPACE problem..

1) Increase SORTWK01 , SORTWK02 ........TO SORTWK15

2) Increase the SPACE for SORTOUT..

3) SPACE PARAM u can code like this, ,SPACE=(CYL,(100,50),RLSE)

Try all these three options, still problem, increase the SPACE at SORTOUT DD Statement SPACE=(CYL,(200,150),RLSE) ..

Still problem ,, increase some more SPACE...

Still post the SYSOUT with full information...

cheers
Mainframehelp4_u
Back to top
View user's profile Send private message
manishram1

New User


Joined: 23 Mar 2006
Posts: 34

PostPosted: Tue Sep 05, 2006 2:44 am    Post subject: Re: SB37 Error While Sorting
Reply with quote

Thanks Frank.I will get back to you if i get any DFSORT error.
Is there any limit for the Temporary Dataset also in DFSORT also??

Hi Everyone,
The Error has been resolved after i gave a DASD GDG instead of a Temporary dataset.Thankyou for all your help.


Ragards,
Mani
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Sep 05, 2006 4:39 am    Post subject:
Reply with quote

Quote:
Is there any limit for the Temporary Dataset also in DFSORT also??


You can use up to 255 work data sets.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

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