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