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
 

 

Syncsort Step taking more time ..want to tune

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

Active User


Joined: 24 May 2013
Posts: 129
Location: INDIA

PostPosted: Tue Jul 23, 2013 12:50 pm    Post subject: Syncsort Step taking more time ..want to tune
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

Active Member


Joined: 07 Feb 2009
Posts: 982
Location: Oostende, Belgium

PostPosted: Tue Jul 23, 2013 1:36 pm    Post subject:
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: 2158
Location: @my desk

PostPosted: Tue Jul 23, 2013 2:15 pm    Post subject:
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: 1714
Location: UK

PostPosted: Tue Jul 23, 2013 2:43 pm    Post subject:
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: 129
Location: INDIA

PostPosted: Tue Jul 23, 2013 3:11 pm    Post subject:
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: 1714
Location: UK

PostPosted: Tue Jul 23, 2013 7:02 pm    Post subject:
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: 7908
Location: Bellevue, IA

PostPosted: Tue Jul 23, 2013 7:13 pm    Post subject:
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

Site Director


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

PostPosted: Tue Jul 23, 2013 9:16 pm    Post subject:
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

Senior Member


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

PostPosted: Tue Jul 23, 2013 9:59 pm    Post subject:
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: 129
Location: INDIA

PostPosted: Wed Jul 24, 2013 2:14 pm    Post subject:
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: 2158
Location: @my desk

PostPosted: Wed Jul 24, 2013 2:16 pm    Post subject:
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: 129
Location: INDIA

PostPosted: Wed Jul 24, 2013 2:20 pm    Post subject:
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    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 syncsort: copy lines after the keyword shreya19 SYNCSORT 6 Fri Dec 02, 2016 9:47 am
This topic is locked: you cannot edit posts or make replies. Get a job submitted itself every time... arunsoods JCL & VSAM 3 Tue Nov 22, 2016 4:05 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm


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