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
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: 1285
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: 2455
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: 2455
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: 8651
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: 19244
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: 6250
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 Evaluate variable to execute a jcl step JCL & VSAM 3
No new posts how to send 10 rows at a time to output CICS 2
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts pass data as symbolic parameter from ... CLIST & REXX 2
No new posts is there a way to print time in HH:MM... SYNCSORT 12
Search our Forums:

Back to Top