CURRENT DEGREE
CURRENT DEGREE specifies the degree of parallelism for the execution of queries that are dynamically prepared by the application process.
The data type of the register is CHAR(3) and the only valid values are 1 (padded on the right with two blanks) and ANY.
If the value of CURRENT DEGREE is 1 when a query is dynamically prepared, the execution of that query will not use parallelism. If the value of CURRENT DEGREE is ANY when a query is dynamically prepared, the execution of that query can involve parallelism.
The initial value of CURRENT DEGREE is determined by the value of field CURRENT DEGREE on installation panel DSNTIP8. The default for the initial value of that field is 1 unless your installation has changed it to be ANY by modifying the value in that field. The initial value of CURRENT DEGREE in a user-defined function or stored procedure is inherited according to the rules in Table 1.
You can change the value of the register by executing the statement SET CURRENT DEGREE.
CURRENT DEGREE is a register at the database server. Its value applies to queries that are dynamically prepared at that server and to queries that are dynamically prepared at another DB2® subsystem as a result of the use of a DB2 private connection between that server and that DB2 subsystem.
SET CURRENT DEGREE = '1';