Utilities 7-17
Syntax
Theerror log file specified by the -l flag stores any input file rows that dbload
cannot insert into the database, as well as diagnostic information.
Tables specified in the command file are locked during loading, preventing
other users from modifying data in the table, unless you specify the -r flag.
Tablelocking reduces the number of locks needed during the load but at the
price of reduced concurrency. If you are planning to load a large number of
rows, use table locking and load during nonpeak hours.
If your database supports transactions,dbload commits a transaction after
every100 rows are inserted. To modify this default value, specify a batch size
(seepage 7-19).
The dbload default value for bad-row limit is 10. This means that after
dbload reads the eleventh bad row, it terminates. Ifdbload is loading data
rowsinto a database with transactions when the bad-row limit is reached, the
default condition is for dbload to commit all rows that have been inserted
since the last transaction. To modify the bad-row limit or to change the
default condition from “always commit” to “prompt for instructions,” refer
topage 7-20.
If your most recentdbload session ended prematurely, you can resume
loadingwith the next record in the file by specifying the starting line number
in the command-line syntax (seepage 7-18).
Ifyou press the Interrupt key, dbload terminates and discards any new rows
thathave been inserted but not yet committed to the database (if the database
has transactions).