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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm
No new posts JCL sort Match and NoMatch rakeshsekar1987 SYNCSORT 2 Thu Feb 02, 2017 10:26 pm


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