Query Parallelism in DB2 for z/OS

Project and Program: Information Management, Database

Tags: Proceedings, SHARE in Anaheim 2011, 2011

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

 

Presenter(s): Bryan Smith, IBM Corporation

 

Back to Proceedings File Library