Programming for parallel processing

You can significantly reduce the response time for data or processor-intensive queries by taking advantage of the ability of DB2® to initiate multiple parallel operations when it accesses data from a table or index in a partitioned table space.

  • Parallel processing
    DB2 can initiate multiple parallel operations when it accesses data from a table or index in a partitioned table space.
  • Partitioning for optimal parallel performance
    The following are general considerations for how to partition data for the best performance for parallel processing. DB2 does not always select an access path that uses parallelism, regardless of how you partition the data.
  • Enabling parallel processing
    Queries cannot take advantage of parallelism unless you enable parallel processing.
  • Restrictions for parallelism
    Parallelism is not used for all queries; for some access paths, incurring parallelism overhead makes no sense. Similarly, certain access paths that would reduce the effectiveness of parallelism are removed from consideration when parallelism is enabled.
Parent topic: Programming applications for performance
Related tasks:
Interpreting query parallelism
Tuning parallel processing