View previous topic :: View next topic
|
Author |
Message |
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
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 |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
Will this improve the performance? |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
OMIT/INCLUDE followed by SORT followed by SUM FIELDS is the order of processing.
Yes, performace will be improved.
Gerry |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
Can it cause any impact? |
The contents of SORTXSUM dataset will NOT be the same. |
|
Back to top |
|
|
rockish
Active User
Joined: 05 Jun 2009 Posts: 185 Location: Planet Earth
|
|
|
|
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 |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Performance comparison arises only when the contents of output files are the same. |
|
Back to top |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
Hi Dick,
'Code tag', I did nt understand sir 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
If the SORTXSUM file is "useless", why do you need an XSUM!! |
|
Back to top |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
And the "work in process" code/jcl still has not yet been Coded/posted. . .
d |
|
Back to top |
|
|
Rijit
Active User
Joined: 15 Apr 2010 Posts: 168 Location: Pune
|
|
|
|
dick scherrer wrote: |
And the "work in process" code/jcl still has not yet been Coded/posted. . .
d |
Dick,
Actually I am on a timeoff away from my workstation..Once I am back I shall post the JCL for sure
Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Someone will be here when you return - enjoy the time away
d |
|
Back to top |
|
|
|