Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
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
 
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
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 OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us