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

Performance tuning in JCL


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
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
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
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: 496
Location: USA

PostPosted: Mon Jun 15, 2009 9:46 pm
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. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts exploiting Z16 performance PL/I & Assembler 2
No new posts JOIN STATEMENT PERFORMANCE. DFSORT/ICETOOL 12
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
No new posts COBOL Performance Tuning COBOL Programming 6
No new posts CICS Performance statistics CICS 3
Search our Forums:

Back to Top