The Ingest utility (also known as Continuous Data Ingest, or CDI) is a high-speed, client-side, highly configurable, multithreaded DB2 utility that streams data from files and pipes into DB2 target tables by using SQL-like commands. Because the Ingest utility can move large amounts of real-time data without locking the target table, you do not need to choose between the data currency and availability.
The DB2 Ingest utility meets the current modern data warehouse expectations through several key capabilities:
- Concurrent data access: You can run concurrent SQL statements against the DB2 tables that are being loaded because the Ingest utility always uses row-level locking. You do not have to choose between tweaking data ...
