Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

mismatch of records using DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Tue Mar 28, 2006 10:37 am    Post subject: mismatch of records using DFSORT
Reply with quote

I have a same sort step in two different LPAR regions in mainframe. Sort step has the same input files(i.e. data is same in both the files) but the output file is giving the difference. Sort fields are same in both the SORT step.

Difference is the placement of records if there is duplicates in the sort field.

I would like to know whether the SORT behaves differently in different LPAR regions. If not, why the difference is coming in the Output file even if the input file & sort fields are same in both the regions?
Back to top
View user's profile Send private message

Alain Benveniste

New User


Joined: 14 Feb 2005
Posts: 88

PostPosted: Tue Mar 28, 2006 11:06 am    Post subject:
Reply with quote

Could you post your JCL and how your records look like ?

Alain
Back to top
View user's profile Send private message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Tue Mar 28, 2006 11:33 am    Post subject: Re: mismatch of records using DFSORT
Reply with quote

JCL:
Code:
//STEP1  EXEC PGM=SORT                                               
//SYSOUT     DD SYSOUT=*                                                 
//SYSUDUMP DD SYSOUT=*                                                 
//SYSPRINT   DD SYSOUT=*                                                 
//SORTIN      DD DISP=SHR,DSN=INFILE                 
//SORTOUT   DD DSN=OUTFILE,
//                 DISP=(,CATLG,DELETE),   
//                 UNIT=DASD,SPACE=(CYL,(50,50),RLSE)                       
//SYSIN        DD *
 SORT FIELDS=(51,20,CH,A)
/*


For Example:
Record # 12 in outfile of LPAR1 region is placed as record # 13 in outfile of LPAR2 region and viceversa. This misplacement of records happens randomly when there is duplicates in the sort fields.
Back to top
View user's profile Send private message
Alain Benveniste

New User


Joined: 14 Feb 2005
Posts: 88

PostPosted: Tue Mar 28, 2006 3:28 pm    Post subject:
Reply with quote

Ok,
I think your problem comes from the EQUALS=YES option which is coded in one of the LPAR and not in the other.

Alain
Back to top
View user's profile Send private message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Tue Mar 28, 2006 4:53 pm    Post subject: Re: mismatch of records using DFSORT
Reply with quote

The sort step is same in both the LPAR regions.
could you please tell me where to find the "EQUAL=YES" option located.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Mar 28, 2006 8:54 pm    Post subject:
Reply with quote

When your System Programmers installed DFSORT, they specified (or defaulted) a set of installation options. EQUALS is one of these options and can be set to YES or NO.

I would guess that Alain is right that one of your LPARs has EQUALS=YES as the installation option and the other has EQUALS=NO. You can ensure that the job runs the same in both LPARS by adding the EQUALS run-time option to the job:

Code:

//DFSPARM DD *
  OPTION EQUALS
/*


You can read all about DFSORT's installation options in "z/OS DFSORT Installation and Customization" which you can access, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
mano

New User


Joined: 23 Mar 2006
Posts: 17
Location: chennai

PostPosted: Thu Mar 30, 2006 11:57 am    Post subject: Re: mismatch of records using DFSORT
Reply with quote

No,
the EQUALS option is NO in both the regions.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Mar 30, 2006 9:52 pm    Post subject:
Reply with quote

NOEQUALS in both regions can do it too.

With NOEQUALS, the order of duplicate records is unpredictable (NOEQUALS says that the duplicate records can be in any order) so they can be ordered in one way in one region and in another way in another region. If you want to guarantee that the duplicate records always come out in the same order, you need to use EQUALS in both regions (EQUALS says that the duplicate records must be in their original order).

As I said, you can add the following to the job wherever it runs:

Code:

//DFSPARM DD *
  OPTION EQUALS
/*
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us