DB2 Version 10.1 for Linux, UNIX, and Windows

Terminating a failed ingest operation

If an INGEST command fails before completing and you do not want to restart it, reissue the INGEST command with the RESTART TERMINATE option. This command option cleans up the log records for the failed INGEST command.

Before you begin

The user ID terminating the failed INGEST command must have SELECT and DELETE privilege on the restart log table.

Procedure

To terminate a failed INGEST operation, reissue the INGEST command. Specify the RESTART TERMINATE parameter with the appropriate string.

Results

After the restarted INGEST command completes, you can reuse the RESTART NEW string on a later INGEST command.

Example

The following INGEST command failed:

INGEST FROM FILE my_file.txt 
   FORMAT DELIMITED 
   (
      $field1 INTEGER EXTERNAL,
      $field2 DATE 'mm/dd/yyyy',
      $field3 CHAR(32)
   )
   RESTART NEW 'ingestjob001'
   INSERT INTO my_table 
      VALUES($field1, $field2, $field3);

The DBA does not want to restart the INGEST command, so they terminate it with the following command (which includes the RESTART TERMINATE parameter):

INGEST FROM FILE my_file.txt 
   FORMAT DELIMITED 
   (
      $field1 INTEGER EXTERNAL,
      $field2 DATE 'mm/dd/yyyy',
      $field3 CHAR(32)
   )
   RESTART TERMINATE 'ingestjob001'
   INSERT INTO my_table 
      VALUES($field1, $field2, $field3);