DB2 Version 9.7 for Linux, UNIX, and Windows

DB2Degree CLI/ODBC 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
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.