IBM Mainframe Forum

hi,

One of the step of my job is merges two files and writes to one output file in sorted order using SyncSort.

The number of records in each file is about 30 millions . it is taking 14 minutes 37 seconds.

Please help to decrease this CPU usage time to minimum level.

Thanks
VGL

You have posted nothing to indicate that this job is taking an excessive amount of CPU time. Show us some JCL, control cards, and sysout.

The sort packages are NOT noted for wasting a lot of time, so your Syncsort time may be close to the minimum already. Is the 14 minutes 37 seconds elapsed time or CPU time? And remember, handling 60 million records will take a good bit of time, no matter what you want.

As Robert says, things like sorts are pretty nippy already. If you are just merging two files, that's a pretty simple thing which doesn't leave much room for optimisation. It reads a record on file 1, reads a record on file 2, compares the keys, writes out the lower key, reads the file that had the lower key, repeats until end.

How often will the job be running?

How many key fields are defined?

What type of files are the input and output? Ensure optimal blocking.

Try to dig up a manual. I'm sure it will have advice on treating big files.

Don't expect any big savings, so consider the first question, which is asking "is it worth it"?

Without seeing any of the JCL or sort messages, the only recommendation I can make to possibly improve CPU time would be to pass the CPU optimization parm...

If you would like further assistance tuning this application, please email the COMPLETE job listing to me at alissa.margulies@syncsort.com and I would be happy to review it for you.

Regards,