While analyzing high CPU consuming jobs we came across a peculiar behavior of 
SYNCSORT. Certain SYNCSORT steps in some of the jobs are *regularly* (not just 
occasionally) taking much more time than some of the other SYNCSORT steps in 
the same jobs with same amount of data.  For example, in one job a file is 
sorted in certain order and after enrichment by an application program is 
sorted back into the original order. The first SYNCSORT takes 96 seconds of CPU 
time while the second SYNCSORT takes only 8 seconds. There is no difference in 
the parameters given via PARM and/or SYSIN. This kind of processing is done 
multiple times in many application jobs, so if there is anything we could do to 
reduce the time taken by the first SYNCSORT we would be very interested in 
doing whatever it takes.

Can anyone suggest why there should be such a disparity in observed CPU timings 
for SYNCSORT?  Or what SYNCSORT parameters might be worth investigating to 
reduce the initial SYNCSORT CPU time?

TIA for any helping to cure my ignorance.

Peter



Example SYNCSORT CPU timings

DATE : 08/15/2013

STEP NAME   RECORD COUNT   CPU TIME
SORT10      6547982        01 MIN  28.64 SEC
SORT20      6547981        05.35 SEC

DATE : 08/16/2013

STEP NAME   RECORD COUNT   CPU TIME
SORT10      6551104        01 MIN  36.83 SEC
SORT20      6551103        08.02 SEC

--

This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.

----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN

Reply via email to