IBM Mainframe Forum

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.

You have to show the full sysout from the SORT you believe did not work.

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.