
Chapter 8. Ingest utility 129
After deciding to create an INGEST command by using the INSERT keyword
(and letting the export process isolate the new rows), the DBAs enhance their
INGEST command to include fault tolerance.
At the core of their strategy is the INGEST command, shown in Example 8-5.
The command includes clauses to log messages, and, in the event of failure,
collect information so the job can be restarted from the point of the last commit.
Example 8-5 Great Toque Outdoors’ INGEST command
INGEST FROM FILE /home/db2inst1/data/data.del
FORMAT DELIMITED
(
$field1 INTEGER EXTERNAL,
$field2 INTEGER EXTERNAL,
$field3 INTEGER EXTERNAL,