I saw so many posts on Splitting records using DFSORT/ICETOOL but want something which is good at performance. I said Performance because I'm splitting a file1 which has around 60 Million records out of which more or less 50 Million belongs to one file and rest belongs to other file. The Current job takes 10 Minutes to do the same.
The current Toolin statement and Control Cards which I use are listed below:
//TOOLIN DD *
COPY FROM(IN1) TO(OUT1) USING(CTL1)
COPY FROM(IN1) TO(OUT2) USING(CTL2)
/*
//CTL1CNTL DD *
INCLUDE COND=(34,3,CH,EQ,C'AA')
/*
//CTL2CNTL DD *
INCLUDE COND=(34,3,CH,EQ,C'BB')
/*
//*
COPY FROM(IN1) TO(OUT1) USING(CTL1)
COPY FROM(IN1) TO(OUT2) USING(CTL2)
/*
//CTL1CNTL DD *
INCLUDE COND=(34,3,CH,EQ,C'AA')
/*
//CTL2CNTL DD *
INCLUDE COND=(34,3,CH,EQ,C'BB')
/*
//*
I'm sure I am traversing the file for 2 times one for First one and another time for Second time.
I guess there should be some way to send the records to file one based on a condition and parallelly the rest to other file.