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

Syncsort Step taking more time ..want to tune
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA
PostPosted: Tue Jul 23, 2013 12:50 pm
 Reply with quote
Hi All,

Need your help in below scenario !!

I have a job runing daily in the system .. job is taking 10 mins at below sort step

Code:
PS010  EXEC  PGM=SORT                                             
//SORTLIB  DD  DSN=SORTLIB,DISP=SHR                             
//SYSPRINT DD  SYSOUT=*                                             
//SYSOUT   DD  SYSOUT=*                                             
//SORTIN   DD  DISP=SHR,DSN=&MODE..&SRCCUR.&GDG0
//         DD  DISP=SHR,DSN=&MODE..&SRCCUR1.&GDG0
//         DD  DISP=SHR,DSN=&MODE..&SRCCUR2.&GDG0
//         DD  DISP=SHR,DSN=&MODE..&SRCCUR3.&GDG0
//SORTOUT  DD  DSN=&MODE..SBO01T00.SRCCUR.&JOBNOD,     
//             DISP=(NEW,CATLG,DELETE),                 
//             UNIT=&UNIT1,                             
//             SPACE=&SPACE,                           
//             DCB=(MODEL,RECFM=FB,LRECL=1600,BLKSIZE=0)
//SORTWK01 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK02 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK03 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK04 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK05 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK06 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE)
//SORTWK07 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE) 
//SORTWK08 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE) 
//SORTWK09 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE) 
//SORTWK10 DD  UNIT=&UNIT1,SPACE=(CYL,(1000,1000),RLSE) 
//SYSIN    DD  *

SORT FIELDS=(8,20,CH,A,313,8,CH,A,387,6,PD,A)
//*



Input records are almost 35000000 each day .. I was wondering if can tune this step by anyway..

Please provide your inputs on this .. Many thanks in advance !!!
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1315
Location: Vilnius, Lithuania
PostPosted: Tue Jul 23, 2013 1:36 pm
 Reply with quote
Sort all input files when they are created and do a merge in this procedure.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
PostPosted: Tue Jul 23, 2013 2:15 pm
 Reply with quote
Quote:
job is taking 10 mins at below sort step
Is this the elapsed time? If so, what about the CPU mins?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
PostPosted: Tue Jul 23, 2013 2:43 pm
 Reply with quote
Why are yuou specifying a MODEL DCB when you are not creating a GDG? Why are you specify DCB at all? Why are you specifying SORTWK?
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA
PostPosted: Tue Jul 23, 2013 3:11 pm
 Reply with quote
Elapsed time is -11.09
CPU mins are -1.455

SORT work files are added when the job was created I am not sure if they are the reason of long run.. PLease sugegst

we are using DCB because creating a new output file with diffrent rules than input file.

Thanks
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
PostPosted: Tue Jul 23, 2013 7:02 pm
 Reply with quote
Sort will create the file with the correct DCB information for you. As to the sort work files - try running with dynamc allocation and compare the results. There may be no difference but sort will allocated only what it needs. It would also help if you give sort the estimated number of records to be processed.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
PostPosted: Tue Jul 23, 2013 7:13 pm
 Reply with quote
10 minutes elapsed time to sort 35 million 1600-byte records does not sound too bad. You will find as you progress in your career that you cannot do much tuning on sort -- whether you are using DFSORT or SyncSort or another sort package, they are typically pretty much tuned by the vendor. Some changes, such as dynamic allocation instead of coding SORTWK files, may help somewhat but you're not going to make a few changes and cut 90% of the elapsed time out of the sort.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
PostPosted: Tue Jul 23, 2013 9:16 pm
 Reply with quote
Hello,

Why does someone believe that 10 minutes elapsed time is "too much"?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India
PostPosted: Tue Jul 23, 2013 9:59 pm
 Reply with quote
dick scherrer wrote:
Why does someone believe that 10 minutes elapsed time is "too much"?
Ditto, specially when the number of records involved in are 35M+...
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA
PostPosted: Wed Jul 24, 2013 2:14 pm
 Reply with quote
Ok..Thanks all for your inputs !!..
I will leave this job as is then and move forward to see some other opportunity for batch run tyime reduction.. Thanks
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
PostPosted: Wed Jul 24, 2013 2:16 pm
 Reply with quote
Quote:
move forward to see some other opportunity for batch run tyime reduction
Yes, the ones which are running for hours icon_smile.gif
Back to top
View user's profile Send private message
thesumitk

Active User


Joined: 24 May 2013
Posts: 156
Location: INDIA
PostPosted: Wed Jul 24, 2013 2:20 pm
 Reply with quote
icon_smile.gif 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Syncsort help SYNCSORT 3
No new posts SYNCSORT-DB2 interface SYNCSORT 0
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts To get the the current time DFSORT/ICETOOL 13
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us