DFSORT omitted some records while copying



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

DFSORT omitted some records while copying

Postby rajeshy2k » Sun Sep 29, 2013 11:33 pm

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.
rajeshy2k
 
Posts: 1
Joined: Sun Sep 29, 2013 11:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DFSORT omitted some records while copying

Postby BillyBoyo » Mon Sep 30, 2013 12:30 am

You have to show the full sysout from the SORT you believe did not work.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: DFSORT omitted some records while copying

Postby dick scherrer » Mon Sep 30, 2013 6:45 am

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post