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

EXEC SORT,REGION=0M,PARM=ELAP


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

New User


Joined: 10 Jun 2010
Posts: 2
Location: Bangalore

PostPosted: Wed May 20, 2015 12:45 pm
Reply with quote

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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Wed May 20, 2015 2:02 pm
Reply with quote

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

Global Moderator


Joined: 28 Aug 2007
Posts: 1689
Location: Tiruppur, India

PostPosted: Wed May 20, 2015 2:05 pm
Reply with quote

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
View user's profile Send private message
venugopal.mft

New User


Joined: 10 Jun 2010
Posts: 2
Location: Bangalore

PostPosted: Wed May 20, 2015 7:20 pm
Reply with quote

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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Wed May 20, 2015 7:54 pm
Reply with quote

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
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
No new posts Determine Library REXX exec was execu... CLIST & REXX 7
No new posts Building a sort key DFSORT/ICETOOL 3
No new posts Very Large Sort failed - Seeking reco... DFSORT/ICETOOL 7
No new posts Date conversion using SORT SYNCSORT 4
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
Search our Forums:

Back to Top