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
 

 

CPU cost with differnt SORT cards?

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

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Jan 30, 2008 7:38 pm    Post subject: CPU cost with differnt SORT cards?
Reply with quote

Hi,

If I use these two different SORT cards on a single data set...
Code:
SORT FIELDS=(01,10,CH,A,
             11,10,CH,A,
             21,08,CH,A,
             29,02,CH,A)


After modification :
Code:
SORT FIELDS=(01,30,CH,A)


Does that make any difference in CPU cost of JOB?


P.S.: I tried to test it but with a small data it does not show really a difference. But here at my work place a debate is going on that 'it might'
...please suggest. My shop uses Syncsort, but I think this functionality should be same irrespective of SORT product so post is in DFSORT forum.
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: Wed Jan 30, 2008 10:17 pm    Post subject:
Reply with quote

I wouldn't expect it to make any difference for DFSORT as we combine contiguous fields internally when possible as in this case.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 31, 2008 1:30 pm    Post subject:
Reply with quote

Thanks for the confirmation Frank. However, can we've some technical explanation for this instead of running JOBs with these SORT cards & then compairing their respective costs?
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 Jan 31, 2008 10:01 pm    Post subject:
Reply with quote

I don't know what you mean by "some technical explanation". I thought I gave a technical explanation that "we combine contiguous fields internally". What I mean is that the "key" is handled in the same way (as one contiguous 30-byte key) for both SORT statements. Of course, I can only speak for DFSORT whereas you said you're using Syncsort.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 31, 2008 10:04 pm    Post subject:
Reply with quote

Hi Anuj,

A technical answer is in Frank's reply
Quote:
we combine contiguous fields internally when possible as in this case.


Before the actual sorting is started, the code looks at the sort fields and when they are contiguous, it internally creates a single sort field (just like the shorter syntax that was posted), rather than working with 4 (from your example).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Jan 31, 2008 10:32 pm    Post subject:
Reply with quote

Frank Yaeger wrote:
"we combine contiguous fields internally".

I was beaten by the word "we".. I could not corelate it with SORT ..apologies.. "kernal King" .

Quote:
What I mean is that the "key" is handled in the same way (as one contiguous 30-byte key) for both SORT statements. Of course, I can only speak for DFSORT whereas you said you're using Syncsort.

Thanks for explaing again, got it now.


Thankyou Dick, I got the answer now to deal with my counter parts at my work place.. icon_smile.gif . Let see what they have in store to say now...
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Feb 05, 2008 10:52 pm    Post subject: Reply to: CPU cost with differnt SORT cards?
Reply with quote

Anuj,

In the example you provided, you should not see any difference in CPU usage in SyncSort either.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Feb 05, 2008 11:20 pm    Post subject:
Reply with quote

Thankyou Alissa for confirming.. icon_smile.gif
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 How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


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