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

Performance improvement of the DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Feb 19, 2013 12:48 pm
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Feb 19, 2013 12:49 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts exploiting Z16 performance PL/I & Assembler 2
Search our Forums:

Back to Top