Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Options in SYNCSORT which will optimise the CPU usage

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
nynali

New User


Joined: 08 May 2007
Posts: 13
Location: Hyderabad

PostPosted: Fri Sep 07, 2007 3:55 pm    Post subject: Options in SYNCSORT which will optimise the CPU usage
Reply with quote

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.
Back to top
View user's profile Send private message

Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1288
Location: Chennai, India

PostPosted: Fri Sep 07, 2007 5:14 pm    Post subject: Reply to: Options in DFSORT which will optimise the CPU usag
Reply with quote

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.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Sep 07, 2007 8:36 pm    Post subject:
Reply with quote

Quote:
I want to know some options in DFSORT which will optimise the CPU usage time


Here are some things that might help:

- Use large block sizes for the input and output data sets
- Ensure that sufficient virtual storage is available - ensure DSA=0 is not in effect - increase the DSA=n value, if appropriate
- Use the INCLUDE or OMIT statement to remove records before sorting, if appropriate
- If you don't need the entire record for output, use INREC to shorten the records before sorting
- Use built-in DFSORT functions rather than user exits, if appropriate
Back to top
View user's profile Send private message
nynali

New User


Joined: 08 May 2007
Posts: 13
Location: Hyderabad

PostPosted: Mon Sep 10, 2007 5:22 pm    Post subject:
Reply with quote

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??
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Mon Sep 10, 2007 8:54 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
nynali

New User


Joined: 08 May 2007
Posts: 13
Location: Hyderabad

PostPosted: Tue Sep 11, 2007 1:34 pm    Post subject:
Reply with quote

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?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Sep 11, 2007 8:31 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 11, 2007 8:42 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Wed Sep 12, 2007 12:31 am    Post subject:
Reply with quote

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,
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 5 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us