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
- 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
- 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.
- Decide where to run the ingest utility
- Developing a process to populate a table
- (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.
- 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.
- 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.
- 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
- (If required) Address code page issues
- Performing operational tasks
- (If required) Addressing a failed INGEST command
If an ingest job fails, you have the option of restarting or terminating the command. For more information, see Restarting a failed ingest operation or Terminating a failed ingest operation.
- Monitoring an INGEST command
For more information, see Monitoring ingest operations.
- (If required) Addressing a failed INGEST command
- (Optional) Optimizing performance
- Review tunable configuration parameters for the INGEST command.
- Modify your INGEST command to meet high performance
requirements.
For more information, see Performance considerations for ingest operations.