But here is the issue
We expecting around 10k records but file has 206K records.
You do NOT need to send me a private e-mail every time you post here. Either post here, or send me a private e-mail- don't do both!
I don't understand how you expect me to help you with just this information. I certainly can't verify that you should get 206K records or 10K records since I don't have your input file.
DFSORT pulls the records based on the control statements you give it which are:
This tells DFSORT to select records with 'MCIPROB' in positions 26-32, sort them on 1-32 and only keep one record with each value in 1-32.
If you're not getting the number of records you expect, then something is not correct in your control statements.
Also, I thought you just wanted to process the IMSTESTA.IMF310.ITD.SOURCE(TCIS0223) data set, so I told you to use:
//SORTIN DD DSN=IMSTESTA.IMF310.ITD.SOURCE(TCIS0223),DISP=SHR
But your JCL shows you using all of the data sets for SORTIN:
//SORTIN DD DISP=OLD,DSN=IMSTESTA.IMF310.ITD.SOURCE(DEFAULT)
// DD DISP=OLD,DSN=IMSTESTA.IMF310.ITD.SOURCE(CWS)
// DD DISP=OLD,DSN=IMSTESTA.IMF310.ITD.SOURCE(TCIS0223)
// DD DISP=OLD,DSN=IMSTESTA.IMF310.ITD.SOURCE(PDB) ## 10/28/11
// DD DISP=OLD,DSN=IMSTESTA.IMF310.ITD.SOURCE(ETRS1211)
You should only have the data set you want to process for SORTIN.