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