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.