My thought exactly. Apparently it does... which, as Charles Mills correctly says, the rest of the fields should be part of the sort key or they should use EQUALS.
Regards and thanks Paul -----Original Message----- From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Cameron Conacher Sent: Thursday, October 25, 2018 5:37 PM To: [email protected] Subject: Re: SORT not behaving consistently So are you saying that the order of records with identical keys is different machine to machine? Does that matter? Sent from my iPhone > On Oct 25, 2018, at 12:23 PM, Beesley, Paul <[email protected]> wrote: > > Hi > > Have been asked to investigate reasons for an identical DFSORT behaving > differently on 2 machines. > We are transitioning a service which is currently on a zEC12 to a z14 > machine, and the disks are currently HP9500, moving to IBM DS8886. > When they run sort of multi-thousand records on the old machine, and then > running the identical sort against identical data on the new setup, they get > several records in a different order. > Seems they are sorting on the first 21 characters or so, and it is doing that > fine, but the order of the records beyond that is a bit random, whereas on > the new system they are in the same order as the input. > On the new system it's almost like EQUALS is coded, but it's not. > Hope that makes sense. > Any ideas what would cause this (repeatable) difference in the outcome ... > faster machine? Faster disks? > Paul > > Atos, Atos Consulting, Worldline and Canopy The Open Cloud Company are > trading names used by the Atos group. The following trading entities are > registered in England and Wales: Atos IT Services UK Limited (registered > number 01245534), Atos Consulting Limited (registered number 04312380), Atos > Worldline UK Limited (registered number 08514184) and Canopy The Open Cloud > Company Limited (registration number 08011902). The registered office for > each is at Second Floor, Mid City Place, 71 High Holborn, London, WC1V 6EA. > The VAT No. for each is: GB232327983. > > This e-mail and the documents attached are confidential and intended solely > for the addressee, and may contain confidential or privileged information. If > you receive this e-mail in error, you are not authorised to copy, disclose, > use or retain it. Please notify the sender immediately and delete this email > from your systems. As emails may be intercepted, amended or lost, they are > not secure. Atos therefore can accept no liability for any errors or their > content. Although Atos endeavours to maintain a virus-free network, we do not > warrant that this transmission is virus-free and can accept no liability for > any damages resulting from any virus transmitted. The risks are deemed to be > accepted by everyone who communicates with Atos by email. > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN Atos, Atos Consulting, Worldline and Canopy The Open Cloud Company are trading names used by the Atos group. The following trading entities are registered in England and Wales: Atos IT Services UK Limited (registered number 01245534), Atos Consulting Limited (registered number 04312380), Atos Worldline UK Limited (registered number 08514184) and Canopy The Open Cloud Company Limited (registration number 08011902). The registered office for each is at Second Floor, Mid City Place, 71 High Holborn, London, WC1V 6EA. The VAT No. for each is: GB232327983. This e-mail and the documents attached are confidential and intended solely for the addressee, and may contain confidential or privileged information. If you receive this e-mail in error, you are not authorised to copy, disclose, use or retain it. Please notify the sender immediately and delete this email from your systems. As emails may be intercepted, amended or lost, they are not secure. Atos therefore can accept no liability for any errors or their content. Although Atos endeavours to maintain a virus-free network, we do not warrant that this transmission is virus-free and can accept no liability for any damages resulting from any virus transmitted. The risks are deemed to be accepted by everyone who communicates with Atos by email. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
