Enabling mixed parallelism with queries that reference nicknames

You can improve the performance of queries that reference local and remote data by the use of intrapartition and interpartition parallelism.

About this task

Procedure

To enable interpartition parallelism on a partitioned federated server:
  1. Issue the CREATE WRAPPER or ALTER WRAPPER statement with the DB2_FENCED option set to Y.
  2. Optional: Set up a computational partition group to enable parallelism for nickname-only joins.
To enable intrapartition parallelism on a federated server:
  1. Set the MAX_QUERYDEGREE database configuration parameter to a value greater than 1.
  2. Set the DFT_DEGREE database configuration parameter to a value greater than 1, or you must set the special register CURRENT DEGREE. If you set the DFT_DEGREE parameter to ANY, the default level of intrapartition parallelism equals the number of SMP processors on the computer.