Enabling index I/O parallelism for INSERT operations
You can enable I/O parallelism for INSERT operations to improve insert workload performance on tables with multiple indexes.
About this task
When you insert new data into a table with multiple indexes, each index must be updated individually. However, If you enable index I/O parallelism, the indexes can be updated in parallel. Db2 can use index I/O parallelism only on universal table spaces and partitioned table spaces.
Usually
index I/O parallelism is used only for three or more indexes. However, index I/O parallelism can
be used for two indexes for tables that are defined with the following options:
- APPEND
- MEMBER CLUSTER
- ORGANIZE BY HASH
Procedure
To enable parallel index I/O:
Specify YES for the value of the INDEX_IO_PARALLELISM subsystem parameter.
What to do next
If I/O parallelism is enabled and IFCID 0358 is turned on, Db2 writes a record to IFCID 0358 when a parallel I/O index insert completes. The record contains the database ID and OBID of the table, and a page set ID of the index that was updated last.