High-speed ingest utility allows movement of real-time data without affecting availability

The ingest utility is a new client-side DB2® utility specializing in the high speed, continuous ingestion of data from sources like files and pipes into DB2 target tables and for frequently populating data warehouse tables with minimal impact on concurrent user workload and data server resources.

The ingest utility allows you to roll-in business-critical data, even while long-running queries are accessing the table. In other words, there is no trade-off between data concurrency and data availability. The ingest utility works by continuously pumping data into DB2 tables using SQL array inserts, updates, and deletes until sources are exhausted. All ingest operations are, by default, restartable in the event of a failure. As with the load utility, users have the option of either restarting or terminating failed ingest operations.

Unlike some batch loaders that support only a few basic SQL statements, the INGEST command supports a variety of SQL operations, including insert, update, merge, replace, and delete. In addition, you can use SQL expressions to build individual column values from more than one data field.