Transaction considerations: The SET CURRENT DEGREE statement is not a commitable operation. ROLLBACK has no effect on CURRENT DEGREE.
Initial current degree: The initial value of CURRENT DEGREE is equal to the parallelism degree in effect from the CHGQRYA CL command, PARALLEL_DEGREE parameter in the current query options file (QAQQINI), or the QQRYDEGREE system value.
Parallelism degree precedence: The parallelism degree can be controlled in several ways. The actual parallelism degree used is determined as follows:
For more information, see Database Performance and Query Optimization.
Current degree scope: The scope of CURRENT DEGREE is the job.
Parallel limitations: If the DB2(R) UDB Symmetric Multiprocessing feature is not installed, a warning is returned and parallelism is not used.
Some SQL statements cannot use parallelism.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.