DB2Degree CLI/ODBC and IBM data server driver configuration keyword

Sets the degree of parallelism for the execution of SQL statements.

db2cli.ini keyword syntax:: DB2Degree = 0 | integer value from 1 to 32767 | ANY
IBM data server driver configuration file (db2dsdriver.cfg) syntax:: <parameter name="DB2Degree" value="0 | integer value from 1 to 32767 | ANY"/>

Attention: The IBM data server driver configuration file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.

Default setting:: No SET CURRENT DEGREE statement is issued.
Only applicable when:: connecting to a cluster database system.
Usage notes:

If the value specified is anything other than 0 (the default) then CLI will issue the following SQL statement after a successful connection:

 
SET CURRENT DEGREE value

This specifies the degree of parallelism for the execution of the SQL statements. The database manager will determine the degree of parallelism if you specify ANY.