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 CAPACITY EXCEEDED Different results

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

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 4:07 pm    Post subject: SORT CAPACITY EXCEEDED Different results
Reply with quote

Hi,
Please see the below JCL:

Code:
//SRT15#18 EXEC PGM=ICETOOL                         
//*                                                 
//TOOLMSG   DD SYSOUT=*                             
//DFSMSG    DD SYSOUT=*                             
//SYSUDUMP  DD SYSOUT=*                             
//SYSOUT    DD SYSOUT=*                             
//SYSPRINT  DD SYSOUT=*                             
//SORTIN    DD DSN=PPP.AAAAAAAA.AAALOG,DISP=SHR     
//BBBLOG    DD DSN=BBB.BBBB.TEST,DISP=SHR           
//CCCJNK    DD DSN=CCC.CCCCCCC.CCCCJUNK,DISP=SHR     
//TOOLIN    DD *                                     
 SORT FROM(SORTIN) TO(BBBLOG) USING(BBBB)           
 SORT FROM(SORTIN) TO(CCCJNK) USING(BBBB)           
//BBBBCNTL  DD *                                     
 SORT FIELDS=(1,1,A,2,9,A),FORMAT=CH                 
 OMIT COND=(11,4,CH,EQ,X'00000000')                 
 END                                                 
//CCCCCNTL  DD *                                     
 SORT FIELDS=(1,1,A),FORMAT=CH                       
 INCLUDE COND=(11,4,CH,EQ,X'00000000')               
 END                                                 
//*


the above job runs daily in batch without any issue but suddenly it failed yesterday with the below issue:
Code:
ICE046A 2 SORT CAPACITY EXCEEDED - RECORD COUNT 15038



but the job ran fine when I ran offline with my id with no change in above parameters. Please advise why the job didn't fail when I ran offline.

To prevent this issue I will add below in daily batch run:
Code:
OPTION FILSZ=E15038
Back to top
View user's profile Send private message

magesh23586

Active User


Joined: 06 Jul 2009
Posts: 159
Location: Chennai

PostPosted: Tue Jun 16, 2015 4:16 pm    Post subject: Reply to: Different results
Reply with quote

The reason may be due to limitation of space during the prodution run.

Add this parm to JCL and let us know the results.

Code:

//DFSPARM DD *
   OPTION DYNALLOC=(,16),FILSZ=E25000
