The CURRENT DEGREE special register specifies the degree of I/O or Symmetric MultiProcessing (SMP) parallelism for the execution of queries, index creates, index rebuilds, index maintenance, and reorganizes. CURRENT DEGREE affects static and dynamic SQL statements. The data type of the register is CHAR(5). The valid values include:
Use of parallel processing and the number of tasks used is determined based on the number of processors available in the system, this job's share of the amount of active memory available in the pool in which the job is run, and whether the expected elapsed time for the operation is limited by CPU processing or I/O resources. The database manager chooses an implementation that minimizes elapsed time based on the job's share of the memory in the pool.
The value can be changed by invoking the SET CURRENT DEGREE statement. For details about this statement, see SET CURRENT DEGREE.
The initial value of CURRENT DEGREE is determined by the current degree in effect from the CHGQRYA CL command, PARALLEL_DEGREE parameter in the current query options file (QAQQINI), or the QQRYDEGREE system value.
The following statement inhibits parallelism:
SET CURRENT DEGREE = '1'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.