Parallel Processing

If using parallel Extract and/or Replicat processes, keep related DDL and DML together in the same process stream to ensure data integrity. Configure the processes so that:

• all DDL and DML for any given object are processed by the same Extract group and by the same Replicat group.

• all objects that are relational to one another are processed by the same process group.

For example, if repe processes DML for EMPLOYEES, then it should also process the DDL for EMPLOYEES. If APPRAISAL has a foreign key to EMPLOYEES, then its DML and DDL operations also should be processed by repe.

If an Extract group writes to multiple trails that are read by different Replicat groups, Extract sends all of the DDL to all of the trails. Use each Replicat group to filter the DDL by using the filter options of the DDL parameter in the Replicat parameter file.