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

SORT Join Keys failing with S0C4 ABENDU0418


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sreekusr
Warnings : 1

New User


Joined: 28 Aug 2006
Posts: 54
Location: Madrid

PostPosted: Mon Apr 18, 2011 5:09 pm
Reply with quote

I have two files that I am using to perform a simple join to get the unpaired records. My first file is empty. The input records in FILE B (my second file) are 707107. The records get processed only until 59915 and then the job fails with S0c4. Please could you help? I have tried changing the region parameter to 0M as well but it does not work. When I submit the job it finishes with 0 for the first time but processes only 59915 records, where as when I submit it again it fails with S0c4 USER COMPLETION CODE=0418.

JOB is as below

Code:
     
//STEP0040 EXEC PGM=SORT,COND=(0,NE),REGION=0M                       
//SYSOUT DD SYSOUT=*                                             
//SORTJNF1 DD DSN=FILEA….,DISP=SHR       (this is an empty file)       
//SORTJNF2 DD DSN=FILEB….,DISP=SHR       
//SORTOUT  DD DSN=FILEC…,               
//             SPACE=(CYL,(500,100),RLSE),                           
//             DISP=(NEW,CATLG)                                     
//SYSIN DD *                                                         
* CONTROL STATEMENTS FOR JOINKEYS APPLICATION                       
  JOINKEYS FILE=F1,FIELDS=(325,5,A),SORTED,TYPE=F                   
  JOINKEYS FILE=F2,FIELDS=(2,5,A),SORTED,TYPE=F                     
  JOIN UNPAIRED,F1                                                   
  REFORMAT FIELDS=(F1:1,329,F2:19,15,F2:169,15,?),FILL=X'00'                       
  SORT FIELDS=COPY                 
  OUTREC BUILD=(1,359)             
  OPTION DYNALLOC,ZDPRINT         
/*                       


The Error log is as below

Code:
1ICE417I 0 THIS IS THE JOINKEYS F2 SUBTASK FOR SORTJNF2                                                                 
 ICE143I 0 BLOCKSET     COPY  TECHNIQUE SELECTED                                                                         
 ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE                                 
 ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R10 - 10:56 ON MON APR 18, 2011 -                           
0          MERGE FORMAT=BI,FIELDS=(2,5,A)                                                                               
           RECORD TYPE=F                                                                                                 
           DEBUG NOABEND,ESTAE                                                                                           
           OPTION EQUALS,MSGPRT=ALL,LIST,NOCHECK,RESINV=0,DYNALLOC,SORTDD=JNF2,MSG*                                     
                          DDN=JNF2JMSG,SORTIN=SORTJNF2,COPY                                                             
 ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1                                                                 
 ICE751I 0 C5-K90025 C6-K90025 C7-K54603 C8-K62201 E9-K51707 C9-BASE   E5-K62201 E7-K62201                               
 ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED                                         
 ICE088I 0 XXXXXX01.STEP0040.        , INPUT LRECL = 409, BLKSIZE = 32720, TYPE = FB                                     
 ICE093I 0 MAIN STORAGE = (MAX,20971520,20938752)                                                                       
 ICE156I 0 MAIN STORAGE ABOVE 16MB = (20875888,20875888)                                                                 
 ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256           
 ICE128I 0 OPTIONS: SIZE=20971520,MAXLIM=1048576,MINLIM=450560,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=JNF2JMSG               
 ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=FULL ,WRKSEC=Y,OUTSEC=N,VERIFY=N,CHALT=N,DYNALOC=N             ,ABCODE=MSG     
 ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=N,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2                         
 ICE131I 0 OPTIONS: TMAXLIM=20971520,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW=Y,DSA=0                               
 ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=N,IEXIT=N,TEXIT=Y,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N           
 ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=0   ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=MAX                         
 ICE235I 0 OPTIONS: NULLOUT=RC0                                                                                         
 ICE084I 0 BSAM ACCESS METHOD USED FOR SORTJNF2                                                                         
 ICE751I 1 EF-K49535 F0-K62421 E8-K61438                                                                                 
 ICE091I 0 OUTPUT LRECL = 409, TYPE = F                                                                                 
 ICE055I 0 INSERT 0, DELETE 59914                                                                                       
 ICE054I 0 RECORDS - IN: 59915, OUT: 0                                                                                   
 ICE185A 0 AN S0C4  ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE C 4)                                   
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Apr 18, 2011 8:41 pm
Reply with quote

did You care to search the dfsort documentation Yourself
if You had You would have found out the logic behing DFSORT abend processing

in general
a dfsort xxx abend tells to research the meaning of the corresponding ICExxxA message

in this case the ICE418A message which tells to ...
Quote:
| 2.2.286 ICE418A


| ICE418A JOINKEYS Fn SUBTASK FOR ddname1 TERMINATED - SEE ddname2
| MESSAGES



| Explanation: Critical. This message is issued by the main task of a
| JOINKEYS application to indicate that the subtask used to process file Fn
| (F1 or F2) terminated. ddname1 is the ddname associated with the input
| file for the subtask. ddname2 is the ddname associated with the message
| data set for the subtask.

| System Action: The program terminates.


| Programmer Response: See the messages in the ddname2 data set for
| information about the subtask. Correct the error that caused the subtask
| to terminate.


which tells You to look at the JNF2JMSG ddname to see exactly what happened !
Back to top
View user's profile Send private message
sreekusr
Warnings : 1

New User


Joined: 28 Aug 2006
Posts: 54
Location: Madrid

PostPosted: Mon Apr 18, 2011 9:34 pm
Reply with quote

Thanks for the reply,
Sorry if my earlier post was confusing, but the error log that i have posted earlier along with the JCL is the complete error message from JNF2JMSG.
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Apr 18, 2011 10:21 pm
Reply with quote

sreekusr,

Without complete sysout , I really cannot narrow down to the error. However I would suggest to reversing the files so the file with dups/more records is used as F1 and the empty file is used as F2.

If that doesn't work then I need you to send me the complete sysout of the job adding the following DDname to the job and re-run the job and send the complete sysout to skolusu@us.ibm.com

Code:

//SORTDIAG DD DUMMY 
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: Wed Apr 20, 2011 10:25 pm
Reply with quote

sreekusr,

For an S0C4, we need to see the SYSUDUMP and collect other doc. Please open a problem with IBM service so they can collect what we need to analyze the problem. We cannot debug this kind of thing on a helpboard.
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 Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top