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
 

 

Performance tuning in JCL

 
Post new topic   This topic is locked: you cannot edit posts or make replies.    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
r23051984

New User


Joined: 24 May 2009
Posts: 10
Location: chennai

PostPosted: Mon Jun 15, 2009 12:06 pm    Post subject: Performance tuning in JCL
Reply with quote

hi all,

I am using the below JCL for..

a) Sorting the input files,

b) Skipping the first record which is always header

c) formatting and outrec the necessary fields.

d) writing the output to the file

e) Removing the duplicates

This particular Sort step is taking more than 4 hours to complete, my Input file details

LRECL = 126
RECFM = FB
Total counts = 145601566

Is there any other way to reduce the steps (inside the Sysin statement) to tune the performance..

Code:
//SYSIN   DD *                                                       
  SORT FIELDS=(100,9,CH,A,109,4,CH,A,113,11,CH,A),                   
  SKIPREC=1,STOPAFT=145601566                                         
  OUTREC FIELDS=(1:1,06,PD,EDIT=(TTTTTTTTTTT),12:7,2,BI,EDIT=(TTTT), 
           16:9,3,19:12,21,40:33,4,44:37,4,48:41,2,BI,EDIT=(TTTT),   
           52:43,1,53:44,30,83:74,26,109:100,09,118:109,04,           
           122:113,11,133:124,03)                                     
  OUTFIL FNAMES=SORTOUT                                               
  SUM FIELDS=NONE,XSUM                                               
/*
Back to top
View user's profile Send private message

deepuvja

New User


Joined: 06 Mar 2008
Posts: 5
Location: chennai

PostPosted: Mon Jun 15, 2009 9:01 pm    Post subject: Re:Performance - JCL
Reply with quote

can you give the syout for this sort?

So that we can check for the options in place

and also you can try with increasing the temporary file sizes SORTWK01 and using multiple temporary files to make the sort a quicker one
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Jun 15, 2009 9:46 pm    Post subject:
Reply with quote

This is a duplicate post to another forum. Please do not post the same question in multiple forums. Thank you.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies.    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 BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am
No new posts PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts What are the way we can improve CPU p... Gunapala CN DB2 10 Mon Oct 24, 2016 2:16 pm
No new posts DISP=(SHR,PASS) performance opinion steve-myers JCL & VSAM 1 Wed Dec 02, 2015 11:53 pm
No new posts Performance tuning of Online system bipinpeter All Other Mainframe Topics 2 Thu Nov 26, 2015 2:29 pm


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