Syntax options: BATCH UPDATE | NO BATCH UPDATE Specifies whether the IMPORT statement stores user data and indexes using batch-update transactions (BATCH UPDATE) or read/write transactions for each table (NO BATCH UPDATE). The NO BATCH UPDATE option is the default. A batch-update transaction is faster but does not perform recovery-unit journaling, which means you cannot recover the database in the event of a failure during the IMPORT operation. With the NO BATCH UPDATE option, you can recover the database. For more information about batch-update transactions, see the SET_TRANSACTION statement.