View previous topic :: View next topic
|
Author |
Message |
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 |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Are you sure you have DFSORT?
DFSORT Application Programming Guide wrote: |
DFSORT accepts but does not process the following EXEC/DFSPARM PARM
options: ... ELAP, ... |
If you do have DFSORT, contact them through your Support and they will be happy to assist with advice to improve performance.
If you don't have DFSORT, how do you think improving the ELAPsed time would reduce the CPU time (consistently)? Again, contact (presumably) SyncSORT for advice which they will be willing to supply to you. |
|
Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007 Posts: 1742 Location: Tirupur, India
|
|
|
|
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. |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
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. |
|
Back to top |
|
|
|