Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

ENABLE_AUTOCOMMIT Statement

ENABLE_AUTOCOMMIT Statement

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.

0 COMMENTS

We’d like to hear from you!