Workbench Execution with Parallel Group Type

[Former Member]

I created a replication job in Workbench 4.1 to migrate 16 tables - ODBC sources (for AS400) and Microsoft SQL Server targets within a single replication group.  I can select Type to either Parallel or Sequential for the replication group:

I set Type to Parallel and when executing, I observe that 8 of the 16 tables begin processing and as each completes another of the remaining begins so there are always 8 tables being processed until there are no longer tables to process.

If I test with two separate replication jobs each with 8 of the 16 tables with Parallel set and execute at the same time, both jobs load 8 tables in parallel so that 16 are being loaded at once.

I would like to understand how the number of source/target replications running in parallel within a Workbench replication job is determined and/or set (in my case, 8).  Is that within the tool at all or is it strictly from the database?

[abhi2636 · Accepted solution]

Hi Robert,

I hope that depends on the Job server's no. of engine processes.

To see the no. of engine process assigned to your Job server,

Go to 'Tools' Menu---> 'Options'--> Expand 'Job Sever'--> 'Environment', as shown in the attached pic.

Hope this helps you.

Regards,

Abhi

[Former Member · Accepted solution]

Yes, that is it.  I changed the value to 4 and observed only 4 processing in parallel.  Thank you.