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: 7315

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
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 Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts CONTIG for performance? JPVRoff JCL & VSAM 8 Fri Jun 09, 2017 8:39 am
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts BC, BCR, BRC, BRCL performance steve-myers PL/I & Assembler 0 Fri Dec 23, 2016 7:44 am

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