Deciding where to run the ingest utility

The ingest utility is included as a part of the Db2® client install. You can run it from either the client or the server.

About this task

There are two choices for where to run the ingest utility:
On an existing server in the data warehouse environment
There are two choices for where to run ingest jobs within this type of setup:
  • On the Db2 coordinator partition (the database partition server to which applications will connect and on which the coordinating agent is located)
  • On an existing ETL (extract, transform, and load) server
On a new server
There are two choices for where to run ingest jobs within this type of setup:
  • On a server that is only running the ingest utility
  • On a server that is also hosting an additional Db2 coordinator partition that is dedicated to the ingest utility.
There are a number of factors that can influence where you decide to install the ingest utility:
  • Performance: Having the ingest utility installed on its own server has a significant performance benefit, so this would be suitable for environments with large data sets.
  • Cost: Having the ingest utility installed on an existing server means that no additional expenses are incurred as a result of using it.
  • Ease of administration
Note: INGEST operations with a remote storage object specified, when performed on a remote client host (different from the database server host) are deprecated and will be removed in a future release. See Deprecated Functionality 11.5.7.