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

Reg: Error while merging.


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

New User


Joined: 03 Aug 2006
Posts: 42
Location: Chennai

PostPosted: Sat Jan 05, 2008 3:24 pm
Reply with quote

Hi,

For the following code:

Code:

//MERGE EXEC PGM=SORT                                   
//SORTIN01 DD DSN=P4030.DFSORT(MERINP1),DISP=SHR,       
//            DCB=(LRECL=80,RECFM=FB)                   
//SORTIN02 DD DSN=P4030.DFSORT(MERINP2),DISP=SHR       
//SORTOUT  DD *                                         
//SYSOUT   DD SYSOUT=*                                 
//SORTDIAG DD DUMMY                                     
//SYSIN    DD *                                         
     MERGE FIELDS=(1,37,CH,A)                           
*    MERGE FIELDS=(39,5,CH,A)                           
//                                                     


Am getting the following error.

Code:

ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                     
ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K90007 C6-K90007 C7-K90000 C8-K90007 E4-K90007 C9-BASE   E5-K18181
ICE143I 0 BLOCKSET     MERGE TECHNIQUE SELECTED                                 
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 04:35 ON SAT JAN
               MERGE FIELDS=(1,37,CH,A)                                         
          *    MERGE FIELDS=(39,5,CH,A)                                         
ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1                         
ICE751I 0 C5-K90007 C6-K90007 C7-K90000 C8-K90007 E4-K90007 C9-BASE   E5-K18181
ICE193I 0 ICEAM1 ENVIRONMENT IN EFFECT - ICEAM1 INSTALLATION MODULE SELECTED   
ICE088I 0 P4030SRT.MERGE   .        , INPUT LRECL = 80, BLKSIZE = 6160, TYPE = F
ICE093I 0 MAIN STORAGE = (MAX,4194304,4181086)                                 
ICE156I 0 MAIN STORAGE ABOVE 16MB = (4116544,4100160)                           
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC0 ,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=4194304,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERE
ICE129I 0 OPTIONS: VIO=Y,RESDNT=ALL ,SMF=FULL ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=16384,RESINV=0,SVC=109 ,CHECK=N,WRKREL=Y,OUTREL=Y,CKPT
ICE131I 0 OPTIONS: TMAXLIM=4194304,ARESALL=16384,ARESINV=0,OVERRGN=65536,CINV=Y,
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE    ,EXITC
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=0   ,ODMAXBF=0,SOLRF=N,VLLONG=N,VSAMI
ICE235I 0 OPTIONS: NULLOUT=RC0                                                 
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTOUT                                   
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTIN01                                 
ICE084I 0 BSAM ACCESS METHOD USED FOR SORTIN02                                 
ICE889I 0 CT=MAX     , SB=8, L=0, D=0000                                       
ICE901I 0 N 01PS10 02PS10                                                       
ICE902I 0 O AZ00  I                                                             
ICE068A 0 OUT OF SEQUENCE SORTIN01                                             
ICE751I 1 DC-K10929 DD-Q95174 E8-K19114                                         
ICE052I 0 END OF DFSORT                                                         


From the above error message i understood that my sorting01 file is having some error.

the input file is as follows:

Code:

LIVING WELL ON A SMALL BUDGET             
PICK'S POCKET DICTIONARY                   
INTRODUCTION TO BIOLOGY               BIOL
SUPPLYING THE DEMAND                  BUSIN
STRATEGIC MARKETING                   BUSIN
COMPUTER LANGUAGES                    COMP
VIDEO GAME DESIGN                     COMP
COMPUTERS: AN INTRODUCTION            COMP
NUMBERING SYSTEMS                     COMP
SYSTEM PROGRAMMING                    COMP
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
EDITING SOFTWARE MANUALS              ENGL
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
THE COMPLETE PROOFREADER              ENGL
SHORT STORIES AND TALL TALES          ENGL
THE INDUSTRIAL REVOLUTION             HIST
EIGHTEENTH CENTURY EUROPE             HIST
CRISIS OF THE MIDDLE AGES             HIST
INTRODUCTION TO PSYCHOLOGY            PSYCH
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH



Can someone help me in resolving the error.
Thanks in advance.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Sat Jan 05, 2008 3:36 pm
Reply with quote

Quote:
ICE068A 0 OUT OF SEQUENCE SORTIN01


I wish that before posting everyone would read the program output...

rethoric question..
what are the requirement for a merge

rethoric answer
to have the input files already sorted

Code:
MERGE FIELDS=(1,37,CH,A)


question...
are Your files sorted
Code:
LIVING WELL ON A SMALL BUDGET             
PICK'S POCKET DICTIONARY                   
INTRODUCTION TO BIOLOGY               BIOL
SUPPLYING THE DEMAND                  BUSIN
STRATEGIC MARKETING                   BUSIN
COMPUTER LANGUAGES                    COMP
VIDEO GAME DESIGN                     COMP
COMPUTERS: AN INTRODUCTION            COMP
NUMBERING SYSTEMS                     COMP
SYSTEM PROGRAMMING                    COMP
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
EDITING SOFTWARE MANUALS              ENGL
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
THE COMPLETE PROOFREADER              ENGL
SHORT STORIES AND TALL TALES          ENGL
THE INDUSTRIAL REVOLUTION             HIST
EIGHTEENTH CENTURY EUROPE             HIST
CRISIS OF THE MIDDLE AGES             HIST
INTRODUCTION TO PSYCHOLOGY            PSYCH
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH

answer...
noooo

fix/solution
before a merge operation ... sort the files /datasets in the required order
Code:
ADVANCED TOPICS IN PSYCHOANALYSIS     PSYCH
COMPUTER LANGUAGES                    COMP
COMPUTERS: AN INTRODUCTION            COMP
CRISIS OF THE MIDDLE AGES             HIST
EDITING SOFTWARE MANUALS              ENGL
EIGHTEENTH CENTURY EUROPE             HIST
INKLINGS: AN ANTHOLOGY OF YOUNG POETS ENGL
INTRODUCTION TO BIOLOGY               BIOL
INTRODUCTION TO PSYCHOLOGY            PSYCH
LIVING WELL ON A SMALL BUDGET             
MODERN ANTHOLOGY OF WOMEN POETS       ENGL
NUMBERING SYSTEMS                     COMP
PICK'S POCKET DICTIONARY                   
SHORT STORIES AND TALL TALES          ENGL
STRATEGIC MARKETING                   BUSIN
SUPPLYING THE DEMAND                  BUSIN
SYSTEM PROGRAMMING                    COMP
THE COMPLETE PROOFREADER              ENGL
THE INDUSTRIAL REVOLUTION             HIST
VIDEO GAME DESIGN                     COMP


note... it might have worked with the other merge card...
Back to top
View user's profile Send private message
muthukannan

New User


Joined: 03 Aug 2006
Posts: 42
Location: Chennai

PostPosted: Sat Jan 05, 2008 4:21 pm
Reply with quote

Thank you so much e.s.


As you said it worked for the other Merge card.
Thanks again.
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: Sat Jan 05, 2008 10:09 pm
Reply with quote

Quote:
before a merge operation ... sort the files /datasets in the required order


Or if the files are not already in sorted order, just SORT the concatenated files instead of doing a MERGE on the individual files.
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 Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Getting Error while trying to establi... DB2 3
Search our Forums:

Back to Top