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
 

 

Parameter settings for SYNCSORT to perform SORT fast.

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

New User


Joined: 25 Jun 2009
Posts: 2
Location: Chennai

PostPosted: Fri Jul 10, 2009 12:34 pm    Post subject: Parameter settings for SYNCSORT to perform SORT fast.
Reply with quote

I'm sorting a dataset with 95 million records. Right now I'm using SYNCSORT with parameter VSCORET=24M and DYNALLOC = (SYSDA, 320), even then the runtime is going almost some 1.5hr and cpu time is almost 10 mins. Are there any parameters that I can tune so that the run time and cpu time will get reduced.


Thanks
Vishwa
Back to top
View user's profile Send private message

Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Fri Jul 10, 2009 7:38 pm    Post subject:
Reply with quote

I think you're getting pretty good CPU time for 95 million recs.

Run time is dependent on external factors that you probably cannot control, such as contention with other workloads, etc.

If you post the sort msgs from SYSOUT, perhaps someone could offer more specific suggestions.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Sat Jul 11, 2009 12:08 am    Post subject: Re: Parameter settings for SYNCSORT to perform SORT fast.
Reply with quote

VISWANATHPETA wrote:
I'm sorting a dataset with 95 million records. Right now I'm using SYNCSORT with parameter VSCORET=24M and DYNALLOC = (SYSDA, 320), even then the runtime is going almost some 1.5hr and cpu time is almost 10 mins. Are there any parameters that I can tune so that the run time and cpu time will get reduced.

First of all, DYNALLOC=(SYSDA,320) does not contain a valid specification for the number of SORTWK data sets that can be allocated. The maximum value is 255.

Please forward me the complete and unedited job listing as a text attachment to alissa.margulies@syncsort.com and I would be happy to further assist you with tuning this application.

Regards,
Back to top
View user's profile Send private message
VISWANATHPETA

New User


Joined: 25 Jun 2009
Posts: 2
Location: Chennai

PostPosted: Tue Jul 14, 2009 10:42 am    Post subject:
Reply with quote

Hi,

Thanks for the Reply.

Regards,
Viswanath
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 JTS parameter Shashank Chaubey JCL & VSAM 2 Thu Jul 13, 2017 4:15 pm
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm


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