SYNCTOOL better than SYNCSORT?

Amit_Singh · New User Joined: 23 Jul 2014 Posts: 3 Location: india

Hi There!

I was working on a project and came across SYNCSORT and SYNCTOOL.
I also read that SYNCTOOL calls SYNCSORT in the background. I though had a question on the performance of SYNCTOOL.

Is the performance of SYNCTOOL better than SYNCSORT?

I mean if I have one million records in a PS, then does using SYNCTOOL will make processing faster than using SYNCSORT?

Amit_Singh · New User Joined: 23 Jul 2014 Posts: 3 Location: india

Any replies? I really need to get this information..i have been searching the net..since no proper documentation of synctool is available im unable to find the required information

Bill Woodger · Posted: Wed Jul 23, 2014 12:28 pm

Since SyncTool won't work without SyncSort, I'm nott sure the question makes much sense in general.

Some SyncTool operators could be directly replaced by a SORT step: the advantage of having the operators is that multiple operators can be specified in the same step, whereas multiple executions of SORT require multiple steps.

There is probably some performance impact on this (SyncTool slower) but the easiest thing is for you to try it out if it is of such interest to you.

Amit_Singh · New User Joined: 23 Jul 2014 Posts: 3 Location: india

Thanks!

Yes it is of interest to me. I was thinking of running both the files through 2 jobs, one using syncsort other using synctool.

However, as you said that synctool helps us combinig some syncsort steps into one step, so is the time required for setting up individual steps using syncsort significant?

If there is some extra time that is required for setting up each step, the region, etc, in syncsort steps, maybe I can direct my study in that direction.