Need Syncsort Tuning Techniques Document

chandramouliravi · New User Joined: 27 Apr 2009 Posts: 26 Location: addison

Hi all,

My application uses Syncsort ver 1.3.0.2R.

I am looking to reduce run time of SORTs which involve sorting huge number of records. If there is any document which has Syncsort tuning techniques which has improved performace, please share it. I could not locate any such document in the web.

As i see in the forum, i could locate few techniques and trying to use and check the results. But any doc which involves these techniques would
be more helpful. I am not yet familiar what all can be achieved by giving
performance options.

Thanks,
Chandra mouli

Alissa Margulies · Posted: Tue Dec 01, 2009 4:28 am

Tuning SyncSort is usually application specific. If you would like assistance tuning particular sort steps, please feel free to contact me offline at alissa.margulies@syncsort.com with the complete job listing as a text attachment. Please be sure that 'B' messages are enabled. If you are not sure if they are, you can add the following to the sort step(s) in question:

Alissa Margulies · Posted: Thu Dec 03, 2009 10:01 pm

If you do not have specific questions, but would simply like a general overview, you can start by reviewing the Performance Considerations in Chapter 12 of the SyncSort for z/OS 1.3 Programmer's Guide.

PeterHolland · Posted: Thu Dec 03, 2009 10:27 pm

For variable record length files you could use HISTOGRM to see how your records are distributed. And accordingly use the L6 and L7 parameters.

chandramouliravi · New User Joined: 27 Apr 2009 Posts: 26 Location: addison

Hi all,

Thanks all. I guess i can get starte with the information you gave me.
Thanks for your help again.

Chandramouli

Ajay Baghel · Posted: Sat Dec 05, 2009 6:51 pm

Hi Alissa,

Alissa Margulies · Posted: Mon Dec 07, 2009 9:57 pm

'B' messages are one of the types of SyncSort messages that can be issued. The message type is determined by the character at the end of the message number.

The MSGCLAS installation option specifies the message types that should post. Type A, C, D, and I are the default. Type A messages are critical error messages, and type B, C, D, and I are informational messages.

'B' messages are helpful in tuning specific applications. If they are not enabled as an installation default, then BMSG can be specified as a runtime parameter.

Ajay Baghel · Posted: Thu Dec 17, 2009 8:58 pm

Thanks Alissa.