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.