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
 

 

SORT large Files - Sb37

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Archana_MF

New User


Joined: 21 Jul 2006
Posts: 49
Location: California

PostPosted: Sat Apr 14, 2007 3:52 am    Post subject: SORT large Files - Sb37
Reply with quote

Hi,
I need to Sort a Tape DS with around 7 Million records
I am using the below JCL and it's giving SB37, I tried increasing the Cylinders to 3000 but no luck. Also gave Sortwork files still no use

/SORT01 EXEC PGM=SORT
//*
//SORTIN DD DSN=INPUT.FILE.XYZ,DISP=SHR
/
//*
//SORTOF1 DD DSN=TEST.GNC9010.ICL10Q0.MONTHLY.SORT,
// DCB=(RECFM=VB,LRECL=4100,BLKSIZE=0),
// DISP=(,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(100,100),RLSE)
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE)
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE)
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE)
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE)
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(500,500),RLSE)
//SYSIN DD *
SORT FIELDS=COPY
OPTION EQUALS
OUTFIL FILES=(1),INCLUDE=(70,02,CH,EQ,C'00')
/*

Can someone please let me know what else I can do or also if there is any better way to do the same task

Thank you in advance
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: Sat Apr 14, 2007 4:42 am    Post subject:
Reply with quote

Quote:
I need to Sort a Tape DS with around 7 Million records


But you have SORT FIELDS=COPY so you're copying the tape data set, not sorting it.

Quote:
I am using the below JCL and it's giving SB37, I tried increasing the Cylinders to 3000 but no luck. Also gave Sortwork files still no use


Since you're doing a copy, your SORTWK data sets aren't used and you can't be getting the B37 on one of those. Remove them as they're just wasting space you might need for SORTOF1.

So you must be getting the B37 on the SORTOF1 data set. You need to increase the space for that one to hold all of the output records. The maximum size needed would be for the 7 million records in the input file, but you could make it smaller depending on how many records you're omitting. I don't know how much space you'd need on DASD (my guys who figure out that kind of thing have left for the day) - maybe somebody else could figure it out for you.
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: Sat Apr 14, 2007 5:06 am    Post subject:
Reply with quote

Hello,

To find out how many of the 7million records will be written to the output file, you could run one run with the output dataset DD set to DUMMY. When the step runs, the output will should show how many records were copied. As your data is VB, the byte-count will be valuable also. Recently, i sorted 12+ million 80-byte records and the output required 1,187 3390-cylinders, so (100,100) will surely not be enough. . . Unless most of your records are way below the 4100.

When you have the number of records (and the byte count, which should be in the output) talk with your storage management people and ask how much space you need to allocate for that volume of data and what UNIT= or DATACLAS you should use in your jcl. If you use UNIT=(xxxxx,10) the dataset will be able to span across 10 volumes. Depending on what model of dasd you allocate on, the allocation may vary.

Good luck and we're here if there are questions icon_smile.gif
Back to top
View user's profile Send private message
Archana_MF

New User


Joined: 21 Jul 2006
Posts: 49
Location: California

PostPosted: Sat Apr 14, 2007 6:14 am    Post subject:
Reply with quote

Thank you all for the info.
I will check with storage managment about the SPACE.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am


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