View previous topic :: View next topic
|
Author |
Message |
Sanjith
New User
Joined: 14 Jul 2021 Posts: 1 Location: UK
|
|
|
|
Dear All,
I have been observing different outputs for the same Sort/Join Step across 2 separate Jobs. The input files/sort card are all exactly same. The only difference is that one process is running outside of the Production environment and the other is locally on my spool under my ID.
I can't find any logical reason for such a difference in output.
Skeleton structure of my Step
Code: |
SortJNF1 DD DSN=FileA,Disp=SHR
SortJNF2 DD DSN=FileB,Disp=SHR
DD DSN=FileC,Disp=SHR
Sortout DD DSN=FileD,Disp=OLD
SYSIN - JOIN Card...
-- |
So, when i execute the above step in Production, its showing up an extra 100records apart from the 700 old matching ones.
I'm perplexed and wondering what is going wrong. Are there any external parameters that can affect the sorting? Like Region or Memory Space, may be?
Thank you,
Coded |
|
Back to top |
|
 |
sergeyken
Senior Member

Joined: 29 Apr 2008 Posts: 1751
|
|
|
|
Neither Region, nor Memory Space.
Nor DD statements, too.
Only - the code itself (SORT statements, not shown!), and the input data too (not shown as well!).
Also need to analyze carefully all the messages from SORT utility, in both cases.
In theory, a SORT parameter STOPAFT=700 can be introduced in one of your systems; but this probability is very low. You can also find it from the detailed SORT messages log! |
|
Back to top |
|
 |
Rohit Umarjikar
Global Moderator

Joined: 21 Sep 2010 Posts: 2992 Location: NYC,USA
|
|
|
|
I am sure only variable between two is input Dataset. I would suggest to pick up the same Generation or PS used outside production and then see if they are really 100% match.
Second, I don't think DFSORT version difference would impact this but no harm to compare that as well.
Third, remeber you coded DISP=OLD, try creating NEW Data set and compare at both places or look for the SORT messages for IN and OUT counts in the job log.
Code: |
Sortout DD DSN=FileD,Disp=OLD |
|
|
Back to top |
|
 |
|