Overview of ingest-related tasks

This section provides a high-level overview of the main setup and operational tasks related to using the ingest utility.

Setting up ingest middleware
  1. Decide where to run the ingest utility

    You can run ingest jobs on an existing machine or from a stand-alone machine. For more information, see Deciding where to run the ingest utility

  2. Install the ingest utility (part of the Db2 Data Server Runtime Client and the Db2 Data Server Client).

    If you decide to install the ingest utility on a new, stand-alone machine, run the install for the Db2 client image.

Developing a process to populate a table
  1. (If required) Address code page issues

    Depending on whether the same code page is used by the input data, the Db2 client, and the Db2 server, there may be some user actions to take before running an INGEST command. For more information, see Code page considerations for the ingest utility.

  2. Set up to handle the restart of failed INGEST commands

    To make an ingest operation restartable, you need to create a restart log table before issuing the INGEST command. For more information, see Creating the restart table.

  3. Write an INGEST command

    Issue the INGEST command along with the mandatory parameters, like the input source and data type, and various optional parameters. For a detailed description of the command syntax and usage, as well as examples, see Ingesting data and INGEST.

  4. Set up to process an ongoing stream of ingest jobs

    If you want to easily call a pre-written INGEST command, create a script for the command and call it when necessary. For more information, see Scenario: Processing a stream of files with the ingest utility

Performing operational tasks
(Optional) Optimizing performance