/*
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 4:23 pm    Post subject:
Reply with quote

Hi,
Just wanted to know why it didn't fail with my ID.
Back to top
View user's profile Send private message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 159
Location: Chennai

PostPosted: Tue Jun 16, 2015 4:26 pm    Post subject: Reply to: Different results
Reply with quote

We need JESMSGLG and complete SYSOUT of the step to suggest.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Tue Jun 16, 2015 4:51 pm    Post subject:
Reply with quote

abhijit.nayak01 wrote:
Hi,
Just wanted to know why it didn't fail with my ID.

Because by then there was sufficient space available.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Tue Jun 16, 2015 5:03 pm    Post subject: Reply to: Different results
Reply with quote

Why are you doing it in two steps? Very inefficient.

Do one SORT, two OUTFILs, one with INCLUDE= the other with SAVE.

Did you look the message up? What did it suggest to you?
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 5:08 pm    Post subject:
Reply with quote

Result with Batch run:

Code:
 JOE0008 from BATCHRUN.SRT15#18.TOOLMSG  contains 00000020 lines               
1ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED                                   
                                                                               
 ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES
                                                                               
 ICE632I 0 SOURCE FOR ICETOOL STATEMENTS:  TOOLIN                               
                                                                               
                                                                               
 ICE630I 0 MODE IN EFFECT:  STOP                                               
  ICE630I 0 MODE IN EFFECT:  STOP                                             
                                                                             
            SORT FROM(SORTIN) TO(BBBLOG) USING(BBBB)                         
 ICE606I 0 DFSORT CALL 0001 FOR SORT  FROM SORTIN   TO BBBLOG   USING BBBBCNTL  TERMINATED
 ICE602I 0 OPERATION RETURN CODE:  16                                         
                                                                             
 ICE630I 2 MODE IN EFFECT:  SCAN                                             
                                                                             
            SORT FROM(SORTIN) TO(CCCJNK) USING(CCCC)                         
 ICE612I 0 NO ERRORS FOUND IN STATEMENT                                       
                                                                             
                                                                             
 ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE:  16               
 JOE0009 from BATCHRUN.SRT15#18.DFSMSG   contains 00000044 lines             
1ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0001                           
 ICE805I 0 JOBNAME: BATCHRUN , STEPNAME: BATCHRUN                             
 ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                 
 ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5                       
 ICE751I 0 C5-I12416 C6-K90026 C7-K94453 C8-K94453 EE-I14544 E4-K58148 C9-BASE E5-K80744 E7-I12416
 CE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED                                 
CE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND
CE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 19:52 ON MON JUN
          SORT FIELDS=(1,1,A,2,9,A),FORMAT=CH                                   
          OMIT COND=(11,4,CH,EQ,X'00000000')                                   
CE146I 0 END OF STATEMENTS FROM BBBBCNTL - PARAMETER LIST STATEMENTS FOLLOW     
         DEBUG NOABEND,ESTAE                                                   
         OPTION MSGDDN=DFSMSG,LIST,MSGPRT=ALL,RESINV=0,SORTDD=BBBB,SORTIN=SORTIN
                        ,SORTOUT=BBBLOG,DYNALLOC                               
CE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED 
CE252I 1 PARMLIB OPTIONS WERE MERGED WITH INSTALLATION MODULE DEFAULTS         
CE088I 0 BATCHRUN.BATCHRUN.SRT15#18, INPUT LRECL = 724, BLKSIZE = 4096, TYPE = V
CE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                   
CE156I 0 MAIN STORAGE ABOVE 16MB = (6225904,6225904)                           
CE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=1024
CE128I 0 OPTIONS: SIZE=6291456,MAXLIM=2097152,MINLIM=524288,EQUALS=Y,LIST=Y,ERET=RC16 ,MSGDDN=DFSMSG
CE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=N             ,ABCODE=MSG
CE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
CE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW=Y,DSA=0     
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=Y,TEXIT=N,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N
ICE133I 0 OPTIONS: HIPRMAX=0      ,DSPSIZE=128 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0
ICE235I 0 OPTIONS: NULLOUT=RC0                                                 
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y                                         
ICE084I 0 BSAM ACCESS METHOD USED FOR BBBLOG                                   
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                                   
ICE750I 0 DC 737280 TC 0 CS DSVII KSZ 14 VSZ 14                               
ICE752I 0 FSZ=737280 BC  IGN=0 E  AVG=362 0  WSP=957 C  DYN=0 0               
ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(1),MOSTG=0,MEML=17592186039816(3)             
ICE916I 0 MOFR=0002,MOVR=ZZ                                                   
ICE996I 0 ESM=7591680,ESO=0,ESR=0,ESP=4096,ESS=16384,CES=7591680,HSZ=524288   
ICE997I 0 HWSP=0,HMAX=0,HES=0,ASV=0,EQ=N0,HN=0                                 
ICE898I 0 OMAX=0,NMAX=3528197,ENQT=0,CMAX=0,HU=0,BUN=0,MD=N1,N1,DU=0,DR=0,HN=0
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000, CCW=1MAM                             
ICE902I 0 O PP10  I PP10                                                       
ICE046A 2 SORT CAPACITY EXCEEDED - RECORD COUNT 15038                         
ICE253I 0 RECORDS SORTED - PROCESSED: 15038, EXPECTED: 2036                   
ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 383, EXPECTED: 362               
ICE751I 1 D8-K58148 D4-K59452 E8-I12416                                       
ICE052I 0 END OF DFSORT                                                         
******************************** Bottom of Data ********************************



Results with my ID :

Code:
ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED                                   
                                                                               
ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES A
                                                                               
ICE632I 0 SOURCE FOR ICETOOL STATEMENTS:  TOOLIN                               
                                                                               
                                                                               
ICE630I 0 MODE IN EFFECT:  STOP                                                 
                                                                               
           SORT FROM(SORTIN) TO(BBBLOG) USING(BBBB)                             
ICE606I 0 DFSORT CALL 0001 FOR SORT  FROM SORTIN   TO BBBLOG   USING BBBBCNTL COMPLETED
ICE602I 0 OPERATION RETURN CODE:  00                                           
                                                                               
           SORT FROM(SORTIN) TO(CCCJNK) USING(CCCC)                             
ICE606I 0 DFSORT CALL 0002 FOR SORT  FROM SORTIN   TO CCCJNK   USING CCCCCNTL COMPLETED
ICE602I 0 OPERATION RETURN CODE:  00                                           
ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE:  00                 
ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0001                             
ICE805I 0 JOBNAME: MYIDIRUN , STEPNAME: SRT15#18                               
ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                   
ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5                         
ICE992I 0 RA 0 WR 0 TR 2                                                       
ICE751I 0 C5-I12416 C6-K90026 C7-K94453 C8-K94453 EE-I14544 E4-K58148 C9-BASE   E5-K80744 E6-K94453 C4-K94453 E7-I12416 
ICE143I 0 BLOCKSET     SORT  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 V1R12 - 20:36 ON MON JUN 15, 2015 -
           SORT FIELDS=(1,1,A,2,9,A),FORMAT=CH                                 
           OMIT COND=(11,4,CH,EQ,X'00000000')                                 
ICE146I 0 END OF STATEMENTS FROM BBBBCNTL - PARAMETER LIST STATEMENTS FOLLOW   
          DEBUG NOABEND,ESTAE                                                 
          OPTION MSGDDN=DFSMSG,LIST,MSGPRT=ALL,RESINV=0,SORTDD=BBBB,SORTIN=SORTIN*
                         ,SORTOUT=BBBLOG,DYNALLOC                             
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED
ICE252I 1 PARMLIB OPTIONS WERE MERGED WITH INSTALLATION MODULE DEFAULTS       
ICE088I 0 MYIDIT2A.SRT15#18.        , INPUT LRECL = 724, BLKSIZE = 4096, TYPE = V
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6234096,6234096)                         
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=1024
ICE128I 0 OPTIONS: SIZE=6291456,MAXLIM=2097152,MINLIM=524288,EQUALS=Y,LIST=Y,ERET=RC16 ,MSGDDN=DFSMSG
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA   ,016),ABCODE=MSG
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW=Y,DSA=0
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=Y,TEXIT=N,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N
ICE133I 0 OPTIONS: HIPRMAX=0      ,DSPSIZE=128 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0
ICE235I 0 OPTIONS: NULLOUT=RC0                                                 
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y                                         
ICE084I 0 EXCP ACCESS METHOD USED FOR BBBLOG                                   
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                                   
ICE750I 0 DC 109854720 TC 0 CS DSV88 KSZ 14 VSZ 14                             
ICE752I 0 FSZ=109854720 BC  IGN=0 E  AVG=362 0  WSP=142682 C  DYN=2592 56664   
ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(1),MOSTG=0,MEML=17592186039817(3)             
ICE916I 0 MOFR=0002,MOVR=ZZ                                                   
ICE996I 0 ESM=7591680,ESO=0,ESR=0,ESP=4096,ESS=16384,CES=7591680,HSZ=524288   
ICE898I 0 OMAX=0,NMAX=3434392,ENQT=0,CMAX=0,HU=0,BUN=0,MD=N1,N1,DU=0,DR=0,HN=0
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000, CCW=1MAM                             
ICE901I 0 W 10PP17 04PP17 06PP17 0DPP17 02PP17 0BPP17 03PP17 0FPP17           
ICE901I 0 W 12PP17 08PP17 01PP17 05PP17 11PP17 07PP17 0APP17 0EPP17           
ICE901I 0 W 0CPP13 09PP13                                                     
ICE902I 0 O PP10  I PP10                                                       
ICE751I 1 D8-K58148 D4-K59452 EA-I16099 F1-K58148 E8-I12416                   
ICE900I 0 CON=1,MUV=0,VOL=1,ENU=0,SBK=0,SRC=0,VEM=0                           
ICE999I 0 PWK=16 PSP=2592 SWK=0 SSP=0 TWK=0 TSP=0 RWK=0 RSP=0 AWK=16 AWP=2592 
ICE090I 0 OUTPUT LRECL = 724, BLKSIZE = 27998, TYPE = VB                       
ICE055I 0 INSERT 0, DELETE 0                                                   
ICE054I 0 RECORDS - IN: 65803, OUT: 65803                                     
ICE134I 0 NUMBER OF BYTES SORTED: 40859260                                     
ICE253I 0 RECORDS SORTED - PROCESSED: 65803, EXPECTED: 303466                 
ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 620, EXPECTED: 362               
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 2640 , TRACKS USED: 1215       
ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES                       
ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES                       
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES                                   
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES                                   
ICE891I 1 6283176 WMAIN, 8280 CMAIN, MAX CALLOC, N SCN, B BA, 0 AZ, 0 BZ, NN QC, 0 CZ, 0 DZ, 0 PLE
ICE892I 1 724 RIN  728 BLI  27998 BLO  724 RUN  56664 BUN  2827 CPU  00 CVC   
ICE893I 1 60 XIN 5 WIN 10556 GIN NDEY PFP3  B00 CM000 CIK UPTH LMK VS   RUX   
ICE894I 0 2 STR  2 MOR  67 IPB  85 OPB  81 CYL  O   MN                         
ICE896I 0 81 SET  733 DEXTOT  729 BLK   109854720 CSZ  282 WE                 
ICE804I 1 BBBBWK12 EXCP COUNT: 18                                             
ICE804I 1 BBBBWK11 EXCP COUNT: 18                                             
ICE804I 1 BBBBWK10 EXCP COUNT: 20                                             
ICE804I 1 BBBBWK0F EXCP COUNT: 17                                             
ICE804I 1 BBBBWK0E EXCP COUNT: 20                                             
ICE804I 1 BBBBWK0D EXCP COUNT: 15                                             
ICE804I 1 BBBBWK0C EXCP COUNT: 1                                               
ICE804I 1 BBBBWK0B EXCP COUNT: 16                                             
ICE804I 1 BBBBWK0A EXCP COUNT: 17                                             
ICE804I 1 BBBBWK09 EXCP COUNT: 1                                               
ICE804I 1 BBBBWK08 EXCP COUNT: 16                                             
ICE804I 1 BBBBWK07 EXCP COUNT: 18                                             
ICE804I 1 BBBBWK06 EXCP COUNT: 19
ICE804I 1 BBBBWK05 EXCP COUNT: 19                                             
ICE804I 1 BBBBWK04 EXCP COUNT: 14                                             
ICE804I 1 BBBBWK03 EXCP COUNT: 18                                             
ICE804I 1 BBBBWK02 EXCP COUNT: 17                                             
ICE804I 1 BBBBWK01 EXCP COUNT: 18                                             
ICE804I 1 BBBLOG   EXCP COUNT: 39                                             
ICE052I 0 END OF DFSORT                                                       
ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0002                             
ICE805I 0 JOBNAME: MYIDIT2A , STEPNAME: SRT15#18                               
ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                   
ICE201I H RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE992I 0 RA 0 WR 0 TR 2                                                       
ICE751I 0 C5-I12416 C6-K90026 C7-K94453 C8-K94453 EE-I14544 E4-K58148 C9-BASE   E5-K80744 E6-K94453 C4-K94453 E7-I12416   
ICE143I 0 BLOCKSET     SORT  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 V1R12 - 20:36 ON MON JUN 15, 2015 -
           SORT FIELDS=(1,1,A),FORMAT=CH                                       
           INCLUDE COND=(11,4,CH,EQ,X'00000000')                               
ICE146I 0 END OF STATEMENTS FROM CCCCCNTL - PARAMETER LIST STATEMENTS FOLLOW
          DEBUG NOABEND,ESTAE                                                 
          OPTION MSGDDN=DFSMSG,LIST,MSGPRT=ALL,RESINV=0,SORTDD=CCCC,SORTIN=SORTIN*
                         ,SORTOUT=CCCJNK,DYNALLOC                             
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED
ICE252I 1 PARMLIB OPTIONS WERE MERGED WITH INSTALLATION MODULE DEFAULTS       
ICE088I 1 MYIDIT2A.SRT15#18.        , INPUT LRECL = 720, BLKSIZE = 4096, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,6291456,6291456)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6234096,6234096)                         
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=1024
ICE128I 0 OPTIONS: SIZE=6291456,MAXLIM=2097152,MINLIM=524288,EQUALS=N,LIST=Y,ERET=RC16 ,MSGDDN=DFSMSG         
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA   ,016),ABCODE=MSG 
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW=Y,DSA=0 
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=Y,TEXIT=N,LISTX=N,EFS=NONE    ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N 
ICE133I 0 OPTIONS: HIPRMAX=0      ,DSPSIZE=128 ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0
ICE235I 0 OPTIONS: NULLOUT=RC0                                                 
ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y                                         
ICE084I 0 EXCP ACCESS METHOD USED FOR CCCJNK                                   
ICE084I 1 VSAM ACCESS METHOD USED FOR SORTIN                                                                                 
ICE750I 0 DC 109854720 TC 0 CS DSVVV KSZ 1 VSZ 1                               
ICE752I 0 FSZ=152576 RC  IGN=0 E  AVG=720 0  WSP=142682 C  DYN=2608 56168     
ICE915I 0 MOFSZ=0,MOSZ=0,MOSYS=0(1),MOSTG=0,MEML=17592186039817(3)             
ICE916I 0 MOFR=0003,MOVR=VV                                                   
ICE996I 0 ESM=7591680,ESO=0,ESR=0,ESP=4096,ESS=16384,CES=7591680,HSZ=524288   
ICE997I 0 HWSP=67050,HMAX=0,HES=0,ASV=0,EQ=N0,HN=0                             
ICE898I 0 OMAX=0,NMAX=3435043,ENQT=0,CMAX=0,HU=0,BUN=0,MD=N1,N1,DU=0,DR=0,HN=0
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000, CCW=1MAM                             
ICE901I 0 W 0FPP17 0APP17 05PP17 0DPP17 0CPP17 11PP17 01PP17 0BPP17           
ICE901I 0 W 10PP17 07PP17 03RP17 02PP17 12PP17 0EPP17 09PP17 08PP17           
ICE901I 0 W 06PP13 04PP13                                                     
ICE902I 0 O PP10  I PP10                                                       
ICE751I 1 DE-K83743 D5-K91600 D9-K61787 E8-I12416                             
ICE900I 0 CON=1,MUV=0,VOL=1,ENU=0,SBK=0,SRC=0,VEM=0                           
ICE999I 0 PWK=16 PSP=2608 SWK=0 SSP=0 TWK=0 TSP=0 RWK=0 RSP=0 AWK=16 AWP=2608 
ICE090I 0 OUTPUT LRECL = 724, BLKSIZE = 27512, TYPE = FB                       
ICE080I 0 IN MAIN STORAGE SORT                                                 
ICE055I 0 INSERT 0, DELETE 65803                                               
ICE054I 0 RECORDS - IN: 65803, OUT: 0                                         
ICE173I 0 NO RECORDS FOR THE SORTOUT DATA SET - RC=0                           
ICE134I 0 NUMBER OF BYTES SORTED: 0                                           
ICE253I 0 RECORDS SORTED - PROCESSED: 0, EXPECTED: 152576                     
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 2790 , TRACKS USED: 0         
ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES                       
ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES                       
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES                                   
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES                                   
ICE891I 1 6283168 WMAIN, 8288 CMAIN, MAX CALLOC, N SCN, B BA, 0 AZ, 0 BZ, NN QC
ICE892I 1 720 RIN  720 BLI  27512 BLO  720 RUN  56168 BUN  2827 CPU  00 CVC   
ICE893I 1 200 XIN 14 WIN 6133 GIN NDEY PFP8  B00 CM000 CIK UPTH LMK VS   RUX   
ICE894I 0 0 STR  0 MOR  0 IPB  200 OPB  0 CYL  I   MN                         
ICE885I 0 DAT 00 DSR 010B BINS 0 BSZ 0 RCP 0 AJC 0 RLC 0 DUNIT 0               
ICE895I 0 19 MUNIT  38 SUNIT  28 OUNIT                                         
ICE896I 0 0 SET  0 DEXTOT  0 BLK   152576 CSZ  34 WE                           
ICE804I 1 CCCCWK12 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK11 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK10 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0F EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0E EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0D EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0C EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0B EXCP COUNT: 2                                               
ICE804I 1 CCCCWK0A EXCP COUNT: 2                                               
ICE804I 1 CCCCWK09 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK08 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK07 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK06 EXCP COUNT: 1                                               
ICE804I 1 CCCCWK05 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK04 EXCP COUNT: 1                                               
ICE804I 1 CCCCWK03 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK02 EXCP COUNT: 2                                               
ICE804I 1 CCCCWK01 EXCP COUNT: 2                                               
ICE804I 1 CCCJNK   EXCP COUNT: 0                                               
ICE052I 0 END OF DFSORT                                                       
******************************* BOTTOM OF DATA ********************************
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 5:11 pm    Post subject:
Reply with quote

Because by then there was sufficient space available.
Quote:


After first abend i tried the run with my ID and it was successful but then again in TWS batch I resubmitted the batch job and it failed with the same issue.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 5:13 pm    Post subject:
Reply with quote

Hi Bill,
This is a an existing process but I will make a request to change it.
Back to top
View user's profile Send private message
magesh23586

Active User


Joined: 06 Jul 2009
Posts: 159
Location: Chennai

PostPosted: Tue Jun 16, 2015 5:39 pm    Post subject:
Reply with quote

DYNALLOC was set to 'N' in your batch run and the same set to 16 with your id.

Which mean no dynamic allocation was done in you batch run caused the failure.

Either you need to use sortworkspace SORTWKdd or
use DFSPARM to override system default.

Batch run:
Code:

ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=N             ,ABCODE=MSG



Test run:
Code:

ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA   ,016),ABCODE=MSG
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Tue Jun 16, 2015 5:46 pm    Post subject: Reply to: Different results
Reply with quote

What you are showing now doesn't match what you had anyway.

You have a VSAM dataset as input. Look at using a RECORD statement.

I suspect something may be completely up the chute. You'll need to show the JCL as well.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 6:06 pm    Post subject:
Reply with quote

Thanks Magesh.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 6:10 pm    Post subject:
Reply with quote

Hi Bill,
The JCL is exactly the same which I showed earlier. The only thing is I changed the dataset names and DD names.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 6:17 pm    Post subject:
Reply with quote

Hi Magesh,

Surprisingly when I am checking the preevious batch runs I mean 14th june run previous run I am finding
Code:
DYNALOC=(SYSDA   ,016)


which means somehow the default is changed on 15th June to
Code:
DYNALOC=N


which means the batch job is again going to fail as the window to make the change is gone and have to follow yesterday's process to make that job through.
But many thanks to you guys for finding the exact issue.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Tue Jun 16, 2015 6:47 pm    Post subject: Reply to: Different results
Reply with quote

Do you realise that "completely up the chute" can be very, very, bad.

Your SORT statement, in BBBBCNTL, is this:

Code:
 SORT FIELDS=(1,1,A,2,9,A),FORMAT=CH


Your data gets reported as variable-length.

So your are SORTing on the first byte of the RDW, followede by the next three bytes of the RDW (don't know why you separated the key) and then the first six bytes of data.

Your other SORT, unused in your first post, is only on the first byte of the RDW.

This may be what you want.

Look at your allocations. You have both overallocation and underallocation of workspace.

Look at what I wrote about the RECORD statement.

If you have close to 24 hours to fix it, I suggest you get moving quickly, as you may have issues from the previous order of the data.

You also need to get to the bottom of who made the change to the defaults (if that is what happened), and probably more I don't have time to look for.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Tue Jun 16, 2015 7:07 pm    Post subject:
Reply with quote

Hi Bill,
Now I understand where you are going with RDW. You are 100% correct and now I have to find the developer and also need to previous outputs whether they were correct or not. If the mistake done is only with
Code:
SORT FIELDS=(1,1,A,2,9,A),FORMAT=CH


then its fine but if the mistake is also done with the below means the output files were always wrong.
Code:
 OMIT COND=(11,4,CH,EQ,X'00000000') 
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7232

PostPosted: Tue Jun 16, 2015 7:39 pm    Post subject: Reply to: Different results
Reply with quote

If it doesn't matter what order the data is in, don't SORT it at all. If it needs to be SORTed, it still needs to be sorted correctly, so don't just dismiss that. If a program later relies on it being in the correct order, then there can be problems there as well.
Back to top
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 157
Location: South Africa

PostPosted: Mon Jun 22, 2015 5:28 pm    Post subject:
Reply with quote

Hi Bill,
I got below reply from the storage management for the DYNALOC issue:

Quote:
The system default is set to DYNALOC(SYSDA, 16)

It can be changed by the individual user batch job.

Coding sortwk dd is not efficient, and would not recommend.

One reason why sort failed could be that there are too many sorts executing at the time and there is insufficient capacity within the system.

Below is the system default settings:

JCL INV
DSA 128 128
* 64 * 64
DSPSIZE 128 128
* MAX * MAX
DYNALOC (SYSDA,16) (SYSDA,16)



The sort was never changed and now the only reason is :

Quote:
One reason why sort failed could be that there are too many sorts executing at the time and there is insufficient capacity within the system
.
But again the above reasoning doesn’t seem to be correct as we executed this job several times in the span of 2 hours , and all times ended up in the same error
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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm


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