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 Profile Log in to check your private messages Log in
 
Need Syncsort Tuning Techniques Document

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

New User


Joined: 27 Apr 2009
Posts: 26
Location: addison

PostPosted: Wed Nov 25, 2009 5:55 pm    Post subject: Need Syncsort Tuning Techniques Document
Reply with quote

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

Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Dec 01, 2009 4:28 am    Post subject:
Reply with quote

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:

Code:
//$ORTPARM DD *
 MSG=AP,LIST,BMSG
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Dec 03, 2009 10:01 pm    Post subject:
Reply with quote

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

Global Moderator


Joined: 27 Oct 2009
Posts: 2441
Location: Netherlands, Amstelveen

PostPosted: Thu Dec 03, 2009 10:27 pm    Post subject:
Reply with quote

For variable record length files you could use HISTOGRM to see how your records are distributed. And accordingly use the L6 and L7 parameters.
Back to top
View user's profile Send private message
chandramouliravi

New User


Joined: 27 Apr 2009
Posts: 26
Location: addison

PostPosted: Sat Dec 05, 2009 1:57 pm    Post subject: Reply to: Need Syncsort Tuning Techniques Document
Reply with quote

Hi all,

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

Chandramouli
Back to top
View user's profile Send private message
Ajay Baghel

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Sat Dec 05, 2009 6:51 pm    Post subject:
Reply with quote

Hi Alissa,

Quote:
Please be sure that 'B' messages are enabled

What is the use of the 'B' message and what would that do?

Thank you,
Ajay
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Dec 07, 2009 9:57 pm    Post subject:
Reply with quote

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

Active User


Joined: 25 Apr 2007
Posts: 205
Location: Bangalore

PostPosted: Thu Dec 17, 2009 8:58 pm    Post subject:
Reply with quote

Thanks Alissa.
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 Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Asking you what you do for SMF SCRT r... Alan Playford All Other Mainframe Topics 12 Mon Jul 17, 2017 8:34 pm
No new posts Batch job tuning sgandhla Testing & Performance analysis 5 Fri Mar 24, 2017 9:41 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 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

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