The ENABLE_AUTOCOMMIT statement controls whether PowerExchange commits data to the target each time the data buffer becomes full during a bulk data movement session.
PowerExchange commits data to the target only at each commit interval during a bulk data movement session.
PowerExchange commits data to the target each time the data buffer becomes full or the commit interval that is defined in the session properties is reached, whichever occurs first. You set the data buffer size for a session by defining the
Default Buffer Block Size
session property in the
settings of the
Default is N.
Avoid using this statement if possible. Defining ENABLE_AUTOCOMMIT=Y alters the standard commit and rollback behavior for PowerCenter sessions. Instead of this statement, use one of the following methods to avoid out-of-memory errors during bulk data movement sessions:
Based on the error message that you receive, tune the database.