Options in SYNCSORT which will optimise the CPU usage

nynali · New User Joined: 08 May 2007 Posts: 13 Location: Hyderabad

Hi,
I want to know some options in SYNCSORT which will optimise the CPU usage time and hence reduce the dollar cost of the job.

Aaru · Posted: Fri Sep 07, 2007 5:14 pm

Proper use of INCLUDE/OMIT (for removing the unwanted records) and INREC/OUTREC can increase the speed of the SORT thereby decreasing the CPU time.

I cannot think of any options as such.

Frank Yaeger · Posted: Fri Sep 07, 2007 8:36 pm

nynali · New User Joined: 08 May 2007 Posts: 13 Location: Hyderabad

I have SORT job which does sorting and removing duplicates based on 4 keys.
There will be approximately 110,000,000 records in the input and the LRECL of the i/p file is 74 bytes.The options that were given for the SORT job are
PARM='VSCORET=40M',REGION=48M,FILSZ=E105000000

The actual FILESIZE is 8,052,395,174 BYTES.Also the sorting is taking around 22 SORTWK datasets.Going by the above options is there any way to improve the performance in terms of CPU time??

Frank Yaeger · Posted: Mon Sep 10, 2007 8:54 pm

nynali,

The way the PARM is specified, FILSZ=E105000000 will not be used since its not actually passed within the PARM parameters. I can't tell whether you actually need the FILSZ parameter based on what you've shown.

If you want me to comment further, you'll need to rerun your job with the following added:

//SORTDIAG DD DUMMY

Then send me the //SYSOUT messages offline (yaeger@us.ibm.com). Put DFSORT somewhere in your Subject line to catch my attention.

nynali · New User Joined: 08 May 2007 Posts: 13 Location: Hyderabad

Frank,
You are correct The FILESZ parameter is being given in the SORT CARD in the SYSIN.
Can u please let me know what more information is needed to decide upon optimization of the mentioned SORT job in last post?

Frank Yaeger · Posted: Tue Sep 11, 2007 8:31 pm

I received the information you sent me offline. However, the WER messages indicate you're using Syncsort, not DFSORT. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

I'm moving this thread to the JCL Forum.

dick scherrer · Posted: Tue Sep 11, 2007 8:42 pm

Hello,

How large was the information you sent to Frank?

If it is not large and you post the the information you sent to Frank offline, someone here may be able to help.

Alissa Margulies · Posted: Wed Sep 12, 2007 12:31 am

nynali,

Feel free to email me your complete job listing as a text attachment to alissa.margulies@syncsort.com and I'd be happy to help you tune your application.

Regards,