IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Job abended while SORTING Files


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
k.junaid83

New User


Joined: 19 Apr 2006
Posts: 22
Location: bangalore

PostPosted: Mon Apr 02, 2007 7:26 pm
Reply with quote

I have a Job which is sorting huge files. My job looks like

Code:

//STEP01   EXEC PGM=SORT,REGION=0M
//SYSOUT   DD SYSOUT=(,)           
//SORTIN   DD DSN=xxx.xxx.xxx,DISP=SHR
//              DD DSN=xxx.xxx.xxxx,DISP=SHR
//              DD DSN=xxx.xxx.xxxx,DISP=SHR
//SORTOUT  DD DSN=&&SRTFILE1,                           
//          DISP=(,PASS,DELETE),                         
//          DCB=(BLKSIZE=0,LRECL=32400,RECFM=FB,DSORG=PS)
//          SPACE=(CYL,(500,500),RLSE),                 
//          UNIT=(SYSDA,30)                             
//SYSIN DD DISP=SHR,DSN=GFVKIH.FCGHN.JCLPARM(PARM101)


The PARM101/SORT Card looks like
Code:

SORT FIELDS=(5000,10,CH,A),DYNALLOC=(SYSDA,30)
SUM FIELDS=NONE


The Message in the SYSOUT is
Code:

ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT                                   
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTIN                                   
ICE750I 0 DC 48060187500 TC 0 CS DSVUU KSZ 14 VSZ 14                           
ICE752I 0 FSZ=1478775 RC  IGN=0 E  AVG=32504 0  WSP=62429606 C  DYN=984984 53216
ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 1454322                         
ICE753I 1 FWK=(24,984984) SWK=(0,0) TWK=(0,0) RWK=(0,0) TOTAL=(24,984984) BLK=53216
ICE751I 1 DE-K10929 D5-K05352 C4-K90000 E8-K90000                               
ICE052I 0 END OF DFSORT                                                         


The Job is bending with S000 , USER COMPLETION CODE=0046
My question is even though I am allocating Sort space Dynamically why the job is abending.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


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

PostPosted: Mon Apr 02, 2007 8:40 pm
Reply with quote

This has nothing to do with the SORTOUT space, so the comments about SORTOUT are irrelevant.

The ICE046A indicates there wasn't enough work space to complete the sort. DFSORT processed 1.4+ million records, but then ran out of work space. Approx. how many records do the three concatenated input files actually contain? What is the approx. average record length (if you know)?

If you add the following to the job:

//SORTDIAG DD DUMMY

to get diagnostic messages, rerun it and send me all of the JES and DFSORT messages offline (yaeger@us.ibm.com), I'll take a look at the diagnostic messages to see what's going on. In your offline note, please put "DFSORT" in your Subject line to catch my attention.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Reorg abended with REASON=X'00E40347' DB2 2
Search our Forums:

Back to Top