EXEC SORT,REGION=0M,PARM=ELAP

venugopal.mft · New User Joined: 10 Jun 2010 Posts: 2 Location: Bangalore

Hi,
I am working on MIPS reduction on Mainframe.
I have 750 million records to be sorted. The existing sort card in production was like this
EXEC SORT,CORE=MAX,REGION= 0K ---> it was taking 11 to 12 CPU seconds to complete the sort.

I have tested the below sort cards for 4 times as part of Unit testing.
EXEC SORT,REGION=0M,PARM=ELAP -->took around 6 CPU secs
EXEC SORT,REGION=0M,PARM=CPU --> took 11 CPU secs

But when(PARM=ELAP) implemented in production, it is taking 11 CPU secs.

Please let me know if there is any means to reduce the MIPS for the above amount of data.

Regards,
Venugopal

Bill Woodger · Posted: Wed May 20, 2015 2:02 pm

Are you sure you have DFSORT?

vasanthz · Posted: Wed May 20, 2015 2:05 pm

What SORT product do you have? Is it DFSORT or SYNCSORT or CA-SORT or any other?

BTW. MIPS is not a terminology that could be used for a job. You could reduce service units consumed by the job / you could reduce TCB time & maybe SRB time sometimes.

venugopal.mft · New User Joined: 10 Jun 2010 Posts: 2 Location: Bangalore

Hi,
It is DFSORT using ICEMAN utility.
I have tested it several runs with PARM=ELAP and PARM=CPU.

All the times PARM=ELAP took half the time

REgards,
Venugopal

Bill Woodger · Posted: Wed May 20, 2015 7:54 pm

Take it up with DFSORT. You pay for support. Leave out the bit about ELAP, just say you've got a big sort you'd like to reduce the use of resources on.