Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Performance improvement of the DFSORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
mishra

New User


Joined: 21 Feb 2007
Posts: 3
Location: india

PostPosted: Tue Feb 19, 2013 12:28 pm    Post subject: Performance improvement of the DFSORT
Reply with quote

Require to sort 6 variable length input files (of LRECL=10004) and split it into 24 output files of (LRECL=10004). Also note that the input file is having a huge volume of data.

The sort card we use is as follows:
SYSIN :
Code:
 SORT FIELDS=COPY
 OUTFIL FILES=01,
 INCLUDE=(14,9,ZD,GE,000000000,AND,14,9,ZD,LE,012050607)
 OUTFIL FILES=02,
 INCLUDE=(14,9,ZD,GE,012050608,AND,14,9,ZD,LE,014166563)
 OUTFIL FILES=03,
 INCLUDE=(14,9,ZD,GE,014166564,AND,14,9,ZD,LE,016091718)
 OUTFIL FILES=04,
 INCLUDE=(14,9,ZD,GE,016091719,AND,14,9,ZD,LE,022050993)
 OUTFIL FILES=05,
 INCLUDE=(14,9,ZD,GE,022050994,AND,14,9,ZD,LE,026011858)
 OUTFIL FILES=06,
 INCLUDE=(14,9,ZD,GE,026011859,AND,14,9,ZD,LE,031057945)
 OUTFIL FILES=07,
INCLUDE=(14,9,ZD,GE,031057946,AND,14,9,ZD,LE,033135740)
OUTFIL FILES=08,
INCLUDE=(14,9,ZD,GE,033135741,AND,14,9,ZD,LE,040020314)
OUTFIL FILES=09,
INCLUDE=(14,9,ZD,GE,040020315,AND,14,9,ZD,LE,046020577)
OUTFIL FILES=10,
INCLUDE=(14,9,ZD,GE,046020578,AND,14,9,ZD,LE,052061168)
OUTFIL FILES=11,
INCLUDE=(14,9,ZD,GE,052061169,AND,14,9,ZD,LE,054243904)
OUTFIL FILES=12,
INCLUDE=(14,9,ZD,GE,054243905,AND,14,9,ZD,LE,059011853)
OUTFIL FILES=13,
INCLUDE=(14,9,ZD,GE,059011854,AND,14,9,ZD,LE,063011296)
OUTFIL FILES=14,
INCLUDE=(14,9,ZD,GE,063011297,AND,14,9,ZD,LE,068030052)
OUTFIL FILES=15,
INCLUDE=(14,9,ZD,GE,068030053,AND,14,9,ZD,LE,076140837)
OUTFIL FILES=16,
 INCLUDE=(14,9,ZD,GE,076140838,AND,14,9,ZD,LE,083061355)
 OUTFIL FILES=17,
 INCLUDE=(14,9,ZD,GE,083061356,AND,14,9,ZD,LE,090011828)
 OUTFIL FILES=18,
 INCLUDE=(14,9,ZD,GE,090011829,AND,14,9,ZD,LE,096011946)
 OUTFIL FILES=19,
 INCLUDE=(14,9,ZD,GE,096011947,AND,14,9,ZD,LE,204070595)
 OUTFIL FILES=20,
 INCLUDE=(14,9,ZD,GE,204070596,AND,14,9,ZD,LE,211010053)
 OUTFIL FILES=21,
 INCLUDE=(14,9,ZD,GE,211010054,AND,14,9,ZD,LE,215030637)
 OUTFIL FILES=22,
 INCLUDE=(14,9,ZD,GE,215030638,AND,14,9,ZD,LE,238015142)
 OUTFIL FILES=23,
 INCLUDE=(14,9,ZD,GE,238015143,AND,14,9,ZD,LE,261120413)
 OUTFIL FILES=24,
 INCLUDE=(14,9,ZD,GE,261120414,AND,14,9,ZD,LE,999999999)


The sort card pasted above is a dynamically created sort card.

The sort utility which we use is SORT45GB.This utility does the dynamic allocation of the work space based on the input file size. The workspace is allocated will be 1.3 times of the input file size.

The issue we face is this step alone is taking 55 minutes , due to which the performance of the job is degraded. Is there anyway we can improve the performance.

Code'd
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Tue Feb 19, 2013 12:48 pm    Post subject: Reply to: Performance improvement of the DFSORT
Reply with quote

Can you post the SYSOUT from an execution of this step please? Is your "utility" a catalogued procedure, which then contains EXEC PGM=SORT?

You have "OPTION COPY". The step will not use any workspace for a COPY operation.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10535
Location: italy

PostPosted: Tue Feb 19, 2013 12:49 pm    Post subject: Reply to: Performance improvement of the DFSORT
Reply with quote

Quote:
The sort utility which we use is SORT45GB.This utility does the dynamic allocation of the work space based on the input file size.


the name of the <utility> You cited is not a vanilla IBM term,
not even a known term on the NET, googling for it gives... 0 HITS
if it is something specific to Your organization, the chances of getting help on a forum are pretty small

anyway why allocate work space for a COPY operation

post the result You get when running

Code:
//S1 EXEC PGM=ICEMAN
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*


so that we can see what <SORT> product You are using and the functions available
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to count the number of times key ... vnktrrd DFSORT/ICETOOL 13 Thu Nov 15, 2018 9:19 pm
This topic is locked: you cannot edit posts or make replies. DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 3 Tue Nov 13, 2018 7:55 pm
No new posts Generate and submit JCL and step dyna... vnktrrd DFSORT/ICETOOL 11 Wed Jul 25, 2018 11:31 pm
No new posts How to Count a particular record in a... Mounika Nemani DFSORT/ICETOOL 5 Tue May 29, 2018 1:07 pm
No new posts Need urgent suggestion on DFSORT subratarec DFSORT/ICETOOL 6 Wed Mar 21, 2018 8:46 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us