DB2 parallelism, the beauty and beast in one

Date: 
Tuesday, 28 June, 2005 - 09:00 - 09:45
Speaker: 
Klaas Brant

SQL can be processed in parallel by DB2.  How does this work? What is the difference between IO parallelism and CPU parallelism? How do I ask for parallelism and how can I find out it has will be or has been used? Which settings and parameters are important? Klaas will show you that processing SQL can be a great feature of DB2 but there are cases when parallelism is very bad option.
Topics: Types of parallelism, asking for parallelism (degree), parameters that influence parallelism (Bufferpools, ZPARM, SQL), Monitoring and predicting (Explain and accounting trace), Rules for using parallelism

 

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023