Sends data to the PowerExchange Listener and waits for a success or no success response before sending more data. This mode sends data synchronously to the PowerExchange Listener rather than buffering the data. After sending an SQL request, the sender waits for the response from PowerExchange before sending the next SQL request.

This mode provides good error recovery but has slower data transfer rates than the other modes.

To stop session execution when the session encounters non-fatal errors, specify a value greater than 0 in the

Stop on errors

session attribute on the

Config Object

tab of the

Edit Tasks

dialog box.

If you plan to run CDC workflows with the

Resume from last checkpoint

recovery strategy and write data to targets with a PWX batch or relational connection, specify

Confirm Write On

as the write mode for the target connection.

Sends data asynchronously to the PowerExchange Listener by buffering the data. This mode does not wait for a success or no success response. While this mode provides a faster data transfer speed than

Confirm Write On

, it does not provide the ability to determine which SQL statement failed in error situations. If an error occurs, you must reload the entire table if an error occurs to ensure data integrity. Use this setting only if you can reload tables.

Combines the speed of

Confirm Write Off

with the error detection of

Confirm Write On

. This mode buffers the data and sends it asynchronously to the PowerExchange Listener. When an SQL error occurs, PowerExchange creates a reject file on the target machine, which contains the data records that the writer could not write to the target. View the file contents to identify and correct the errors without reloading the entire table. You can also specify how to handle specific SQL return codes. To stop session execution when the session encounters non-fatal errors, specify a value greater than 0 in the

Stop on errors

session attribute on the

Config Object

tab of the

Edit Tasks

dialog box.

The

Asynchronous with Fault Tolerance

option is available only for PWX DB2zOS, PWX DB2i5OS, PWX DB2LUW, PWX MSSQLServer, and PWX Oracle relational connections. However, for relational targets on Linux, UNIX, and Windows, sessions usually load data directory to the targets by using the native drivers instead of a PWX relational connection.