IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Is the Output of Sort/Join dependent on any system config?


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sanjith

New User


Joined: 14 Jul 2021
Posts: 1
Location: UK

PostPosted: Wed Jul 14, 2021 6:48 pm
Reply with quote

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
View user's profile Send private message
sergeyken
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1188

PostPosted: Wed Jul 14, 2021 6:50 pm
Reply with quote

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
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2772
Location: NYC,USA

PostPosted: Wed Jul 14, 2021 7:50 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Sort to include records of file 2 int... Java & MQSeries 1
No new posts define 1 DCB parms for multiple outpu... JCL & VSAM 9
No new posts Converting unpacked fields to pack us... SYNCSORT 4
No new posts SORT for dynamic trailer record + CSV... DFSORT/ICETOOL 14
No new posts SORT HELP - SORT A COLUMN and GROUP B... DFSORT/ICETOOL 9
Search our Forums:

Back to Top