Syntax options: COMMIT EVERY TABLE | COMMIT EVERY n ROWS Specifies whether the IMPORT statement commits entire tables, or commits a certain number of rows at regular intervals. If you use the COMMIT EVERY n ROWS clause, you can supply a value from 1 to 2147483647 for n. The default is COMMIT EVERY TABLE. If you use the COMMIT EVERY n ROWS clause, the table will be left with a partial set of rows if the IMPORT process fails. NOTE If the table being imported includes a storage map with the PLACEMENT VIA INDEX clause, then the COMMIT EVERY clause is ignored for that table. A message is displayed to inform the database administrator of the tables that did not have COMMIT EVERY applied. This condition is shown in Example 6.