PowerExchange Interfaces for PowerCenter

10.4.1
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Commit Processing for Bulk Data Movement Sessions

During a bulk data movement session, by default PowerExchange commits data to the target each time the commit interval that is defined in the session properties is reached.

You might need to change how frequently PowerExchange commits data to the target. If commits are issued too infrequently, bulk data movement sessions with a nonrelational target might fail with an out-of-memory error.

To prevent or correct this problem, perform one of the following actions:

Reduce the Commit Interval session property. The default is 10,000 rows.

Tune the database based on the error message that you receive.

If necessary, you can define ENABLE_AUTOCOMMIT=Y in the DBMOVER configuration file on the client machine. Defining ENABLE_AUTOCOMMIT=Y instructs PowerExchange to commit data to the target each time the data buffer becomes full. You set the data buffer size for a session by defining the Default Buffer Block Size session property in the Advanced settings of the Config Object tab.

Defining ENABLE_AUTOCOMMIT=Y alters the standard commit and rollback behavior for PowerCenter sessions. Avoid using this statement if possible.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Commit Processing for Bulk Data Movement Sessions

Commit Processing for Bulk Data Movement Sessions