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
 

 

sort conditions combination

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Thu Dec 16, 2010 1:14 am    Post subject: sort conditions combination
Reply with quote

we have 2 sort steps using the same input file-

1st sort step uses sort card -
SORT FIELDS=(1,2,BI,A,3,4,BI,A,10,5,CH,D),EQUALS
SUM FIELDS=NONE,XSUM

2nd Sort step used card OMIT COND=(85,1,CH,EQ,C'E')

Can we combine both the sort steps together like this?
SORT FIELDS=SORT FIELDS=(1,6,BI,A,10,5,CH,D),EQUALS
SUM FIELDS=NONE,XSUM
OMIT COND=(85,1,CH,EQ,C'E')

Interested to know how will it be processed.. What will be the order of processing.Can it cause any impact?

Pls advise.
Back to top
View user's profile Send private message

Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Thu Dec 16, 2010 1:16 am    Post subject: Reply to: sort conditions combination
Reply with quote

Will this improve the performance?
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Thu Dec 16, 2010 7:39 am    Post subject:
Reply with quote

Hi,

OMIT/INCLUDE followed by SORT followed by SUM FIELDS is the order of processing.

Yes, performace will be improved.



Gerry
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Thu Dec 16, 2010 11:05 am    Post subject:
Reply with quote

Quote:
Can it cause any impact?
The contents of SORTXSUM dataset will NOT be the same.
Back to top
View user's profile Send private message
rockish

Active User


Joined: 05 Jun 2009
Posts: 185
Location: Planet Earth

PostPosted: Thu Dec 16, 2010 8:43 pm    Post subject: Re: Reply to: sort conditions combination
Reply with quote

Rijit wrote:
Will this improve the performance?


With no offense meant to the experts in the forum, isn't the best option to test the same and observe the difference in the 'performance' parameters that you wish to measure ?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Thu Dec 16, 2010 10:53 pm    Post subject:
Reply with quote

Performance comparison arises only when the contents of output files are the same.
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Fri Dec 17, 2010 1:26 am    Post subject:
Reply with quote

Rightly commented the duplicate file will be different. The duplicates file is useless so no impacts..and i checked it ran faster combining the sort steps in single card.

But I want the duplicate step to run before the omit cond operation to happen. Is it possible anyway in a single sort card? The reson for this not to retain the original duplicate file but becoz the no of dups eliminated is extremly high compared to the no of records eliminated in the Omit cond operation. So I belive it should improve oerformance.

The no of recs in input file is in billions..and also the clock time is very high like 45 mins for the step to run but the TCB time is only 5 mins..Is it normal?What factors can affect that. both the input and O/P files are on DASD.

Any one would like to suggest on this?
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: Fri Dec 17, 2010 1:29 am    Post subject:
Reply with quote

Hello,

It may help us help you if you post the complete jcl and sort control with all of the changes so far. . .

Please use the "Code" tag.
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Fri Dec 17, 2010 1:34 am    Post subject:
Reply with quote

Hi Dick,
'Code tag', I did nt understand sir icon_rolleyes.gif I dont have the mainframe access at this moment..But it is a simple sort step only 1 input file and 1 O/P file..

Anyways once i get back to my desk I will post the JCL..It is like performance tuning what I am doing.
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: Fri Dec 17, 2010 2:12 am    Post subject:
Reply with quote

Hello,

The Code tag preserves alignment and improves readability:
Code:
//SYSOUT   DD SYSOUT=*                                               
//SYSPRINT DD SYSOUT=*                                               
//SYSUT2   DD SYSOUT=*                                               
//*YSUT2   DD DSN=&&MSSRC,DISP=(,PASS,DELETE),UNIT=SYSDA,           
//*           DCB=(RECFM=FB,LRECL=80,BLKSIZE=16320),                 
//*           SPACE=(TRK,(5,5),RLSE)                                 
//SYSIN    DD DUMMY                                                 
//                                                                   
//*

There is a Preview function so you can see your post as it will appear to the forum (rather than how it appears in the Reply Editor). When the post appears as you wish, Submit.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2158
Location: @my desk

PostPosted: Fri Dec 17, 2010 8:25 am    Post subject:
Reply with quote

If the SORTXSUM file is "useless", why do you need an XSUM!!
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Fri Dec 17, 2010 9:44 am    Post subject:
Reply with quote

I don't know why are they using the duplicate file..But I can see using a tool that the duplicate file is not used in any other production job except my job.

Need to confrirm wid business if they really need that.

Thanks
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: Fri Dec 17, 2010 8:25 pm    Post subject: Reply to: sort conditions combination
Reply with quote

And the "work in process" code/jcl still has not yet been Coded/posted. . . icon_sad.gif

d
Back to top
View user's profile Send private message
Rijit

Active User


Joined: 15 Apr 2010
Posts: 168
Location: Pune

PostPosted: Fri Dec 17, 2010 10:24 pm    Post subject: Re: Reply to: sort conditions combination
Reply with quote

dick scherrer wrote:
And the "work in process" code/jcl still has not yet been Coded/posted. . . icon_sad.gif

d


Dick,

Actually I am on a timeoff away from my workstation..Once I am back I shall post the JCL for sure icon_smile.gif

Thanks
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: Fri Dec 17, 2010 10:38 pm    Post subject: Reply to: sort conditions combination
Reply with quote

Someone will be here when you return - enjoy the time away icon_smile.gif

d
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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