LOAD usually works in AUTOCOMMIT mode; i.e., each SQL statement entered by the user will be concluded with COMMIT, and statements such as DATALOAD always issue a COMMIT after a certain number of INSERT statements.
The control statement AUTOCOMMIT OFF prevents LOAD from concluding transactions. In this mode, SQL statements can be combined to form units that are committed or rolled back as a total. This mode is not only valid for SQL statements, but also for all LOAD statements except CATALOGEXTRACT/LOAD and TABLEEXTRACT/LOAD. The size of the log, however, determines the size of the datasets that may be loaded without a COMMIT.
The statement AUTOCOMMIT ON can be used to reestablish the normal state.