Performance tunning for SYNCSORT



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Performance tunning for SYNCSORT

Postby anand4u237 » Tue Jul 30, 2013 7:55 pm

Hello,

Can anybody please let me know where do i can find any document for improving the syncsort performance. I have been browsing thru forums i did find some
post that helped me, but can anybody throw me a light where do i start frist.

I ran a job with B message , this is what i found


6,904K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
0 BYTES RESERVE REQUESTED, 6,096K BYTES USED
12K BYTES OF EMERGENCY SPACE ALLOCATED
SORTIN : RECFM=VB ; LRECL= 504; BLKSIZE= 32760
5,876K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
0 BYTES RESERVE REQUESTED, 5,860K BYTES USED

Thanks
Anand
anand4u237
 
Posts: 15
Joined: Mon May 17, 2010 12:05 pm
Location: India
Has thanked: 4 times
Been thanked: 0 time

Re: Performance tunning for SYNCSORT

Postby BillyBoyo » Tue Jul 30, 2013 10:04 pm

There is nothing useful there. Can you post the full sysout from the step? Why do you think it needs tuning?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Performance tunning for SYNCSORT

Postby Robert Sample » Tue Jul 30, 2013 10:34 pm

In general, you will be able to impact sort performance only slightly no matter what you do. The sort products are already highly optimized. Ensure you have plenty of memory (the short snippet you posted implied a lack of memory), plenty of sort work space, and your sort performance will be pretty much as good as you're going to get.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: Performance tunning for SYNCSORT

Postby steve-myers » Wed Jul 31, 2013 12:20 am

Mmmm

This section is for DFSORT, not SYNCSORT. In any event, Mr. Sample's observations are probably as good as you're going to get, regardless of whether you're running DFSORT or SYNCSORT. I'm far from a sorting expert, but
  1. Keep the number of keys to a minimum.
  2. Do not, if possible, specify packed decimal keys.
  3. Specify the number of records as close to the actual number of records as possible.
Last edited by steve-myers on Wed Jul 31, 2013 12:22 am, edited 1 time in total.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Performance tunning for SYNCSORT

Postby dick scherrer » Wed Jul 31, 2013 12:20 am

Hello,

One way to reduce the runtime is to make sure that only needed data fields are being sorted. Many times an entire file is sorted when only a few fields from each record and only some of the records need to be sorted.

You may not have control over the input, but possibly improving the input blksize can help. Same with the output - make sure that a proper blksize is used.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Performance tunning for SYNCSORT

Postby jaggz » Tue Aug 06, 2013 8:08 pm

Hello,

What version of Syncsort ? Whats the Z/OS version ? MFX manual for programmers has lots of pointers related to Performance like passing BMSG or GMSG, Usage of Virtual Storage etc..

Jaggz
User avatar
jaggz
 
Posts: 356
Joined: Fri Jul 23, 2010 8:51 pm
Has thanked: 8 times
Been thanked: 5 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post