Query Parallelism in DB2 for z/OS

Query parallelism was implemented in stages.

 

• DB2 Version 3 introduced query I/O parallelism, which enables a much greater I/O throughput for I/O-intensive queries.
• DB2 Version 4 introduced query CP parallelism, which added the capability to parallelize the processing operations needed to service a query.  Queries requiring large sorts, joins, or complex computations can benefit by exploiting the power of a multi-processor system.
• DB2 Version 5 introduced Sysplex query parallelism, which extends query CP parallelism "parallel tasks" to run across all DB2 members in the data sharing group.  Sysplex query parallelism can use the combined processing power available within a Parallel Sysplex.

• DB2 9 and 10 continue to add additional functionality for query parallelism

Tracks: Applications Programming, Software Architecture, Storage Administration and z/OS Systems Programming