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.
All
No
ENABLE_AUTOCOMMIT={
N
|Y}
N
.
PowerExchange commits data to the target only at each commit interval during a bulk data movement session.
Y.
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
Advanced
settings of the
Config Object
tab.
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:
Reduce the
Commit Interval
sessions property.
Based on the error message that you receive, tune the database.