database - db2 V10.5 Enabling parallelism steps -

i have enabled intra_parallel parameter yes.

and update dft_degree parameter 8 (8 processor on server 1 core each).

now confuse parameter max_querydegree parameter.

should update parameter 8 or not? 1.

dft_degree specifies value used current degree special register. maximum query degree of parallelism (max_querydegree) configuration parameter specifies maximum query degree of intrapartition parallelism sql queries. default max_querydegree -1 means any. lets optimizer decide max parallelism query start @ dft_degree value.