Performance considerations for ingest operations

Use the following set of guidelines to help performance tune your ingest jobs.

Field type and column type

Define fields to be the same type as their corresponding column types. When the types are different, the ingest utility or DB2® must convert the input data to the column type.

Materialized query tables (MQTs)

If you ingest data into a table that is a base table of an MQT defined as REFRESH IMMEDIATE, performance can degrade significantly due to the time required to update the MQT.

Row size

For tables with a small row size, increase the setting of the commit_count ingest configuration parameter; for tables with a large row size, reduce the setting of the commit_count ingest configuration parameter.

Other workloads

If you are executing the ingest utility with another workload, increase the setting of the locklist database configuration parameter and reduce the setting of the commit_count ingest configuration parameter