Page 1 of 1

DFSORT omitted some records while copying

PostPosted: Sun Sep 29, 2013 11:33 pm
by rajeshy2k
Hello Fellow Members,
I sorted a large file (unload of DB2 table approximately 10 M records), sorted based on the key field of the table (7 columns). I'm eliminating the duplicate rows using SUM FIELDS=NONE, the sort did work, however it omitted few records (954 rows (192 unique records)) in the output which should have been appeared. I had to re run the sort step again to process the missed records. It worked the second time because the rows resulted from first sort were already processed and it reduced the output from 10 M to 954. Any clues on why DFSORT behaved this way? Please let me know if any additional information is required.

Re: DFSORT omitted some records while copying

PostPosted: Mon Sep 30, 2013 12:30 am
by BillyBoyo
You have to show the full sysout from the SORT you believe did not work.

Re: DFSORT omitted some records while copying

PostPosted: Mon Sep 30, 2013 6:45 am
by dick scherrer
Hello and welcome to the forum,

The sort did exactly what you told it to do.

That is all that can be said until you post the JCL and control statements fro both runs along with the informational messages generated by the run.

When posting, use the Code tag and include the message id.